DiscoveredService_ci (Staging Table)

IT Asset Management (Cloud)

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

BMC Discovery query

This query extracts data from the Host node in the BMC Discovery datastore, and provides the aliases for properties referenced in the table below:
SEARCH Host
   TRAVERSE InferredElement:Inference:Associate:DiscoveryAccess
    WHERE end_state = 'GoodAccess'
   TRAVERSE DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:ServiceList
   TRAVERSE List:List:Member:DiscoveredService
    WHERE name = 'vmms' AND display_name = 'Hyper-V Virtual Machine Management'
   SHOW
    name AS 'Name',
    #Member:List:List:ServiceList.#DiscoveryResult:DiscoveryAccessResult:
            DiscoveryAccess:DiscoveryAccess.#Associate:Inference:
            InferredElement:Host.key AS 'HostKey'

Mapping into DiscoveredService_ci

Source alias DiscoveredService_ci property Type Max
HostKey HostKey varchar 64
Name Name nvarchar 255

IT Asset Management (Cloud)

Current