Query to split servers/workstations?
I have a Collection of all SCCM Clients. Under that i have sub-collections based on Client domain. I want to then create sub-collections of these named "Servers" and "Workstations". I could use our internal naming conventions to define the queries, however I would rather it be more accurate and base it on OS. What's the easiest/quickest way to determine if the OS is a server or workstation OS? Thanks in advance Chez
July 27th, 2010 3:13pm

SMS_R_System.OperatingSystemNameandVersion not like "%server%" and/or SMS_R_System.OperatingSystemNameandVersion like "%server%" Or you could simply limit your collection to the built-in All Windows Workstation or Professional Systems and All Windows Server Systems. Or you could steal the code from those collections and use that. select * from sms_r_system where OperatingSystemNameAndVersion like 'Microsoft Windows NT%Workstation%' select * from sms_r_system where OperatingSystemNameAndVersion like 'Microsoft Windows NT%Server%' John Marcum | http://myitforum.com/cs2/blogs/jmarcum |
Free Windows Admin Tool Kit Click here and download it now
July 27th, 2010 3:31pm

Thanks :)
July 27th, 2010 5:16pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics