GrizNation23
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,SM S_R_SYSTEM .ResourceT ype,SMS_R_ SYSTEM.Nam e,SMS_R_SY STEM.SMSUn iqueIdenti fier,SMS_R _SYSTEM.Re sourceDoma inORWorkgr oup,SMS_R_ SYSTEM.Cli ent from SMS_R_System inner join SMS_G_System_OPERATING_SYS TEM on SMS_G_System_OPERATING_SYS TEM.Resour ceId = SMS_R_System.ResourceId where SMS_R_System.SystemOUName = "domain.com/LABS/COMPUTERS /PCS" and (SMS_G_System_OPERATING_SY STEM.Versi on = "10.0.10586") and (SMS_G_System_OPERATING_SY STEM.Versi on = "10.0.14393")
so far this is my query but no success:
select SMS_R_SYSTEM.ResourceID,SM
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Solution given correct given situation but cannot verify without OP returning.
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 :).