Cluster_ci (Staging Table)

FlexNet Manager Suite 2022 R2 (On-Premises)

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

BMC Discovery query

This query extracts data from the Cluster node in the BMC Discovery datastore, and provides the aliases for properties referenced in the table below:
SEARCH Cluster
   SHOW
    key AS 'ClusterKey',
    type AS 'ClusterType',
    (type = 'vCenter Cluster' AND 
     (single(#ManagedElement:Management:Manager:SoftwareInstance.instance) 
          + '|' + id)
     OR NONE) AS 'InternalIdentifier',
    (cluster_name OR name) AS 'InternalName',
    single(#HostContainer:HostContainment:ContainedHost:Host.domain) 
          AS 'Domain',
    formatTime(modified(#), "%FT%T") AS 'LastUpdate'

Mapping into Cluster_ci

Source alias Cluster_ci property Type Max
ClusterKey ClusterKey nvarchar 400
ClusterType ClusterType nvarchar 255
Domain Domain nvarchar 512
InternalIdentifier InternalIdentifier nvarchar 512
InternalName InternalName nvarchar 512
LastUpdate LastUpdate datetime  

FlexNet Manager Suite (On-Premises)

2022 R2