.png)
Data transformation and mapping by default
By default, the connector reads the data source retrieved from Nexthink, performs a series of transformations and maps this transformed information into the CMDB fields.
The default configuration is the following:
Computers
Table : cmdb_ci_computer
Fields:
Nexthink field | ServiceNow field | Transformation | Primary Key |
|---|---|---|---|
name | name |
| |
group_name | OS Domain | ||
number_of_cores | CPU core count | ||
number_of_cpus | CPU count | ||
cpu_model | CPU Manufacturer | sys_id of the matching record in the core_company table | |
CPU Type | Remove the domain. | ||
cpu_frequency | CPU speed (MHz) | ||
system_drive_capacity | Disk space (GB) | Convert to numeric format and convert from bytes to gigabytes | |
entity | Location | sys_id of the matching record in the cmn_location table | |
device_manufacturer | manufacturer | sys_id of the matching record in the core_company table | |
device_model | Model ID | sys_id of the matching record in the cmdb_model table | |
os_version_and_architecture | OS version | Version of the OS | |
OS Service Pack | Service pack of the OS | ||
Operating System | Name of the OS | ||
device_serial_number | Serial number | ||
total_ram | RAM (MB) | Convert to numeric format and convert from bytes to megabytes |
Relationships
Table : cmdb_rel_ci
Fields:
ServiceNow field | Value |
|---|---|
parent | sys_id of the record from the cmdb_ci_computer table which has the same name |
child | sys_id of the record from the cmdb_ci_spkg table which has the same name and the same version |
type | Uses::Used by |
*Note that the IntegrationHub ETL application is necessary to customize the mapping.