Patch Tuesday drops a hundred CVEs and six vendor advisories, and the real question is never "what got patched" — it is "what of this applies to our machines, what breaks, and what cannot wait." An LLM grounded in your asset inventory turns a morning of skimming into a fifteen-minute applicability brief.
Tier: Core · Workflow area: Troubleshooting & diagnosis · ~35 minutes
This playbook builds a repeatable monthly (and out-of-band) routine: pull the advisory text, pull an inventory export, and have Claude or ChatGPT cross-reference the two into a ranked, estate-specific action list — with every claim traceable back to a CVE ID or KB number you can verify.
Export a minimal inventory slice. From Intune, your RMM, or SCCM, export one CSV: hostname, OS + build, role (server/workstation/kiosk), and the top installed apps with versions. Strip user names and IP addresses — the model needs software facts, not identities.
Get-CimInstance Win32_Product |
Select-Object Name, Version |
Sort-Object Name -Unique |
Export-Csv .\apps-inventory.csv -NoTypeInformation
For estate-wide data, use your RMM's software inventory report instead — one row per app-version with an install count.
Collect the advisory text. Paste the Microsoft Security Update Guide summary for the month (or the specific vendor advisory), plus CISA KEV additions since your last cycle. Plain text is fine; the model does not need the portal.
Run the applicability prompt.
You are helping a sysadmin triage this month's security advisories
against their estate. Below: (1) advisory summaries, (2) an inventory
summary (OS builds, app versions, install counts).
For each advisory that plausibly applies, output a table row:
CVE/KB | affected product+version | our exposure (which builds/apps
match, with install count) | exploited in the wild? (only if the
advisory says so) | urgency (Now / This cycle / Ignore) | one-line why.
Rules:
- If the inventory does not show a matching product, mark "No match
in inventory" — do not speculate.
- Quote the exact version range from the advisory for every match.
- List separately: advisories you could not assess and why.
Advisories: [paste]
Inventory: [paste]
Verify the "Now" rows against ground truth. For each urgent row, confirm in the patch console or vulnerability scanner that the affected version is really deployed. A sample verification note:
CVE-2026-31842 | Chrome < 128.0.6613 | AI said: 214 installs affected
Console check: 198 devices below 128.0.6613 (16 already updated since
export) — CONFIRMED, urgency Now, force-update ring created
Ask for the breakage brief. Second prompt, same conversation: "For the 'Now' and 'This cycle' items, list known-issue and compatibility notes from the advisories — anything that could break line-of-business apps, printing, or authentication — and what to test in the pilot ring." Known-issue sections are exactly the text humans skip and models do not.
Publish the estate brief. One page to the team channel: five urgent items with CVE IDs and install counts, this-cycle items, no-match items (so nobody re-reads them), and the pilot-ring test list. Date it and file it with the patch cycle records.
Automate the collection, not the judgment. Once the format settles, script the inventory export and advisory fetch so the monthly run starts with files ready. The cross-reference and the verification stay human-triggered and human-checked.
An inventory export can reveal your exact patch gaps — treat it as sensitive, strip hostnames and user fields before pasting into a public assistant, and prefer your tenant-approved AI for anything estate-identifying.
The model reads the hundred pages so you can spend your time on the five rows that matter — but urgency is only real after you have confirmed the version match in the console, not in the chat window.