This query will create an SCCM device collection from computers in an AD Organizational Unit
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.DistinguishedName like "%,OU=Computers,DC=contoso,DC=com"
Replacing the distinguished name of the OU with your own. Use ADSI Edit to help get the distinguished name.
- 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