Classified Tables

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

Asset Data Model

Following are the classified tables for mapping Qualys Staging Table Attributes with ServiceNow Production Table Attributes for Asset Data modle:

Computer (SN Table)

The following table includes the mapping of Computer components-table attributes: 

Qualys Staging Table Attributes

ServiceNow Production Table Attributes

manufacturer

manufacturer

memory

ram

bios_asset_tag

asset_tag

os_full_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

virtual

virtual

bios_serial_number

serial_number

os_update

os_service_pack

processor_speed

cpu_speed

Serial Number (SN Table)

The following table includes the mapping of Serial Number - table attributes: 

Qualys Staging Table Attributes

ServiceNow Production Table Attributes

bios_serial_number

serial_number

hardware_serial_number

serial_number

The serial number type depends on the type of serial number. Serial number type for a bios serial number is bios and serial number type for a hardware serial number is system.

File System (SN Table)

The following table includes the mapping of File System - table attributes: 

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 table includes the mapping of Network Adapter - table attributes: 

Qualys Staging Table Attributes

ServiceNow Production Table Attributes

mac_address

name

address

ip_address

mac_address

mac_address

IP Address (SN Table)

The following table includes the mapping of IP Address - table attributes: 

Qualys Staging Table Attributes

ServiceNow Production Table Attributes

ip_address

ip_address

ip_address

name

Software Data Model

Following are the tables for mapping Qualys Staging Table Attributes with ServiceNow Production Table Attributes for Software Data modle:

Software Instance (SN Table)

The following table includes the mapping of Software Instance - table attributes: 

Qualys Staging Table Attributes

ServiceNow Production Table Attributes

name

name

install_date

install_date

<additional field>

<Reference to cmdb_ci_package>

<additional field>

Reference to the CI the software is installed on

software   

software