Hi, I'm Jason.
I work in IT, build things, and write down what I learn.
This is where I share PowerShell, Configuration Manager notes, and things I build. Hopefully something here makes your job a little easier or saves you a few dollars.
A little more about me →
From the notebook
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.