InstallerEvidenceDetail_ci (Staging Table)

IT Asset Management (Cloud)

Data in this staging table may also be saved in InstallerEvidenceDetail.xml on the staging server.

BMC Discovery query

This query extracts data from the Detail node in the BMC Discovery datastore, and provides the aliases for properties referenced in the table below:
  SEARCH Detail
   WHERE (NODECOUNT(TRAVERSE Detail:Detail:ElementWithDetail:Host) > 0)
    AND (type = 'FNMP_InstallerEvidence')
   SHOW name AS 'Name',
    version AS 'Version',
    vendor AS 'Vendor',
    install_date AS 'InstallDate',
    evidence AS 'Evidence',
    product_code AS 'ProductCode',
    #Detail:Detail:ElementWithDetail:Host.key AS 'HostKey'

Mapping into InstallerEvidenceDetail_ci

Source alias InstallerEvidenceDetail_ci property Type Max
Evidence Evidence nvarchar 64
HostKey HostKey varchar 64
InstallDate InstallDate nvarchar 255
Name Name nvarchar 512
ProductCode ProductCode nvarchar 110
Vendor Vendor nvarchar 400
Version Version nvarchar 144

IT Asset Management (Cloud)