All systems show in a collection after removing the criteria from a query for a query based collection in System Center Configuration Manager 2007.
Removing the criteria in the query for a query based collection removes the from statement from the query and leaves only the select statement. This causes all systems to be added to a collection that may already have an OSD or other advertisement targeted to it.
If you need to modify an existing query based collection, delete the existing query and create a new one instead.
For the latest version of this article see the link below:
J.C. Hornbeck | System Center Knowledge Engineer
The App-V Team blog: http://blogs.technet.com/appv/
The WSUS Support Team blog: http://blogs.technet.com/sus/
The SCMDM Support Team blog: http://blogs.technet.com/mdm/
The ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
The SCOM 2007 Support Team blog: http://blogs.technet.com/operationsmgr/
The SCVMM Team blog: http://blogs.technet.com/scvmm/
The MED-V Team blog: http://blogs.technet.com/medv/
The DPM Team blog: http://blogs.technet.com/dpm/
The OOB Support Team blog: http://blogs.technet.com/oob/
The Opalis Team blog: http://blogs.technet.com/opalis