Quick & Easy way to find all collections with server group setting enabled
In my environment somehow one of our collections had the checkbox for "All devices are part of the same server group" checked (this may be a bug altogether). It was on a workstation collection which prevented those machines from getting updates due to a "Wait on Lock" status. I had to manually click through the collections to find which collection had this setting enabled to clear the lock. It would be helpful to have a quick way to query all collections that have this setting enabled, just in case the admin doesn't know which collection had it enabled.
Kerwin Medina commented
This SQL query would list all collections that has the 'Server Group' option enabled (checked).
select CEP_CollectionExtendedProperties.CollectionID, Collections.SiteID, Collections.CollectionName
join Collections on Collections.CollectionID = CEP_CollectionExtendedProperties.CollectionID
where ISNULL(CEP_CollectionExtendedProperties.UseCluster,0) = 1