SCCM report for collection which does not have any advertisement

select 
	* 
from 
	dbo.v_Collection Col
Where
	Col.CollectionID not in (select CollectionID from dbo.v_Advertisement)

2 Responses to "SCCM report for collection which does not have any advertisement"

    1. Hi Sandeep,
      Yes that one is for SCCM 2007 and in SCCM 2012 ,you have applications added which do not have any advertisements instead they call deployments.
      You can tweak the query posted in this blog post http://eskonr.com/2016/12/sccm-configmgr-how-to-find-applications-with-no-deployments-as-part-of-maintenance-tasks/ though it is to identify applications that do not have any deployments. When i get time ,i will look at this requirement.

      Regards,
      Eswar

      Reply

Leave a Reply