SOLVED Exclude Windows Servers Collection

[zachlds]

Hey guys I am trying to modify this query to exclude 2003 servers. Can anyone help me with this?

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 SMS_R_System.Client is null

 

[Garth]

You can get do this by querying OS Name and Version in the SMS_R_system class. However it might be easier to create a collection of Win2k3 computer and then exclude that collection in your other one. Really the best answer is to upgrade them to a supported OS.

 

[Prajwal Desai]

What @Garth suggested is correct. You can create a device collection to group Windows 2003 servers. Then exclude that under the properties of new collection.