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.