Export from ServiceNow
The following tables lists the data that is exported from ServiceNow to IT Visibility.
| • | Computers |
| • | Installs |
| • | Network Adapters |
The following tables lists the computer data that is exported from ServiceNow to IT Visibility.
|
Attribute |
Database View |
Source Table |
Source Column |
Filter |
|
cicomp_manufacturer.name |
x_fls_flexera_fnms_computer |
core_company |
manufacturer |
|
|
cicomp_cpu_name |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
cpu_name |
|
|
cicomp_os_version |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
os_version |
|
|
cicomp_os_service_pack |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
os_service_pack |
|
|
cicomp_cpu_count |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
cpu_count |
|
|
cicomp_x_fls_flexera_fnms_data_source |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
x_fls_flexera_fnms_data_source |
filter (imported by ServiceNow discovery) |
|
cicomp_hardware_status |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
hardware_status |
filter (not RETIRED) |
|
cicomp_last_discovered |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
last_discovered |
|
|
cicomp_sys_id Note:This attribute is mandatory. |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
sys_id |
|
|
cicomp_cpu_manufacturer |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
cpu_manufacturer |
|
|
cicomp_os |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
os |
|
|
cicomp_cpu_speed |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
cpu_speed |
|
|
cicomp_ram |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
ram |
|
|
cicomp_name |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
name |
|
|
cicomp_dns_domain |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
dns_domain |
|
|
cicomp_serial_number |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
serial_number |
|
|
cicomp_model_id.name |
x_fls_flexera_fnms_computer |
cmdb_model |
name |
|
|
cicomp_cpu_type |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
cpu_type |
|
|
cicomp_cpu_core_count |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
cpu_core_count |
|
|
cicomp_disk_space |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
disk_space |
|
|
cicomp_cpu_core_thread |
x_fls_flexera_fnms_computer |
cmdb_ci_computer |
cpu_core_thread |
|
The following tables lists the install data that is exported from ServiceNow to IT Visibility if the SAM plugin is not enabled.
|
Attribute |
Database View |
Source Table |
Source Column |
|
cispkg_version |
x_fls_flexera_fnms_software |
cmdb_ci_spkg |
version |
|
cispkg_sys_id |
x_fls_flexera_fnms_software |
cmdb_ci_spkg |
sys_id |
|
cicomp_sys_id Note:This attribute is mandatory. |
x_fls_flexera_fnms_software |
cmdb_ci_computer |
sys_id |
|
cispkg_name Note:This attribute is mandatory. |
x_fls_flexera_fnms_software |
cmdb_ci_spkg |
name |
|
cispkg_manufacturer Note:This attribute is mandatory. |
x_fls_flexera_fnms_software |
cmdb_ci_spkg |
manufacturer |
|
swinst_sys_id |
x_fls_flexera_fnms_software |
cmdb_ci_computer |
sys_id |
The following tables lists the install data that is exported from ServiceNow to IT Visibility if the SAM plugin is enabled (is_sam_plugin_enabled).
|
Attribute |
Database View |
Source Table |
Source Column |
|
cicomp_sys_id Note:This attribute is mandatory. |
x_fls_flexera_fnms_software |
cmdb_ci_computer |
sys_id |
|
swinstall_display_name Note:This attribute is mandatory. |
x_fls_flexera_fnms_software |
cmdb_sam_sw_install |
display_name |
|
swinstall_publisher Note:This attribute is mandatory. |
x_fls_flexera_fnms_software |
cmdb_sam_sw_install |
publisher |
|
swinstall_version |
x_fls_flexera_fnms_software |
cmdb_sam_sw_install |
version |
|
swinstall_install_date |
x_fls_flexera_fnms_software |
cmdb_sam_sw_install |
install_date |
|
swinstall_sys_id Note:This attribute is mandatory for end-to-end integration. |
x_fls_flexera_fnms_software |
cmdb_sam_sw_install |
sys_id |
The following tables lists the network adapter data that is exported from ServiceNow to IT Visibility. If there is no access to cmdb_ci_network_adapter, the import will succeed but MAC and IP addresses will not be imported.
|
Attribute |
Source Database Table |
|
sys_id |
cmdb_ci |
|
mac_address |
mac_address |
|
ip_address |
ip_address |