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
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. 024
Cyber Security

WME Security Briefing 28 August 2024

GhostWrite Vulnerability in T-Head CPUs Exposes Devices to Unrestricted Access Overview A critical architectural flaw in T-Head’s XuanTie C910 and C920 RISC-V CPUs was uncovered by recent research from the CISPA Helmholtz Center for Information Security. Dubbed GhostWrite, the vulnerability

Click Here to Read Full Article »
Be assured of everything

Get WME Services

Stay ahead of the competition with our Professional IT offerings.

=