SCCM Collection Query Help

[deano]

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_SYSTEM.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%"