SCCM report for collection which does not have any advertisement Posted on December 1, 2011 by Eswar Koneti | 4 Comments | 880 Views select * from dbo.v_Collection Col Where Col.CollectionID not in (select CollectionID from dbo.v_Advertisement)Read more »