|
|
|
|
|
To retrieve a list of current cluster users on managed clusters:
SELECT distinct a.ObjectName, a.ObjectUuid, b.ObjectName 'Parent(Site)', a.attributeKey Users FROM K2VW_Clusters a
JOIN K2VW_MServers b ON a.ParentID = b.ObjectID
WHERE a.DateDeleted IS NULL
AND a.attributename = 'UserNames'
AND a.attributeState = 'NEW'
ORDER BY a.ObjectUuid