Skip to main content

HostInfo_ci (Staging Table)

FlexNet Manager Suite ()

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 aliasHostInfo\_ci propertyTypeMax
`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
2025 R1.1

Parent topic:Source to Staging