ServiceNow CMDB Integration
The Snow Integration Connector for ServiceNow CMDB populates the CMDB with the following types of asset information from the Snow License Manager web API to the ServiceNow dataset.
Computer
Target table: cmdb_ci_computer
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| CoreCount | Number of physical cores | Computer details -> Hardware | cpu_core_count |
| ProcessorCount | Number of processors | Computer details -> Hardware | cpu_count |
| ProcessorType | Processor make and model | Computer details -> Hardware | cpu_type |
| - | Constant set by the connector, value = "SnowSoftware" | - | discovery_source This is a reference to a global SnowSoftware entry in the sys_choice_list under cmdb_ci. |
| TotalDiskSpace | Total size of all hardware drives | Computer details -> Hardware | disk_space |
| Hypervisor | Hypervisor name | Computer details -> Information | x_snsab_snow_sam_i_hypervisorname |
| Full name + username (API member: MostRecentUser) | Last user that logged on to this computer | Computer details -> Users | x_snsab_snow_sam_i_last_logged_on_user |
| Manufacturer | Computer manufacturer | Computer details -> Information | manufacturer Note: Hardware manufacturers are not created by default. Matching data with a specific hardware manufacturer relies on an existing entry for the manufacturers in the core_company table. For computers and devices that cannot be matched with an existing entry, the field Manufacturer will be left blank during aggregation. Forcing hardware manufacturer data for computers and devices can be enabled in the Catalog transform map (CsvHwModelTransform), by setting Manufacturer->Choice Action to Create. Note that this action adds new company records to your core_company table and may duplicate or overwrite existing ones. |
| Model | Computer model | Computer details -> Information | model_id This is a reference to a model in the cmdb_hardware_product_model table |
| Full name + username (API member: MostFrequentUser) | The most frequent logged on user of this computer | Computer details -> Users | x_snsab_snow_sam_i_most_frequent_user |
| Name | Computer host name | Computer details | name |
| OperatingSystem | Installed operating system | Computer details | os Note: Operating systems are not added to the computer operating system choice list by default. After an import, you will see that computers will have a value in the Operating System field, but to change the value, you first have to add it to the choice list for operating systems. |
| Domain | Domain name, if this computer is member of a domain | Computer details -> Information | os_domain |
| OperatingSystemServicePack | Installed operating system service pack | Computer details | os_service_pack |
| PhysicalMemory | Total size of RAM | Computer details -> Hardware | ram |
| BiosSerialNumber | BIOS serial number | Computer details -> Hardware | serial_number |
| - | Computer ID in SLM | - | x_snsab_snow_sam_i_snow_computer_id |
| Organisation | Organization name | Computer details -> Information | x_snsab_snow_sam_i_snow_organization |
| - | Organization checksum | - | x_snsab_snow_sam_i_snow_org_checksum |
| IsVirtual | If this is a virtual computer | All computers -> Virtual | virtual |
| Status | Computer Status in SLM | computer -> Status | Snow Status |
| LastScanDate | Last time computer got scanned | computer -> Last Scanned | Most recent Discovery |
| IsServer | Whether or not a computer is server | computer -> Server | IsServer |
Logical disk
Target table: cmdb_ci_disk
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| Name | Computer host name | Computer details | computer |
| Logical disks (API member: SizeMb) | Logical disk size | Computer details -> Hardware | disk_space |
| Logical disks (API member: VolumeName) | Disk name | Computer details -> Hardware | drive_type |
| Logical disks (API member: Name) | Drive letter of the disk | Computer details -> Hardware | name |
| Logical disks (API member: FreeSpaceMb) | Logical disk free space | Computer details -> Hardware | free_space |
| - | Constant set by the connector, value = "SnowSoftware" | - | discovery_source This is a reference to a global SnowSoftware entry in the sys_choice_list under cmdb_ci. |
Mobile device
Target table: cmdb_ci_comm
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| Organisation | Organization of the device | Mobile device details -> Information | company |
| - | Constant set by the connector, value = "SnowSoftware" | - | discovery_source This is a reference to a global SnowSoftware entry in the sys_choice_list under cmdb_ci. |
| Manufacturer | Manufacturer of the device | Mobile device details -> Information | manufacturer |
| Model | Model number of the device | Mobile device details -> Information | model_number |
| Name | Name of the device | Mobile device details | name |
| Operating system | Operating system on the device | All mobile devices list | x_snsab_snow_sam_i_operatingsystem |
| Phone number | Phone number of the device | All mobile devices list | phone_number |
| Mobile device type | Device type; phone or tablet | All mobile devices list | type |
Network adapter
Target table: cmdb_ci_network_adapter
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| Name | Computer host name | Computer details | cmdb_ci |
| Network adapter (API member: IpAddress) | IP address of the computer | Computer details -> Hardware | ip_address* |
| Network adapter (API member: MacAddress) | MAC address of the computer | Computer details -> Hardware | mac_address |
| Network adapter (API member: Name) | Name of the network adapter | Computer details -> Hardware | name |
Relationship 1 (DCC and Hosts)
Target table: cmdb_rel_ci
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| Name | Name of the datacenter or cluster | Datacenters and clusters | child |
| Host computer name | Name of the physical computer (host) within the dcc/cluster | Datacenters and clusters -> Hosts | parent |
| - | Checksum generated from the other variables in this table. | - | x_snsab_snow_sam_i_snow_checksum |
| - | Constant set by the connector, value = "Contains::Contained By" | - | type |
Relationship 2 (Hosts and VMs)
Target table: cmdb_rel_ci
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| Host computer name | Name of the physical computer (host) within the dcc/cluster | Datacenters and clusters -> Hosts | child |
| Virtual Machines (API member: Name) | Name of the virtual machine within the host | (Host) Computer details -> Information | parent |
| - | Checksum generated from the other variables in this table. | - | x_snsab_snow_sam_i_snow_checksum |
| - | Constant set by the connector, value = "Virtualized by::Virtualizes" | - | type |
Relationship 3 (VM’s and VMs)
Target table: cmdb_rel_ci
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| Virtual Machines (API member: Name) | Name of the virtual machine within the host | (Host) Computer details -> Information | child |
| (API member: VitualMachineId) | Virtual machine ID | parent | |
| - | Checksum generated from the other variables in this table. | - | x_snsab_snow_sam_i_snow_checksum |
| - | Constant set by the connector, value = "Instantiates::Instantiated by" | - | type |
Relationship 4 (DCC and VM’s)
Target table: cmdb_rel_ci
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| Name | Name of the datacenter or cluster | Datacenters and clusters | child |
| (API member: VitualMachineId) | Virtual machine ID | parent | |
| - | Checksum generated from the other variables in this table. | - | x_snsab_snow_sam_i_snow_checksum |
| - | Constant set by the connector, value = "Registered on::Has registered" | - | type |
Software packages
Target table: cmdb_ci_spkg
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| Name | The name of the application | Edit computer -> Identified files | name |
| ManufacturerName | The name of the application manufacturer | Edit computer -> Identified files | manufacturer |
Software instances
Target table: cmdb_software_instance
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| ComputerId | The computer that the application is installed on | Computer details | installed_on |
| IsInstalled | Whether the application has a local installation record or not. | - | x_snsab_snow_sam_i_has_local_installation |
| InstallDate | Installation date of the application | - | install_date |
| LastUsed | The last time the application was used | Application details -> Computers | x_snsab_snow_sam_i_lastused |
| FirstUsed | The first time the application was used | - | x_snsab_snow_sam_i_firstused |
| AvgUsageTime | The average usage time of the application | Application details -> Computers | x_snsab_snow_sam_i_avgusagetime |
| UsedMinutes | Number of minutes used | - | x_snsab_snow_sam_i_usedminutes |
| Users | Number of users that have used the application | Application details -> Users | x_snsab_snow_sam_i_users |
| Run | The number of times the application is run | Application details -> Computers | x_snsab_snow_sam_i_run |
User
Target table: sys_user
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| Username | Domain of the user; extracted from Username | User details | x_snsab_snow_sam_i_domain |
| E-mail address of the user | User details -> Information | ||
| FullName | Full name of the user | Edit user -> Full name | first_name |
| Logged in | Last time the user logged in | User details | last_login_time |
| FullName | Full name of the user | Edit user -> Full name | last_name |
| PhoneNumber | Phone number of the user | User details -> Information | mobile_phone |
| Organisation | Organization name | User details -> Information | x_snsab_snow_sam_i_snow_organization |
| - | The organization checksum | - | x_snsab_snow_sam_i_snow_org_checksum |
| - | User ID in SLM | - | x_snsab_snow_sam_i_snow_user_id |
| Username | User name | User details | user_name |
Datacenter
note
The target table cmdb_ci_vcenter, previously named vCenter here, is not used from ServiceNow and Snow Integration Manager 5.32. The target table cmdb_ci_vcenter can be emptied if you wish.
Target table: cmdb_ci_vcenter_datacenter
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| Name | Name of the datacenter or cluster | Datacenters and clusters | name |
| - | Constant set by the connector, value = "SnowSoftware" | - | discovery_source This is a reference to a global SnowSoftware entry in the sys_choice_list under cmdb_ci. |
VMware instance
Target table: cmdb_ci_vmware_instance
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| Virtual machines (API member: Name) | Name of the virtual machine In ServiceNow, the field is populated like this; "Instance_" + Virtual machine name | Computer details -> Information | name |
| (API member: VirtualMachineID) | Virtual machine ID in SLM | - | x_snsab_snow_sam_i_virtual_machine_id |
| (API member: PowerState) | Power state of the virtual machine | Computer details -> Information | state |
| - | Constant set by the connector, value = "SnowSoftware" | - | discovery_source This is a reference to a global SnowSoftware entry in the sys_choice_list under cmdb_ci. |
Hyper-V instance
Target table: cmdb_ci_hyper_v_instance
| Name | Description | Field in SLM GUI | Target field |
|---|---|---|---|
| ConnectorName | Connector Name from Snow Integration Manager Properties. Users can use it for their own mappings. Note: Changing the connector name in the GUI changes the CSV file name and impacts custom mappings. | - | - |
| Virtual machines (API member: Name) | Name of the virtual machine In ServiceNow, the field is populated like this; "Instance_" + Virtual machine name | Computer details -> Information | name |
| (API member: VirtualMachineID) | Virtual machine ID in SLM | - | x_snsab_snow_sam_i_virtual_machine_id |
| (API member: PowerState) | Power state of the virtual machine | Computer details -> Information | state |