SCCM report for collection which does not have any advertisement Posted on December 1, 2011 by Eswar Koneti | 4 Comments | 1,164 Views select * from dbo.v_Collection Col Where Col.CollectionID not in (select CollectionID from dbo.v_Advertisement)
Amol Thakur January 12, 2018 at 12:33 AM · Edit Hello Eswar, did you tried for Query which work in sccm 2012 for collection which dont have deployment and advertisement Loading... Reply
Eswar Koneti January 20, 2018 at 2:52 PM · Edit Hi, Did you see this post? http://eskonr.com/2016/12/sccm-configmgr-how-to-find-applications-with-no-deployments-as-part-of-maintenance-tasks/ Regards, Eswar Loading... Reply
San July 19, 2017 at 7:15 PM · 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 Loading... Reply
Eswar Koneti July 19, 2017 at 9:43 PM · 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 Loading... Reply
Hello Eswar,
did you tried for Query which work in sccm 2012 for collection which dont have deployment and advertisement
Hi,
Did you see this post? http://eskonr.com/2016/12/sccm-configmgr-how-to-find-applications-with-no-deployments-as-part-of-maintenance-tasks/
Regards,
Eswar
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
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