The notebook
PowerShell, SQL, and things I've learned along the way.
Browse by topic
All posts
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.
Scraping 52 government websites that all publish differently
How It's Half-Staff Because keeps track of 52 government sources that move, duplicate, and quietly drop orders.