Snow for ServiceNow CMDB Integration

Computer

Target table: cmdb_ci_computer

Name

Description

Field in SLM GUI

Target field

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

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

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

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

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 VM’s)

Target table: cmdb_rel_ci

Name

Description

Field in SLM GUI

Target field

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 VM’s)

Target table: cmdb_rel_ci

Name

Description

Field in SLM GUI

Target field

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

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

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

Name

The computer that the application is installed on

Computer details

installed_on

InstallDate

Installation date of the application

-

install_date

FirstUsed

The first time the application was used

-

x_snsab_snow_sam_i_firstused

LastUsed

The last time the application was used

Application details | Computers

x_snsab_snow_sam_i_lastused

Run

The number of times the application is run

Application details | Computers

x_snsab_snow_sam_i_run

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

IsInstalled 

Whether the application has a local installation record or not.

-

x_snsab_snow_sam_i_has_local_installation

User

Target table: sys_user

Name

Description

Field in SLM GUI

Target field

Username

Domain of the user; extracted from Username

User details

x_snsab_snow_sam_i_domain

Email

E-mail address of the user

User details | Information

email

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 Snow for ServiceNow 4.1 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

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

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

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