Weekly Tip 67

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


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


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.



Contact Us

On Key

More Posts

WME Security Briefing 27 May 2024

Kinsing Hacker Group Exploits Docker Vulnerabilities Overview Recent investigations have shown that the hacker group Kinsing is actively exploiting Docker vulnerabilities to gain unauthorized access to systems. The modified hacker group targets misconfigured Docker API ports deployed with cryptocurrency mining malware.

Read More »
WME Cybersecurity Briefings No. 010
Cyber Security

WME Security Briefing 20 May 2024

Advanced Persistent Threats: North Korean Hackers Launch Golang Malware Overview A new malware strain, called Titan Stealer, is currently actively circulating in the threat landscape, targeting a variety of personal data and linked to North Korean state-sponsored cyber espionage

Read More »
WME Cybersecurity Briefings No. 009
Cyber Security

WME Security Briefing 08 May 2024

Exploitable vulnerability in Microsoft Internet Explorer, used to deploy VBA Malware Overview Cybersecurity researchers discovered a severe exploitation targeting a bug that had already been patched in the Microsoft Internet Explorer browser. Their report added that

Read More »
Be assured of everything

Get WME Services

Stay ahead of the competition with our Professional IT offerings.