Import into ServiceNow
The following table lists tables used when importing IT Visbility 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 |
Import Properties Implication
In the Flexera Integration app, navigate to Flexera Integration > Import Configuration > Import Properties to view properties will affect the corresponding onBefore transform scripts that are associated to each of our integrations transform maps. The onBefore script checks the value of the properties set in Flexera Integration > Import Configuration > Import Properties, and during the transformation process use this information to determine if rows are allowed to be inserted or updated into the destination table.
IT Visibility utilizes the following transform map names:
| • | Computer |
| • | Software Instance |
| • | Disk |
| • | Flexera Hardware Model with Lifecycle |
| • | Flexera Software Model with Lifecycle |
| • | Company |