CMDB Sync Properties

The following cmdb columns will be populated for the given CI Classes.

  • ServiceNow Column: This is the column that will be populated in ServiceNow

  • vROps Type: This is indicates where the column value is taken from in vROps.

The following options are available:

  • IDENTIFIER: an identifier on the vROps resource

  • PROPERTY: a property on the vROps resource

  • METRIC: a metric on the vROps resource

  • STATIC_STRING: a static string that will always return the same value (that value is shown in the vROps key column of the table)

  • vROps Key: The key for the attribute found in vROps

  • Conversion: A description of the conversion used on the vROps attribute before sending it to ServiceNow

  • Native Attribute: Returns true if this is an attribute that is present out-of-the-box on the ServiceNow CI Class. If this is false, it is added by the Discovery plugin. If you are not using the discovery plugin, but want to use the attribute, add the column to the CI Class definition cmdb_ci_vcenter_datastore (VMWARE::Datastore)

ServiceNow Column

vROps Type

vROps Key

Conversion

Native Attribute

name

IDENTIFIER

VMEntityName

None

true

discovery_source

STATIC_STRING

VMwareTVS

None

true

morid

IDENTIFIER

VMEntityObjectID

None

true

accessible

PROPERTY

summary|accessible

None

true

vcenter_ref

PROPERTY

summary|parentVcenter

None

true

type

PROPERTY

summary|type

None

true

capacity

PROPERTY

summary|diskCapacity

None

true

freespace

METRIC

diskspace|freespace

None

true

url

PROPERTY

summary|path

None

true

object_id

IDENTIFIER

VMEntityObjectID

None

true

vcenter_uuid

IDENTIFIER

VMEntityVCID

None

true

cmdb_ci_vmware_instance (VMWARE::VirtualMachine)

ServiceNow Column

vROps Type

vROps Key

Conversion

Native Attribute

vm_instance_uuid

IDENTIFIER

VMEntityInstanceUUID

None

true

template

PROPERTY

summary|config|isTemplate

None

true

name

IDENTIFIER

VMEntityName

None

true

cpus

PROPERTY

config|hardware|numCpu

None

true

disks

PROPERTY

config|numVMDKs

None

true

disks_size

PROPERTY

config|hardware|diskSpace

None

true

memory

PROPERTY

config|hardware|memoryKB

Convert KB to MB

true

nics

PROPERTY

summary|config|numEthernetCards

None

true

state

PROPERTY

summary|runtime|powerState

None

true

discovery_source

STATIC_STRING

VMwareTVS

None

true

object_id

IDENTIFIER

VMEntityObjectID or VMEntityInstanceUUID

None

true

vcenter_uuid

IDENTIFIER

VMEntityVCID

None

true

cmdb_ci_esx_server (VMWARE::HostSystem)

ServiceNow Column

vROps Type

vROps Key

Conversion

Native Attribute

name

IDENTIFIER

VMEntityName

None

true

asset

PROPERTY

hardware|vendorModel

None

true

connection_state

PROPERTY

runtime|connectionState

None

false

connection_id

PROPERTY

summary|hostuuid

None

false

cpu_core_count

PROPERTY

hardware|cpuInfo|numCpuCores

None

true

cpu_count

PROPERTY

hardware|cpuInfo|numCpuPackages

None

true

cpu_speed

PROPERTY

hardware|cpuInfo|hz

None

true

cpu_type

PROPERTY

cpu|cpuModel

None

true

discovery_source

STATIC_STRING

VMwareTVS

None

true

disk_space

METRIC

diskspace|total_capacity

None

true

hyper_threading

PROPERTY

config|hyperThread|available

None

false

ip_address

PROPERTY

net|mgmt_address

None

true

manufacturer

PROPERTY

hardware|vendor

None

true

model_id

PROPERTY

hardware|vendorModel

None

true

os_version

PROPERTY

summary|version

None

true

power_state

PROPERTY

runtime|powerState

None

false

ram

PROPERTY

hardware|memorySize

Convert KB to MB

true

serial_number

PROPERTY

hardware|serialNumber

None

true

vcenter_ref

PROPERTY

summary|parentVcenter

None

true

object_id

IDENTIFIER

VMEntityObjectID

None

true

vcenter_uuid

IDENTIFIER

VMEntityVCID

None

true

cmdb_ci_vcenter_datacenter (VMWARE::Datacenter)

ServiceNow Column

vROps Type

vROps Key

Conversion

Native Attribute

name

IDENTIFIER

VMEntityName

None

