Isn't there a built in collection? All Windows Server Systems select * from sms_r_system where OperatingSystemNameAndVersion like 'Microsoft Windows NT%Server%' Regards, Blair Muller Check Out My Blog: http://blair-muller.blogspot.com/ There is. But its not showing two 2008 R2 servers that are SCCM site servers and have the SCCM client. But its showing other SCCM site servers. So not sure that the built in query is all encompassing? We are using 2007 R3,

Are you able to see these systems in all collections ? Are you also using any collection limitations ? for this above WQL query ? that should work... May be a simple question... are you updated the collection membership ? This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Open up resource explorer of those servers and check for the updates?Anoop C Nair - Twitter @anoopmannur MY BLOG: http://anoopmannur.wordpress.com SCCM Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.

Are you able to see these systems in all collections ? Are you also using any collection limitations ? for this above WQL query ? that should work... May be a simple question... are you updated the collection membership ? This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Feel like an idiot. Update membership did it. We had purged Data Discovery Data recently and the collection just hadn't updated in enough time.

Anyone have a query I can use to find just Windows Servers in my organization. Any system that has the operating system: Windows Server 2000, Windows Server 2003, Windows Server 2008 or Windows Server 2008 R2. Either 32 or 64-Bit Systems. Haven't had much luck creating my own query.

Isn't there a built in collection? All Windows Server Systems select * from sms_r_system where OperatingSystemNameAndVersion like 'Microsoft Windows NT%Server%'Regards, Blair Muller Check Out My Blog: http://blair-muller.blogspot.com/