Export from ServiceNow

The following table lists database views used when exporting from ServiceNow.

Export from ServiceNow

Database View

Export Definition

Export Definition Filter

Export File Name

Source Table

x_fls_flexera_fnms_computer

Flexera Computer Export

(Data Source contains 'SNOW' or Data Source is Empty)

 

and ("Is deleted" = false)

 

and (hardware_status is not Retired or Hardware status is – None --)

flexera_computer_export.csv

cmdb_ci_computer

x_fls_flexera_fnms_netgear

Flexera Network Gear Export

((x_fls_flexera_fnms_data_source contains 'SNOW') or (x_fls_flexera_fnms_data_source is Empty))

and ((sys_class_name=cmdb_ci_netgear) or (sys_class_name=cmdb_ci_ip_router) or (sys_class_name=cmdb_ci_ip_switch))

and ("Is deleted" = false)

and ((hardware_status != Retired) or (hardware_status =''))

flexera_network_gear_export_set.csv

cmdb_ci_hardware,

cmdb_model

x_fls_flexera_fnms_sam_sw_install

Flexera Software Install Export

(hardware_status is not Retired or Hardware status is – None --)

flexera_software_install_export_set.csv

cmdb_sam_sw_install,

cmdb_ci_computer

x_fls_flexera_fnms_software

Flexera Software Export

(Data Source contains 'SNOW' or Data Source is Empty)

 

and ("Is deleted" = false)

 

and (hardware_status is not Retired or Hardware status is – None --)

flexera_software_export.csv

cmdb_software_instance,

cmdb_ci_spkg,

cmdb_ci_computer

Note:Only ServiceNow software records are exported for Data Platform processing. Records imported from Data Platform (such as on-premise SCCM data) will not be exported.