SCCM User Collection from AD security group

This query will create an SCCM device colletion from an AD security group

select SMS_R_USER.ResourceID,SMS_R_USER.ResourceType,SMS_R_USER.Name,SMS_R_USER.UniqueUserName,SMS_R_USER.WindowsNTDomain from SMS_R_User where UserGroupName = "contoso\\ADSecutirtGroupName"

you will replace the name of the security group in the query with your own, using a double backslash as an escape character to put in a single backslash.
Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.
    Blogger Comment


Post a Comment

Note: Only a member of this blog may post a comment.