Import into ServiceNow
The following table lists tables used when importing Data Platform data into ServiceNow.
|
Table Name |
Table Label |
Table Columns |
Table Label |
|
ast_contract |
Contract |
contract_model ends short_description starts state vendor vendor_contract x_fls_flexera_fnms_is_deleted |
IT Asset Management / FlexNet Manager Suite |
|
ast_contract_instance |
Lease Instance |
ast_contract ci_item contract_type |
IT Asset Management / FlexNet Manager Suite |
|
cmdb_ci |
Configuration Item |
last_discovered manufacturer model_id model_number name serial_number sys_class_name sys_id x_fls_flexera_fnms_data_source_v2 x_fls_flexera_fnms_data_token_v2 x_fls_flexera_fnms_flexera_unique_ci_id x_fls_flexera_fnms_is_deleted_v2 x_fls_flexera_fnms_normalized_hardware_model_v2 x_fls_flexera_fnms_normalized_manufacturer_v2 x_fls_flexera_fnms_normalized_model_number |
Data Platform,
|
|
cmdb_ci_computer |
Computer |
correlation_id cpu_core_count cpu_count cpu_manufacturer cpu_name cpu_speed disk_space last_discovered manufacturer name os os_domain os_service_pack os_version ram serial_number sys_class_name sys_id virtual x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_flexera_unique_id x_fls_flexera_fnms_is_deleted x_fls_flexera_fnms_last_loged_in_user x_fls_flexera_fnms_normalized_cpu_manufacturer x_fls_flexera_fnms_normalized_cpu_name x_fls_flexera_fnms_normalized_cpu_speed x_fls_flexera_fnms_normalized_flexera_hardware_model x_fls_flexera_fnms_normalized_manufacturer x_fls_flexera_fnms_normalized_operating_system x_fls_flexera_fnms_normalized_os_service_pack x_fls_flexera_fnms_normalized_os_version |
Data Platform
|
|
cmdb_ci_computer |
Computer |
chassis_type correlation_id cpu_core_count cpu_core_thread cpu_count cpu_speed cpu_type disk_space hardware_status ip_address mac_address manufacturer model_id model_number name os ram serial_number sys_class_name sys_domain virtual x_fls_flexera_fnms_asset_id x_fls_flexera_fnms_calculated_user x_fls_flexera_fnms_computer_id x_fls_flexera_fnms_discovered_date x_fls_flexera_fnms_inventory_connection x_fls_flexera_fnms_inventory_source x_fls_flexera_fnms_is_deleted x_fls_flexera_fnms_last_logged_in_user |
IT Asset Management / FlexNet Manager Suite |
|
cmdb_ci_disk |
Disk |
computer disk_space file_system free_space name short_description volume_name volume_serial_number x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_is_deleted |
Data Platform |
|
cmdb_ci_network_adapter |
Network Adapter |
cmdb_ci dhcp_enabled ip_address mac_manufacturer name netmask x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_is_deleted |
Data Platform |
|
cmdb_ci_spkg |
Software |
cmdb_ci dhcp_enabled ip_address mac_manufacturer name netmask x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_is_deleted |
IT Asset Management / FlexNet Manager Suite |
|
cmdb_ci_vm_instance |
Virtual Machine Instance |
cpus disks_size manufacturer memory model_id model_number name serial_number sys_domain x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_flexera_id x_fls_flexera_fnms_is_deleted |
Data Platform |
|
cmdb_ci_vm_instance |
Virtual Machine Instance |
correlation_id cpus disks_size ip_address mac_address manufacturer memory model_id model_number name serial_number sys_class_name sys_domain x_fls_flexera_fnms_computer_id x_fls_flexera_fnms_is_deleted |
IT Asset Mangement / FlexNet Manager Suite |
|
cmdb_hardware_model_lifecycle |
Hardware Model Lifecycle |
lifecycle_phase lifecycle_type model source start_date x_fls_flexera_fnms_data_token x_fls_flexera_fnms_is_deleted x_fls_flexera_fnms_technopedia_id |
Data Platform,
|
|
cmdb_model |
Product Model |
cmdb_model_category full_name manufacturer model_name model_number name short_description sys_class_name x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_flexera_id |
IT Asset Management / FlexNet Manager Suite |
|
cmdb_sam_sw_discovery_model |
Software Discovery Model |
display_name model primary_display_name primary_key publisher version x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_technopedia_id |
Data Platform,
|
|
cmdb_sam_sw_install |
Software Installation |
display_name edition installed_on last_used primary_key publisher software_model sys_id version x_fls_flexera_fnms_correlation_id x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_flexera_normalized_edition x_fls_flexera_fnms_flexera_normalized_name x_fls_flexera_fnms_flexera_normalized_product x_fls_flexera_fnms_flexera_normalized_publisher x_fls_flexera_fnms_flexera_normalized_version x_fls_flexera_fnms_is_deleted x_fls_flexera_fnms_is_flexera_normalized x_fls_flexera_fnms_is_flexera_software_model x_fls_flexera_fnms_technopedia_id |
Data Platform, IT VIsibility |
|
cmdb_sam_sw_install |
Software Installation |
display_name edition installed_on last_used primary_key publisher software_model sys_id version x_fls_flexera_fnms_correlation_id x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_flexera_normalized_edition x_fls_flexera_fnms_flexera_normalized_name x_fls_flexera_fnms_flexera_normalized_product x_fls_flexera_fnms_flexera_normalized_publisher x_fls_flexera_fnms_flexera_normalized_version x_fls_flexera_fnms_is_deleted x_fls_flexera_fnms_is_flexera_normalized x_fls_flexera_fnms_is_flexera_software_model x_fls_flexera_fnms_technopedia_id |
IT Asset Management / FlexNet Manager Suite |
|
cmdb_software_instance |
Software Instance |
installed_on name software x_fls_flexera_fnms_discovered_at x_fls_flexera_fnms_discovered_by x_fls_flexera_fnms_id x_fls_flexera_fnms_is_deleted x_fls_flexera_fnms_last_scanned |
IT Asset Management / FlexNet Manager Suite |
|
cmdb_software_product_model |
Software Model |
manufacturer name short_description type version x_fls_flexera_fnms_application_name x_fls_flexera_fnms_id |
IT Asset Management / FlexNet Manager Suite |
|
cmdb_software_product_model |
Software Model |
display_name edition edition_operator end_of_life_data full_name ga_release_date major_version manufacturer product software_category version version_operator x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_flexera_id |
Data Platform |
|
core_company |
Company |
city country name phone website x_fls_flexera_fnms_company_id x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_is_deleted x_fls_flexera_fnms_is_software x_fls_flexera_fnms_symbol x_fls_flexera_fnms_tier |
Data Platform,
|
|
sam_sw_model_lifecycle |
Software Model Lifecycle |
lifecycle_phase lifecycle_type model source start_date |
Data Platform,
|
|
sam_sw_product_lifecycle |
Software Product Lifecycle |
description lifecycle_phase lifecycle_type norm_edition norm_product norm_version source start_date |
Data Platform,
|
|
samp_sw_product |
Software Product |
function_type prod_name product_type publisher sys_id x_fls_flexera_fnms_data_source x_fls_flexera_fnms_flexera_product_revision x_fls_flexera_fnms_product_component x_fls_flexesra_fnms_data_token |
Data Platform, |
|
samp_sw_publisher |
Software Publisher |
manufacturer name webpage x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_technopedia_id |
Data Platform, |
|
x_fls_flexera_fnms_flexera_hardware_model |
Flexera Hardware Model |
u_category u_full_name u_ga_exception u_ga_range_end u_ga_range_start u_general_availability u_general_availability_date u_hw_model_lc_id u_hwid u_introduction u_introduction_date u_introduction_exception u_introduction_range_end u_introduction_range_start u_last_availability u_last_availability_date u_last_availability_exception u_last_availability_range_end u_last_availability_range_start u_manufacturer u_model_id u_model_number u_name u_obsolete u_obsolete_date u_obsolete_exception u_obsolete_range_end u_obsolete_range_start u_subcategory x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_is_deleted |
Data Platform |
|
x_fls_flexera_fnms_flexera_software_model |
Flexera Software Model |
u_category u_component u_edition u_end_of_life u_end_of_life_date u_end_of_life_exception u_end_of_life_range_end u_end_of_life_range_start u_end_of_life_support_level u_family u_full_name u_ga_exception u_ga_range_end u_ga_range_start u_general_availability u_general_availability_date u_is_licensable u_is_suite u_major_version u_manufacturer_id u_name u_obsolete u_obsolete_date u_obsolete_exception u_obsolete_range_end u_obsolete_range_start u_obsolete_support_level u_patch_level u_software_id u_subcategory u_sw_model_lc_id u_sw_release_id u_version u_version_group x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_is_deleted |
IT Asset Management / FlexNet Manager Suite |
|
x_fls_flexera_fnms_normalized_software_instances |
Normalized Software Instances |
u_installed_on u_is_used u_last_used_date u_normalized_software u_product_name u_version x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_is_deleted |
IT Asset Management / FlexNet Manager Suite |