SCCM report for collection which does not have any advertisement

Posted on December 1, 2011 by | 4 Comments | 1,478 Views 
select 
	* 
from 
	dbo.v_Collection Col
Where
	Col.CollectionID not in (select CollectionID from dbo.v_Advertisement)

Related Posts

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

  2. San · Edit

    Hello Eswar, this query is for Sccm 2007 and wont work well on Sccm 2012. Do you have query which will work for 2012??

    Thanks,
    Sandeep

    Reply
    1. Eswar Koneti · Edit

      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

Post Comment