workstations collection + primary users are members of a security group RRS feed

  • Question

  • Can anyone help me with this?

    I want to make a collection of devices where the primary user is the member of a particular security group.  I don't know where to start.


    Nmål Carlpson

    Tuesday, March 19, 2013 12:41 AM


  • Use this query to create the collection you want. Edit the sub query portion to check for security group membership.

    Select SMS_R_SYSTEM.Name,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client, SMS_R_User.UniqueUserName FROM SMS_R_System JOIN SMS_UserMachineRelationship ON SMS_R_System.Name=SMS_UserMachineRelationship.MachineResourceName JOIN SMS_R_User ON SMS_UserMachineRelationship.UniqueUserName=SMS_R_User.UniqueUserName where SMS_R_User.UniqueUserName in

    (select SMS_R_User.UniqueUserName from SMS_R_User)


    Tuesday, March 19, 2013 9:17 AM