Hey folks,
I recently put together a SQL query (yes, a bit rough around the edges 😅) to help summarize the Microsoft “Tuesday Patch” reports published monthly by LanSweeper here: https://www.lansweeper.com/blog/patch-tuesday/.
The goal was to gather only the most relevant information about assets, vulnerabilities, and patches, making the output more concise for internal tracking.
It’s nothing final — just a functional first draft for our environment.
Query Objective:
- Pull key inventory data from LanSweeper related to Patch Tuesday updates.
- Consolidate results for easier viewing.
- Serve as a base for monthly internal reports.
⚠️ Notes:
- This is an initial draft, with some manual adjustments still needed.
- There are definitely more elegant and efficient ways to achieve the same result.
- Any collaboration, optimization, or suggestions for additional fields are more than welcome.
Sharing here so we can work together to improve it and maybe even turn it into a standard report for everyone.
