Skip to main content

HardwareEvidenceDetail_ci (Staging Table)

FlexNet Manager Suite ()

Data in this staging table may also be saved in HardwareEvidenceDetail.xml on the staging server.

This data is generated through use of the optional UnixHardwareData pattern, which triggers the Flexera inventory component ndtrack ("the tracker"). Before staging, the information is visible in the Detail node of BMC Discovery, with a type of FNMP_HardwareEvidence.

BMC Discovery query​

This query extracts data from the Detail node in the BMC Discovery datastore, and provides the aliases for properties referenced in the table below:

SEARCH Detail
   WHERE (NODECOUNT(TRAVERSE Detail:Detail:ElementWithDetail:Host) > 0)
    AND (type = 'FNMP_HardwareEvidence')
   SHOW
    os AS 'OS',
    num_processors AS 'Processors',
    num_cores AS 'Cores',
    num_logical_processors AS 'LogicalProcessors',
    processor_type AS 'ProcessorType',
    processor_speed AS 'ProcessorSpeed',
    ram AS 'RAM',
    vendor AS 'Vendor',
    model AS 'Model',
    ip_address AS 'IPAddress',
    mac_address AS 'MACAddress',
    num_disks AS 'NumDisks',
    disk_size AS 'DiskSize',
    vm_type AS 'VMType',
    node_capacity AS 'NodeCapacity',
    node_capacity_in_cores AS 'NodeCapacityInCores',
    node_capacity_in_threads AS 'NodeCapacityInThreads',
    physical_shared_pool_capacity AS 'PhysicalSharedPoolCapacity',
    physical_shared_pool_capacity_in_cores 
       AS 'PhysicalSharedPoolCapacityInCores',
    physical_shared_pool_id AS 'PhysicalSharedPoolID',
    shared_pool_capacity AS 'SharedPoolCapacity',
    shared_pool_capacity_in_cores AS 'SharedPoolCapacityInCores',
    shared_pool_id AS 'SharedPoolID',
    vm_capacity AS 'VMCapacity',
    vm_capacity_in_cores AS 'VMCapacityInCores',
    vm_entitlement AS 'VMEntitlement',
    vm_id AS 'VMID',
    vm_is_capped AS 'VMIsCapped',
    vm_is_shared_type AS 'VMIsSharedType',
    vm_name AS 'VMName',
    partition_id AS 'PartitionID',
    partition_number AS 'PartitionNumber',
    #Detail:Detail:ElementWithDetail:Host.key AS 'HostKey'

Mapping into HardwareEvidenceDetail_ci​

Source aliasHardwareEvidenceDetail\_ci propertyTypeMax
`Cores``Cores``smallint`
`DiskSize``DiskSize``bigint`
`HostKey``HostKey``varchar`64
`IPAddress``IP``nvarchar`512
`LogicalProcessors``LogicalProcessors``smallint`
`MACAddress``MAC``nvarchar`512
`Model``Model``nvarchar`512
`NodeCapacity``NodeCapacity``smallint`
`NodeCapacityInCores``NodeCapacityInCores``smallint`
`NodeCapacityInThreads``NodeCapacityInThreads``smallint`
`NumDisks``NumDisks``int`
`OS``OS``nvarchar`256
`PartitionID``PartitionID``nvarchar`512
`PartitionNumber``PartitionNumber``int`
`PhysicalShared PoolCapacity``PhysicalShared PoolCapacity``smallint`
`PhysicalSharedPool CapacityInCores``PhysicalSharedPool CapacityInCores``smallint`
`PhysicalSharedPoolID``PhysicalSharedPoolID``nvarchar`255
`Processors``Processors``smallint`
`ProcessorSpeed``ProcessorSpeed``int`
`PhysicalLogicalProcessors``PhysicalLogicalProcessors``int`
`ProcessorType``ProcessorType``nvarchar`128
`RAM``RAM``bigint`
`SharedPoolCapacity``SharedPoolCapacity``smallint`
`SharedPoolCapacityInCores``SharedPoolCapacityInCores``smallint`
`SharedPoolID``SharedPoolID``nvarchar`255
`Vendor``Vendor``nvarchar`255
`VMCapacity``VMCapacity``float`
`VMCapacityInCores``VMCapacityInCores``float`
`VMEntitlement``VMEntitlement``float`
`VMID``VMID``nvarchar`255
`VMIsCapped``VMIsCapped``bit`
`VMIsSharedType``VMIsSharedType``bit`
`VMName``VMName``nvarchar`512
`VMType``VMType``nvarchar`128
2025 R1.1

Parent topic:Source to Staging