Import into ServiceNow
The following table lists tables used when importing IT Visbility data into ServiceNow.
|
Table Name |
Table Label |
Table Columns |
|
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 |
|
sam_sw_model_lifecycle |
Software Model Lifecycle |
lifecycle_phase lifecycle_type model source start_date |
|
sam_sw_product_lifecycle |
Software Product Lifecycle |
description lifecycle_phase lifecycle_type norm_edition norm_product norm_version source start_date |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
cmdb_hardware_product_model |
Hardware Model |
cmdb_model_category full_name manufacturer model_name name short_description x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_flexera_id |
|
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 |
|
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 |
|
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 |
|
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_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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
cmdb_ci_netgear |
Network Gear |
correlation_id cpu_count cpu_manufacturer cpu_speed disk_space last_discovered manufacturer model_id model_number name ram serial_number sys_id x_fls_flexera_fnms_data_source x_fls_flexera_fnms_data_token x_fls_flexera_fnms_is_deleted x_fls_flexera_fnms_normalized_cpu_manufacturer x_fls_flexera_fnms_normalized_cpu_speed x_fls_flexera_fnms_normalized_hardware_model x_fls_flexera_fnms_normalized_manufacturer x_fls_flexera_fnms_normalized_model_number |
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 |