Weekly Tip 63

Build ConfigMgr Collection from PowerShell

There are four commands that you need to build a collection from PowerShell. You can use this set of commands to build your collection structure, if that structure is based off of another system, such as AD. Just change the commands the around to create based on OU or group names. This will need to be executed from a machine where the ConfigMgr console is installed.  The last command adds the collection to an administrative user. You can leave that one off if needed.

All of these commands are for device collections. If you are building user collections, simply change “device” in the cmdlet to “user”.

Here are the commands:

import-module ($Env:SMS_ADMIN_UI_PATH.Substring(0,$Env:SMS_ADMIN_UI_PATH.Length-5) + ‘\ConfigurationManager.psd1’)

$coll = new-cmdevicecollection -limitingcollectionID <ID of limiting collection> -name <collection name>

move-object -objectID $coll.CollectionID -folderpath <path to folder for collection>

add-cmdevicecollectionquerymembershiprule -collectionID $coll.collectionID -queryexpression <collection query> -rulename <rulename>

add-cmdevicecollectiontoadministrativeuser -administrativeusername “<domain\user>” -devicecollectionID $coll.collectionID

Example:

Collection Name: Accounting

Limiting Collection: All Windows 7 Computers (collection ID TST00010)

Folder Path: Device Collections > CONTOSO > Accounting

Collection Query: select * from SMS_R_System where SMS_R_System.SystemOUName = “CONTOSO.COM/Clients/Accounting”

Collection Query Rule Name: Accounting

Collection Administrator: Accounting-Admins

import-module ($Env:SMS_ADMIN_UI_PATH.Substring(0,$Env:SMS_ADMIN_UI_PATH.Length-5) + ‘\ConfigurationManager.psd1’)

$coll = new-cmdevicecollection -limitingcollectionID “TST00010” -name “Accounting”

move-object -objectID $coll.CollectionID -folderpath “TST:\DeviceCollection\CONTOSO\Accounting”

add-cmdevicecollectionquerymembershiprule -collectionID $coll.collectionID -queryexpression ‘select * from SMS_R_System where SMS_R_System.SystemOUName = “CONTOSO.COM/Clients/Accounting”‘ -rulename “Accounting”

add-cmdevicecollectiontoadministrativeuser -administrativeusername “CONTOSO\Accounting-Admins” -devicecollectionID $coll.collectionID

Disclaimer

All content provided on this blog is for information purposes only. Windows Management Experts, Inc makes no representation as to accuracy or completeness of any information on this site. Windows Management Experts, Inc will not be liable for any errors or omission in this information nor for the availability of this information. It is highly recommended that you consult one of our technical consultants, should you need any further assistance.

Share:

Facebook
Twitter
LinkedIn

Contact Us

Name
=
On Key

More Posts

WME Microsoft 365 Updates No. 025
Azure

WME Microsoft 365/Azure Updates 22 August 2025

1. Exchange Online: Temporary Mailbox Access Disruption via MAPI Overview Some Exchange Online users experienced mailbox access issues via the Messaging API (MAPI) on August 20, 2025. The disruption occurred after Microsoft reverted a recent service

Read More »
Be assured of everything

Get WME Services

Stay ahead of the competition with our Professional IT offerings.

=