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

Capture

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
Picture of Matt Tinney

Matt Tinney

Professional IT executive & business leader having decades of experience with Microsoft technologies delivering modern-day cloud & security solutions.

Contact Us

=
On Key

More Posts

WME Cybersecurity Briefings No. 020
Cyber Security

WME Security Briefing 26 July 2024

Pro-Houthi Group Targets Yemen Aid Organizations with Android Spyware Overview A suspected pro-Houthi group, OilAlpha, is targeting humanitarian organizations in Yemen with advanced Android spyware. The operation is associated with the activity cluster codenamed OilAlpha. It

Read More »
WME Cybersecurity Briefings No. 019
Cyber Security

WME Security Briefing 23 July 2024

Samba File Shares Targeted by DarkGate Malware in Recent Cyber Offensive Overview Recent investigations by Palo Alto Networks uncover a brief but significant cyberattack campaign utilizing DarkGate malware. This malicious software exploited Samba file shares to

Read More »
WME Cybersecurity Briefings No. 018
Cyber Security

WME Security Briefing 15 July 2024

OVHcloud Mitigates Record-Breaking 840 Million PPS DDoS Attack Overview In April 2024, OVHcloud, a top French cloud computing firm, successfully stopped a massive DDoS attack. The attack hit a record-breaking rate of 840 million packets per second

Read More »
E-Commerce Security - Solutions for Online Retailers
Azure

E-commerce Security – Solutions for Online Retailers

Today’s hyper-charged e-commerce landscape demands top-notch cybersecurity measures. Cybersecurity for this bustling sector isn’t just about ticking a technical box; it’s the cornerstone of building trust. As businesses and consumers flock to the online space, the

Read More »
Be assured of everything

Get WME Services

Stay ahead of the competition with our Professional IT offerings.

=