I have this simple SQL query: SELECT Name0, COUNT(*) FROM v_R_System GROUP BY Name0 HAVING COUNT(*) > 1 ORDER BY Name0 This returns a list of Duplicate computer names that I can use to clean up obsolete computers (faster than they normally will be cleared in our multi-tiered installation.) I would like to use a WQL query to populate a Collection that can then be used to investigate and/or delete these systems. I have found that Extended WQL allows use of COUNT, but I have not been able to come up with a query that ConfigMgr will accept as valid. Is this possible? We are using ConfigMgr 2007 SP2.

That's not possible because of WMI limitations: http://msdn.microsoft.com/en-us/library/aa394606(v=VS.85).aspx Torsten Meringer | http://www.mssccmfaq.de