This query will create an SCCM device colletion from an AD security group
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 where SMS_R_System.SystemGroupName = "contoso\\ADSecurityGroupName"
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.
- Blogger Comment
Subscribe to:
Post Comments
(
Atom
)
Category
- Active Directory ( 4 )
- App Packaging ( 6 )
- BitLocker ( 9 )
- CrashPlan ( 7 )
- DNS ( 1 )
- DocLink ( 2 )
- Excel ( 2 )
- Exchange ( 4 )
- Group Policy ( 2 )
- Javascript ( 1 )
- OneNote ( 1 )
- Power BI ( 4 )
- PowerShell ( 29 )
- SCCM ( 20 )
- SCCM Device Collections ( 10 )
- SCCM Reports ( 12 )
- SCCM User Collection ( 2 )
- SCSM ( 2 )
- SharePoint ( 42 )
- SharePoint Design ( 19 )
- Skype for Business ( 1 )
- SQL Server ( 3 )
- SSL Certificates ( 3 )
- Teams ( 1 )
- Windows 10 ( 3 )
- Windows 7 ( 4 )
- Windows Server ( 5 )

0 comments:
Post a Comment