I have clients that aren't populating into collections with queries created by the collection wizard, however they show up in All Systems. I still have a PSS case open, however the tech is reassigning the case to the SQL team which doesn't seem right to me - so I'm posting here. Here is the query I've been using, which was created via the collection wizard and has been working until recently, but still populates about 2/3's of them: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.Name like "lap%" Here is the modified query used by the MS tech for my PSS case: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_SYSTEM WHERE Name LIKE 'lap%' The section he removed from the above query is in bold , which populates the collection with the systems that are absent from the collection made with the collection wizard. This is a recent problem and it seems systems imaged within the last 2-3 months aren't showing up Checked to make sure all the systems had unique GUIDS and that duplicates did not exist colleval.log on the server displayed no errors Systems are XP SP2 I have some inkling of belief that this is WMI related due to the errors in the Execmgr.log, but I could be incorrect in that assertion: Failed to open to WMI namespace '\\.\root\ccm\Policy\Machine' (80004002) execmgr 3/9/2010 3:59:08 PM 3248 (0x0CB0) Failed to ConnectSettings for ICcmPolicyAgent in CSoftDistPolicyNamespace::ConnectToNamespace execmgr 3/9/2010 3:59:08 PM 3248 (0x0CB0) Failed to ConnectToNamespace in CSoftDistPolicyNamespace::GetMachinePolicy execmgr 3/9/2010 3:59:08 PM 3248 (0x0CB0) Failed to connect to machine policy name space. 0x80004002 execmgr 3/9/2010 3:59:08 PM 3248 (0x0CB0) Failed to connect to user policy name space execmgr 3/9/2010 3:59:08 PM 3248 (0x0CB0) CSoftwareDistPolicyMgr::GetSWDistSiteSettings failed to connect to machine namespace execmgr 3/9/2010 3:59:08 PM 3248 (0x0CB0) Failed to instantiate UI Server {C2F23AE4-82D8-456F-A4AF-A2655D8CA726} with error 8000401a execmgr 3/9/2010 3:59:08 PM 3248 (0x0CB0) Failed to instantiate UI Server 2 {E8425D59-451B-4978-A2AB-641470EB7C02} with error 8000401a execmgr 3/9/2010 3:59:08 PM 3248 (0x0CB0) Failed to instantiate Updates UI Server {2D023958-73D0-4542-8AD6-9A507364F70E} with error 8000401a execmgr 3/9/2010 3:59:08 PM 3248 (0x0CB0) Failed to instantiate VApp UI Server {00AAB372-0D6D-4976-B5F5-9BC7605E30BB} with error 0x8000401A execmgr 3/9/2010 3:59:08 PM 3248 (0x0CB0) ****** Failed to instantiate UI Server {C2F23AE4-82D8-456F-A4AF-A2655D8CA726} with error 80004002 execmgr 3/10/2010 1:31:33 PM 5320 (0x14C8) Failed to instantiate UI Server 2 {E8425D59-451B-4978-A2AB-641470EB7C02} with error 80004002 execmgr 3/10/2010 1:31:33 PM 5320 (0x14C8) Failed to instantiate Updates UI Server {2D023958-73D0-4542-8AD6-9A507364F70E} with error 80004002 execmgr 3/10/2010 1:31:33 PM 5320 (0x14C8) Failed to instantiate VApp UI Server {00AAB372-0D6D-4976-B5F5-9BC7605E30BB} with error 0x80004002 execmgr 3/10/2010 1:31:33 PM 5320 (0x14C8) Any insight is greatly appreciated. Thank you, Mike

Both queries are fine and I don't see how this is a SQL problem. Yes, I think you are right that this is a WMI issue. I would call back the CSS rep and ask him to work on the WMI issue with you.http://www.enhansoft.com/

I just wanted to update this...Clients weren't processing hardware inventory, after looking at the SQL server and IIS, we ended up removing and reinstalling the management point, which resolved the problem.