HostInfo_ci (Staging Table)

FlexNet Manager Suite 2022 R2 (On-Premises)

Data in this staging table may also be saved in HostInfo.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:HostInfo
    WHERE NODECOUNT(TRAVERSE Primary:Inference:InferredElement:Host) > 0
   SHOW
    systemid AS 'SystemID',
    lpar_partition_number AS 'LPARPartitionNumber',
    lpar_partition_name AS 'LPARPartitionName',
    lpar_type AS 'LPARType',
    lpar_mode AS 'LPARMode',
    lpar_active_physical_cpus_in_system AS 'LPARActivePhysicalCpusInSystem',
    lpar_shared_physical_cpus_in_system AS 'LPARSharedPhysicalCpusInSystem',
    lpar_shared_pool_id AS 'LPARSharedPoolID',
    lpar_active_cpus_in_pool AS 'LPARActiveCpusInPool',
    lpar_entitled_capacity AS 'LPAREntitledCapacity',
    formatTime(#DiscoveryResult:DiscoveryAccessResult:DiscoveryAccess:
               DiscoveryAccess.starttime,"%FT%T") as 'InventoryDate',
    #Primary:Inference:InferredElement:Host.key AS 'HostKey'

Mapping into HostInfo_ci

Source alias	HostInfo_ci property	Type	Max
HostKey	HostKey	varchar	64
InventoryDate	InventoryDate	datetime
LPARActiveCpusInPool	LPARActiveCpusInPool	int
LPARActivePhysical CpusInSystem	LPARActivePhysical CpusInSystem	int
LPAREntitledCapacity	LPAREntitledCapacity	float
LPARMode	LPARMode	nvarchar	255
LPARPartitionName	LPARPartitionName	nvarchar	255
LPARPartitionNumber	LPARPartitionNumber	int
LPARSharedPhysical CpusInSystem	LPARSharedPhysical CpusInSystem	int
LPARSharedPoolID	LPARSharedPoolID	int
LPARType	LPARType	nvarchar	255
SystemID	SystemID	nvarchar	255