Because we wish to exclude these machines from the gathering I basically negate the above query which has a not statement. So give me all IDs that aren't part of that sub-range. Considering the fact that the initial WQL query continues to be restricted into the SCCM collection, the http://microsoft-virtual-machine72479.mybloglicious.com/9414237/the-smart-trick-of-sccm-sql-query-for-add-remove-programs-that-nobody-is-discussing