DiscoveredVirtualMachine_ci (Staging Table)

FlexNet Manager Suite 2021 R1 (On-Premises)

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

FlexNet Manager Suite (On-Premises)

2021 R1