SCCM Collection 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_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%"

[Jorgen Nilsson]

Hi,

You need to replace "=" with "LIKE" here: SMS_R_System.OperatingSystemNameandVersion = "%server%6.0%"

it should be: SMS_R_System.OperatingSystemNameandVersion LIKE "%server%6.0%"

 

That should do it.

Regards,

Jörgen

[Deano]

Hi,

You need to replace "=" with "LIKE" here: SMS_R_System.OperatingSystemNameandVersion = "%server%6.0%"

it should be: SMS_R_System.OperatingSystemNameandVersion LIKE "%server%6.0%"

 

That should do it.

Regards,

Jörgen

 

Thanks for getting back to me, but the change to Like has not worked. I have tried to update collection membership as well but the 2003 servers still remain. Is it becuase im trying to poll two seperate AD OUs?