Imported Installation Records
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
( |
Fabricated from: ( ( ( |
(ImportedInstalledInstallerEvidence ) /
ExternalID The format is of this form (shown with
nonsense values):
|
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
|
(MATCH_HOST_SW_PROD ) /
DISCOVERED_INSTALLDATE |
(ImportedInstalledInstallerEvidence )
/
InstallDate |
The installation date recorded for the installer evidence. |
Data not imported from Data Platform v5
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 generatedExternalInstanceID
DiscoveryDate
(will be set to the date of first import from this connection).
IT Asset Management (Cloud)
Current