Configuration Item Table

The Configuration Item table offers details about discovered and unmatched CIs.

DIscovered CI Table

Table Name: (sn_sec_cmn_src_ci)

The discovered CIs that are stored in the existing CMDB entries during import and mapping are stored in the sn_sec_cmn_unmatched_ci table.

The following information gets fetched for the synced Discovered CI table:

Field on Qualys ETM UI 

Field in Qualys ETM API Response

Field on ServiceNow Table

-

-

Source data

-

-

Configuration Item

OS

finding.operatingSystemAttribute.operatingSystem

Operating System

UnMatched CI Table

Table Name: (sn_sec_cmn_unmatched_ci)

The unmatched CIs that could not be stored in the existing CMDB entries during import and mapping are stored in the sn_sec_cmn_unmatched_ci table.

The following information gets fetched for the synced Unmatched CI table:

Field on Qualys ETM UI 

Field in Qualys ETM API Response

Field on ServiceNow Table

-

-

Source Data

OS

finding.operatingSystemAttribute.operatingSystem

Operating System

BIOS Serial Number

finding.assetSerialNumber

Serial Number

Hostname 

finding.assetName

Name

Matched CI 

For Matched CI, the target table will be as per the CI classification of the Asset by IRE.