true

discovery_source

STATIC_STRING

VMwareTVS

None

true

morid

IDENTIFIER

VMEntityObjectID

None

true

vcenter_ref

PROPERTY

summary|parentVcenter

None

true

object_id

IDENTIFIER

VMEntityObjectID

None

true

vcenter_uuid

IDENTIFIER

VMEntityVCID

None

true

cmdb_ci_vcenter_cluster (VMWARE::ClusterComputeResource)

ServiceNow Column

vROps Type

vROps Key

Conversion

Native Attribute

name

IDENTIFIER

VMEntityName

None

true

discovery_source

STATIC_STRING

VMwareTVS

None

true

morid

IDENTIFIER

VMEntityObjectID

None

true

effectivehosts

METRIC

summary|number_running_hosts

None

true

vcenter_ref

PROPERTY

summary|parentVcenter

None

true

numhosts

METRIC

summary|total_number_hosts

None

true

totalcpu

METRIC

cpu|haTotalCapacity_average

None

true

totalmemory

METRIC

mem|totalCapacity_average

None

true

numcpucores

METRIC

cpu|corecount_provisioned

None

true

drs_behavior

PROPERTY

configuration|drsConfig|defaultVmBehavior

None

true

drs_enabled

PROPERTY

configuration|drsconfig|enabled

None

true

drs_vmotion_rate

PROPERTY

configuration|drsConfig|vmotionRate

None

true

object_id

IDENTIFIER

VMEntityObjectID

None

true

vcenter_uuid

IDENTIFIER

VMEntityVCID

None

true

cmdb_ci_vcenter (VMWARE::VMwareAdapter Instance)

ServiceNow Column

vROps Type

vROps Key

Conversion

Native Attribute

name

IDENTIFIER

VCURL

None

true

cmdb_ci_vcenter

STATIC_STRING

sys_class_name

None

true

fullName

PROPERTY

summary|vcfullname

None

true

url

IDENTIFIER

VCURL

Builds SDK URL from hostname

true

discovery_source

STATIC_STRING

VMwareTVS

None

true

instance_uuid

IDENTIFIER

VMEntityVCID

None

true

The following cmdb columns may be populated for the given Discovery CI Classes. Discovery classes can be either optional or required. Optional discovery classes are not required and if discovery has not been set up in the environment, they will not be included. If discovery is required, then then CI Class structure must include the required relation to the Cloud Service Account that discovery creates (even if you are not actively using discover).

Optional Discovery Class cmdb_ci_cloud_service_account (VMWARE::VMwareAdapter Instance)

ServiceNow Column

vROps Type

vROps Key

Conversion

account_id

IDENTIFIER

account_id

None

object_id

IDENTIFIER

object_id

None

datacenter_url

IDENTIFIER

VCURL

Convert hostname or IP to URL

datacenter_type

STATIC_STRING

cmdb_ci_vcenter_datacenter

None

CMDB Sync Relationships

The following relationships are made between CMDB CI sync classes. Relationships are displayed from the perspective of the parent object.

cmdb_ci_vcenter_datastore (VMWARE::Datastore)

Child CI Class

CI Relationship Type

cmdb_ci_esx_server

Used by::Uses

cmdb_ci_vmware_instance

Provides storage for::Stored on

cmdb_ci_vmware_instance (VMWARE::VirtualMachine)

Child CI Class

CI Relationship Type

cmdb_ci_vcenter_datacenter

Registered on::Has registered

cmdb_ci_vcenter_datacenter

Hosted on::Hosts

cmdb_ci_vcenter_datacenter (VMWARE::Datacenter)

Child CI Class

CI Relationship Type

cmdb_ci_vcenter_cluster

Contains::Contained by

cmdb_ci_vcenter_datastore

Contains::Contained by

cmdb_ci_vmware_instance

Contains::Contained by

cmdb_ci_esx_server

Contains::Contained by

cmdb_ci_vcenter_cluster (VMWARE::ClusterComputeResource)

Child CI Class

CI Relationship Type

cmdb_ci_esx_server

Members::Member of

cmdb_ci_vcenter (VMWARE::VMwareAdapter Instance)

Child CI Class

CI Relationship Type

cmdb_ci_vcenter_datacenter

Contains::Contained by

cmdb_ci_esx_server

Runs on::Runs

Discovery Resource cmdb_ci_cloud_service_account (VMWARE::VMwareAdapter Instance)

Parent CI Class

CI Relationship Type

cmdb_ci_vcenter_datacenter

Hosted on::Hosts