The notebook
PowerShell, SQL, and things I've learned along the way.
Topic: Collections
Collections
A SQL query for the devices in a collection
A small, read-only query for collection membership, with the join explained and a starting point for your next report.
Find empty device collections without opening the console
Connect to a ConfigMgr site, list collections with no members, and export a review list with native PowerShell cmdlets.