SCCM: How to exclude collections in CM07 queries.
If you for some reason still are using System Center Configuration Manager 2007 (and for some reason cannot migrate to CM2012), you can achieve the same by modifying your query. Add the following to your Query (marked in red), J is the "Collection id": Select SMS_R_ from SMS_R_System where SMS_R_ not in ...