SCCM report list collections with no deployments – All about Microsoft Endpoint Manager

SCCM report list collections with no deployments – All about


The next SQL question can be utilized to question the record of collections that does not have any deployments. you may assessment the variety of collections with no deployments and you may additional lengthen the question to exclude sure folders the place you employ these exception collections for troubleshooting or different goal.

choose Col.Identify,
col.CollectionID,
case when col.CollectionType="2" then 'Machine Primarily based' 
when col.CollectionType="1" then 'Used Primarily based' 
Else 'Others' finish as 'Assortment Kind',
col.MemberCount,
coll.ObjectPath from dbo.v_Collection Col
internal be a part of v_Collections coll on coll.SiteID=col.CollectionID
The place Col.CollectionID not in (choose CollectionID from dbo.v_Advertisement)
order by Col.Identify


We use cookies to enable site functionality and collect data about user interactions. By clicking Accept, you agree to our use for advertising, analytics, and support.