Classified Tables

The classified table includes the mapping of source fields with target fields that are recommended or used by ServiceNow.

Asset Data Model

Computer (SN Table)

The following classified table includes the field mapping of source fields with target fields for Computer:

Qualys Staging Table Attributes

ServiceNow Production Table Attributes

manufacturer

manufacturer

memory

ram

bios_asset_tag

asset_tag

cleansed_os_name

os

os_update

os_service_pack

os_architecture

os_address_width

model

model_id

os_version

os_version

name

name

processor_cpu_counts

cpu_count

processor_description

cpu_name

ip_address

ip_address

processor_speed   

cpu_speed

target_ci_class

sys_class_name

virtual

virtual

bios_serial_number

serial_number

Serial Number (SN Table)

The following classified table includes the field mapping of source fields with target fields for Serial Number:

Qualys Staging Table Attributes

ServiceNow Production Table Attributes

bios_serial_number

serial_number

<additional field>

serial_number_type

valid

valid

serial_number_type

serial_number_type

File System (SN Table)

The following classified table includes the field mapping of source fields with target fields for File System:

Qualys Staging Table Attributes

ServiceNow Production Table Attributes

name

name

free_size

free_space_bytes

total_size

size_bytes

Network Adapter (SN Table)

The following classified table includes the field mapping of source fields with target fields for Serial Network Adapter:

Qualys Staging Table Attributes

ServiceNow Production Table Attributes

interface_name

name

mac_address

mac_address

hostname

fqdn

address

ip_address

type

category

IP Address (SN Table)

Qualys Staging Table Attributes

ServiceNow Production Table Attributes

ip_address

ip_address

ip_address

name

ip_version   

ip_version   

Software Data Model

Master Software (SN Table)   

The following classified table includes the field mapping of source fields with target fields for Master Software:

Qualys Staging Table Attributes

ServiceNow Production Table Attributes

name

name

version

version

<additional field>

key

Software Instance (SN Table)

The following classified table includes the field mapping of source fields with target fields for Software Instance:

Qualys Staging Table Attributes

ServiceNow Production Table Attributes

name

name

install_date

install_date

<additional field>

<Reference to cmdb_ci_package>

<additional field>

In reference to the CI the software is installed on