Hey folks,
Back in August, I put together an SQL query to help summarize the Microsoft Patch Tuesday reports published monthly by Lansweeper: https://www.lansweeper.com/blog/patch-tuesday/
The goal is to pull only the most relevant information about assets, vulnerabilities, and patches — making the output more concise and easier to track internally.
🧭 Query Objective:
- Retrieve key inventory data from Lansweeper related to Patch Tuesday updates.
- Consolidate the results into a single, easy-to-read summary view.
- Provide a solid base for internal monthly reports and update tracking.
⚠️Notes:
- There are definitely more elegant and optimized ways to achieve the same results.
- Any collaboration, improvements, or ideas for extra fields are more than welcome!
In September, I shared an updated version of the query as a comment on the same thread — now including the September patches: see archives bellow
Starting now, I’ll be posting a new thread each month with the latest version of this report, updated for every new Microsoft Patch Tuesday release.
Hopefully, this helps you gain clearer visibility into how updates are progressing and evolving across your environment.
> Summary SQL file: 2025/Aug
> Summary SQL file: 2025/Sep
> Summary SQL file: 2025/Oct: see archive bellow 👇
Cheers
