Link to home
Start Free TrialLog in
Avatar of GrizNation23
GrizNation23Flag for United States of America

asked on

sccm 2012 r2 device collection query rule

how can i query OU and OS version for my device collection. I have an OU with windows 10 pcs and they are not updating in my device collection. I am only updating windows 7 pcs at this time. I can create a query for windows 10 but populates with all win10 in my AD.

so far this is my query but no success:
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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.SystemOUName = "domain.com/LABS/COMPUTERS/PCS" and (SMS_G_System_OPERATING_SYSTEM.Version = "10.0.10586") and (SMS_G_System_OPERATING_SYSTEM.Version = "10.0.14393")
ASKER CERTIFIED SOLUTION
Avatar of Mike Taylor
Mike Taylor
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Solution given correct given situation but cannot verify without OP returning.
Avatar of GrizNation23

ASKER

this worked like a charm. sorry for late check in  but I have been on vacation and completely forgot about this question. thanks,
That's Ok. Glad it worked :).