FileEvidenceDetail_ci (Staging Table)

IT Asset Management (Cloud)

Data in this staging table may also be saved in FileEvidenceDetail.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:
   WHERE (NODECOUNT(TRAVERSE Detail:Detail:ElementWithDetail:Host) > 0)
    AND (type = 'FNMP_FileEvidence')
   SHOW name AS 'FileName',
    size AS 'FileSize',
    description AS 'Description',
    company AS 'Company',
    version AS 'FileVersion',
    #Detail:Detail:ElementWithDetail:Host.key AS 'HostKey'

Mapping into FileEvidenceDetail_ci

Source alias FileEvidenceDetail_ci property Type Max
Company Company nvarchar 255
Description Description nvarchar 255
FileName FileName nvarchar 800
FileSize FileSize bigint  
FileVersion FileVersion nvarchar 255
HostKey HostKey varchar 64

IT Asset Management (Cloud)