SCCM Server Groups Report

SCCMServerGroups.sql

/* Script Disclaimer: The sample scripts provided here are not supported under any Microsoft standard support program or service. 
All scripts are provided AS IS without warranty of any kind. 
*/
Select 
	c.Name [CollectionName], 
	LastModificationTime, 
	UseCluster, 
	UseClusterPercentage,
	PreAction, 
	PostAction, 
	ClusterCount, 
	ClusterPercentage, 
	ClusterTimeout
From 
	vSMS_CollectionSettings cs join v_Collection c on cs.CollectionID = c.CollID
Where 
	UseCluster = 1

Select
	c.Name [CollectionName], s.Name0 [SystemName], dm.[State], dm.[TimeStamp]
From DeploymentMutex dm
	join v_R_System s ON s.ResourceID = dm.ResourceID
	join  v_Collection c ON c.CollID = dm.CollectionID
Order By c.Name, dm.[State] Desc

/*
Lock States
There are four lock states:

Waiting for Lock: 0
Have Lock: 1
Released Lock: 2
Node Script Failed: 3

--
*/