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