Imported Installation Records

IT Asset Management (Cloud)

The ImportedInstalledInstallerEvidence table is a staging table used to collect records of which installation evidence has been found on what inventory devices. From here, de-duplicated and normalized records are merged into the InstalledInstallerEvidence table.

InstalledInstallerEvidence is a simple table that mainly links installer evidence records with inventory device records. In the case of imports from Data Platform v5, only the two external IDs are needed, with other values supplied by IT Asset Management as and when required. The first listing below maps the two columns from Data Platform source to IT Asset Management destination. Below is a list of the remaining columns in the ImportedInstalledInstallerEvidence table that are not populated by this import (and do not need to be).

Data mapping for imported installed installer evidence

The following listing matches the source data from Data Platform v5 with the equivalent column in the ImportedInstalledInstallerEvidence table. For more details on the database tables and columns within IT Asset Management, please see IT Asset Management Schema Reference.

Data Platform (Table)/Column FNMS (Table)/Column Notes
(MATCH_HOST_SW_PROD) / CAT_SW_UUID (ImportedInstalledInstallerEvidence) / ExternalInstallerEvidenceID

The same value as the (ImportedInstallerEvidence) / ExternalInstallerID.

Fabricated from:

(MATCH_TASK_DET) / PROCESS_ID

(MATCH_TASK_DET) / TASK_NAME and the checksum for the same

(MATCH_HOST_SW_PROD) / HOST_ID

(ImportedInstalledInstallerEvidence) / ExternalID
The format is of this form (shown with nonsense values):
PID123|TheTask|654321:Host789

An external ID for the inventory device is fabricated from the various details shown (truncated as required and joined with various separator characters). This is then mapped through the ImportedStringMapping table to convert string IDs to integer IDs. The same value as the (ImportedComputer) / ExternalID.

(MATCH_HOST_SW_PROD) / DISCOVERED_INSTALLDATE (ImportedInstalledInstallerEvidence) / InstallDate

The installation date recorded for the installer evidence.

Data not imported from Data Platform v5

These columns in the ImportedInstalledInstallerEvidence table cannot be populated by inventory imports from Data Platform v5. These missing data points do not impact license compliance calculations. For further details about these columns, please see the schema reference.
  • ComplianceConnectionID — internally generated
  • ExternalInstanceID
  • DiscoveryDate (will be set to the date of first import from this connection).

IT Asset Management (Cloud)

Current