|
|
|
|
|
To retrieve a list of currently managed clusters:
SELECT distinct a.ObjectName, a.ObjectUuid, a.DateCreated, b.ObjectName
'Parent(Site)'
FROM K2VW_Clusters a
JOIN K2VW_MServers b ON a.ParentID = b.ObjectID
WHERE a.DateDeleted IS NULL
ORDER BY a.ObjectUuid