HostInfo_ci (Staging Table)

FlexNet Manager Suite 2020 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

FlexNet Manager Suite (On-Premises)

2020 R2