|
|
|
|
|
To retrieve basic uptime information on a specific managed cluster:
SELECT distinct a.ObjectName, a.ObjectUuid, b.ObjectName 'Parent(Site)',
(CASE a.attributeValue
WHEN '0' then 'STATE_CLUSTER_INIT'
WHEN '1' then 'STATE_CLUSTER_LOCAL_VCS_BUILD'
WHEN '2' then 'STATE_CLUSTER_MASTER_CONNECT'
WHEN '3' then 'STATE_CLUSTER_SLAVE_BUILD'
WHEN '4' then 'STATE_CLUSTER_RUNNING'
WHEN '5' then 'STATE_CLUSTER_EXITING'
WHEN '6' then 'STATE_CLUSTER_EXITED'
WHEN '7' then 'STATE_CLUSTER_FAULTED'
WHEN '8' then 'STATE_CLUSTER_DEAD'
ELSE 'Unknown'
END) State, a.AttributedateModified timestamp
FROM K2VW_Clusters a
JOIN K2VW_MServers b ON a.ParentID = b.ObjectID