The notebook
PowerShell, SQL, and things I've learned along the way.
Topic: Configuration Manager
Configuration Manager
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.
Six MECM detection types, and when I use each
MSI product code, registry value, registry key, file, compound, and script detection — how I pick one when packaging an application, with the detection rules my packagers actually write.
A one-command MECM lab, and why I stopped hydrating
ConfigMgr Lab Builder builds a working ConfigMgr 2509 site from a bare Windows host in about an hour, then proves the host is clean again when you tear it down. With the config, the audit output, and what the finished lab looks like.