DiscoveredVirtualMachine_ci (Staging Table)

IT Asset Management (Cloud)

Data in this staging table may also be saved in DiscoveredVirtualMachine.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:VirtualMachineList
     WHERE access_method IS DEFINED
    TRAVERSE List:List:Member:DiscoveredVirtualMachine
   SHOW
    name AS 'Name',
    uuid AS 'UUID',
    config_os_full AS 'ConfigOSFull',
    power_state AS 'PowerState',
    vsphere_id AS 'vSphereID',
    #Member:List:List:VirtualMachineList.access_method AS 'AccessMethod',
    formatTime(modified(#), "%FT%T") AS 'LastUpdate',
    #Member:List:List:VirtualMachineList.#DiscoveryResult:DiscoveryAccessResult:
        DiscoveryAccess:DiscoveryAccess.#Associate:
        Inference:InferredElement:Host.key AS 'HostKey'

Mapping into DiscoveredVirtualMachine_ci

Source alias	DiscoveredVirtualMachine_ci property	Type	Max
AccessMethod	AccessMethod	nvarchar	255
ConfigOSFull	ConfigOSFull	nvarchar	512
HostKey	HostKey	varchar	64
LastUpdate	LastUpdate	datetime
Name	Name	nvarchar	512
PowerState	PowerState	nvarchar	255
UUID	UUID	nvarchar	255
vSphereID	vSphereID	nvarchar	255