Hi,

I have a few location for servers and i am trying to create a query that pulls in the servers. I can get the collection to work by polling the two OU's but this pulls through some legacy 2003 servers. to get rid of these, i have added query for the OS version. When i add the OS version, i get nothing in the collection??

select
SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier ,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYST EM.Client from SMS_R_System where
(SMS_R_System.SystemOUName = "test.internal/test_domain/test_member_servers"
or
SMS_R_System.SystemOUName = "test.internal/Domain Controllers")

and SMS_R_System.OperatingSystemNameandVersion = "%server%6.0%"