Related Tables
The related tables list the custom field mappings that could not be accommodated in the classified tables. We recommend that you do not alter the mappings in the related tables.
Asset Data Model
Following are the related tables for mapping Qualys Staging Table Attributes with ServiceNow Production Table Attributes for Asset Data modle:
Qualys Asset Details
The following table includes the mapping of Qualys Asset Details - table attributes:
|
Qualys Related Table Attributes |
ServiceNow Production Table Attributes |
|---|---|
|
asset_lastloggedonuser |
asset_lastloggedonuser |
|
asset_most_frequent_user |
asset_mostfrequentuser |
|
qualys_asset_id |
qualys_asset_id |
|
asset_uuid |
asset_uuid |
|
bios_description |
bios_description |
|
last_boot |
last_boot |
|
last_modified_date |
last_modified_date |
|
time_zone |
time_zone |
|
qweb_host_id |
qweb_host_id |
|
netbios_name |
netbios_name |
|
type |
type |
|
asn |
asn |
|
isp |
isp |
|
risk_score |
risk_score |
Qualys Operating System Details
The following table includes the mapping of Qualys Operating System Details - table attributes:
|
Qualys Related Table Attributes |
ServiceNow Production Table Attributes |
|---|---|
|
os_category |
os_category |
|
os_category_1 |
os_category_1 |
|
os_category_2 |
os_category_2 |
|
os_category_type |
os_category_type |
|
os_edition |
os_edition |
|
os_lifecycle_confidence |
os_lifecycle_confidence |
|
os_lifecycle_eol_date |
os_lifecycle_eol_date |
|
os_lifecycle_eol_support_stage |
os_lifecycle_eol_support_stage |
|
os_lifecycle_eos_date |
os_lifecycle_eos_date |
|
os_lifecycle_eos_support_stage |
os_lifecycle_eos_support_stage |
|
os_lifecycle_ga |
os_lifecycle_ga |
|
os_lifecycle_stage |
os_lifecycle_stage |
|
os_market_version |
os_market_version |
|
os_name |
os_name |
|
os_product_name |
os_product_name |
|
os_publisher |
os_publisher |
Qualys Hardware Details
The following table includes the mapping of Qualys Hardware Details - table attributes:
|
Qualys Related Table Attributes |
ServiceNow Production Table Attributes |
|---|---|
|
hardware_category |
hardware_category |
|
hardware_category_1 |
hardware_category_1 |
|
hardware_category_2 |
hardware_category_2 |
|
hardware_category_type |
hardware_category_type |
|
hardware_lifecycle_confidence |
hardware_lifecycle_confidence |
|
hardware_lifecycle_eos_date |
hardware_lifecycle_eos_date |
|
hardware_lifecycle_ga |
hardware_lifecycle_ga |
|
hardware_lifecycle_intro_date |
hardware_lifecycle_intro_date |
|
hardware_lifecycle_obsolete_date |
hardware_lifecycle_obsolete_date |
|
hardware_lifecycle_stage |
hardware_lifecycle_stage |
|
hardware_product |
hardware_product |
|
hardware_full_name |
hardware_full_name |
Qualys Open Ports Details
The following table includes the mapping of Qualys Open Ports Details - table attributes:
|
Qualys Related Table Attributes |
ServiceNow Production Table Attributes |
|---|---|
|
description |
description |
|
detected_service |
detected_service |
|
port |
port |
|
protocol |
protocol |
Qualys Processors Details
The following table includes the mapping of Qualys Processors Details - table attributes:
|
Qualys Related Table Attributes |
ServiceNow Production Table Attributes |
|---|---|
|
processor_cpu_counts |
processor_cpu_counts |
|
processor_description |
processor_description |
|
processor_speed |
processor_speed |
Qualys EASM WhoIs Details
The following table includes the mapping of Qualys EASM Whols - table attributes:
|
Qualys Related Table Attributes |
ServiceNow Production Table Attributes |
|---|---|
|
domain |
domain |
|
processor_description |
processor_description |
|
domain_status |
domain_status |
|
dnssec |
dnssec |
|
registrant_name |
registrant_name |
|
registrant_organization |
registrant_organization |
|
registrar |
registrar |
|
registrant_email |
registrant_email |
|
registrant_contact |
registrant_contact |
|
organization_name |
organization_name |
|
created_date |
created_date |
|
updated_date |
updated_date |
Qualys EASM Domains Details
The following table includes the mapping of Qualys EASM Domains Details - table attributes:
|
Qualys Related Table Attributes |
ServiceNow Production Table Attributes |
|---|---|
|
domain_name |
domain_name |
Qualys EASM Sub-domains Details
The following table includes the mapping of Qualys EASM Sub-domains Details - table attributes:
|
Qualys Related Table Attributes |
ServiceNow Production Table Attributes |
|---|---|
|
subdomain_name |
subdomain_name |
Unique Certificates Details
The following table includes the mapping of Unique Certificate Details - table attributes:
|
Qualys Related Table Attributes |
ServiceNow Production Table Attributes |
|---|---|
|
self_signed |
is_self_signed |
|
issuer_name |
issuer_common_name |
|
key_size |
key_size |
|
last_found |
last_discovered |
|
signature_algorithm |
signature_algorithm |
|
subject_name |
subject_common_name |
|
subject_name |
name |
|
subject_country |
subject_country |
|
subject_locality |
subject_locality |
|
subject_organization |
subject_organization |
|
subject_state |
subject_state |
|
dn |
fingerprint |
|
certhash |
subject_distinguished_name |
|
valid_from |
valid_from |
|
valid_to |
valid_to |
Qualys Asset Certificates Details
The following table includes the mapping of Qualys EASM Asset Certificate Details - table attributes:
|
Qualys Related Table Attributes |
ServiceNow Production Table Attributes |
|---|---|
|
issuer_organization |
issuer_organization |
|
issuer_country |
issuer_country |
|
issuer_state |
issuer_state |
|
issuer_certhash |
issuer_certhash |
|
issuer_locality |
issuer_locality |
|
rootissuer_organization |
rootissuer_organization |
|
rootissuer_name |
rootissuer_name |
|
rootissuer_country |
rootissuer_country |
|
rootissuer_state |
rootissuer_state |
|
rootissuer_certhash |
rootissuer_certhash |
|
rootissuer_locality |
rootissuer_locality |
|
instance_count |
instance_count |
|
issuer_category |
issuer_category |
|
extended_validation |
extended_validation |
Software Data Model
Following are the tables for mapping Qualys Staging Table Attributes with ServiceNow Production Table Attributes for Software Data modle:
Qualys Software Details
The following table includes the mapping of Qualys Software Details - table attributes:
|
Qualys Related Table Attributes |
ServiceNow Production Table Attributes |
|---|---|
|
architecture |
architecture |
|
category |
category |
|
category_1 |
category_1 |
|
category_2 |
category_2 |
|
category_type |
category_type |
|
component |
component |
|
edition |
edition |
|
is_ignored |
is_ignored |
|
is_ignored_reason |
is_ignored_reason |
|
language |
language |
|
license_category |
license_category |
|
type |
type |
|
update |
update |
|
lifecycle_ga |
lifecycle_ga |
|
lifecycle_stage |
lifecycle_stage |
|
market_version |
market_version |
|
product |
product |
|
publisher |
publisher |
|
lifecycle_confidence |
lifecycle_confidence |
|
lifecycle_eos_date |
lifecycle_eos_date |
|
lifecycle_eol_support_stage |
lifecycle_eol_support_stage |
|
master_software_sys_id |
reference_ci |
|
version |
version |
|
name |
name |
|
lifecycle_eol_date |
lifecycle_eol_date |