Import into ServiceNow

The following table lists tables used when importing IT Visbility data into ServiceNow.

Import into ServiceNow

Table Name

Table Label

Table Columns

Product

ast_contract

Contract

contract_model

ends

short_description

starts

state

vendor

vendor_contract

x_fls_flexera_fnms_is_deleted

FlexNet Manager Suite

ast_contract_instance

Lease Instance

ast_contract

ci_item

contract_type

FlexNet Manager Suite

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

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

FlexNet Manager Suite

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

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

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

manufacturer

name

package_name

subcategory

version

x_fls_flexera_fnms_application_id

x_fls_flexera_fnms_id

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_model

Product Model

cmdb_model_categor

manufacturer

model_number

name

type

FlexNet Manager Suite

cmdb_sam_sw_install

Software Installations

display_name

edition

installed_on

last_used

primary_key

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_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_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 Installations

discovery_model

display_name

installed_on

last_scanned

prod_id

publisher

version

x_fls_flexera_fnms_application_id

x_fls_flexera_fnms_discovered_by

x_fls_flexera_fnms_is_deleted

x_fls_flexera_fnms_last_discovered

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

FlexNet Manager Suite

cmdb_software_product_model

Software Model

cmdb_model_category

full_name

manufacturer

model_number

name

short_description

x_fls_flexera_fnms_data_source

x_fls_flexera_fnms_data_token

x_fls_flexera_fnms_flexera_id

Data Platform,
IT Visibility

cmdb_software_product_model

Software Model

manufacturer

name

short_description

type

version

x_fls_flexera_fnms_application_name

x_fls_flexera_fnms_id

FlexNet Manager Suite

cmdb_hardware_product_model

Hardware Model

cmdb_model_category

full_name

manufacturer

model_number

name

short_description

x_fls_flexera_fnms_data_source

x_fls_flexera_fnms_data_token

x_fls_flexera_fnms_flexera_id

Data Platform,
IT Visibility

cmdb_sam_sw_discovery_model

Software Discovery Model

primary_display_name

primary_key

sys_id

x_fls_flexera_fnms_data_source

x_fls_flexera_fnms_data_token

x_fls_flexera_fnms_technopedia_id

Data Platform,
IT Visibility

cmdb_sam_sw_install

Software Installation

display_name

edition

installed_on

last_used

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_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_flexera_normalized

x_fls_flexera_fnms_is_flexera_software_model

x_fls_flexera_fnms_technopedia_id

Data Platform

cmdb_software_product_model

Software Model

display_name

edition

edition_operator

end_of_life_date

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,
IT Visibility

samp_sw_product

Software Product

function_type

prod_name

product_type

publisher

x_fls_flexera_fnms_data_source

x_fls_flexera_fnms_data_token

Data Platform,
IT Visibility

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,
IT Visibility

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

Data Platform

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

Data Platform

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