July 2024 Patch Tuesday bug (ON PREM)

[mbsr]

Since June, I have noticed a flaw in the Patch Tuesday reports, showing red/OutOfDate when the Assets are indeed updated.  After digging into several tables and comparing OS version numbers and KB releases, I have found a fix for July 2024. by adding KB5040435 to the selection list in SubQuery1, the updated info is now correctly shown. 

Where tblQuickFixEngineeringUni.HotFixID In ('KB5040485', 'KB5040456', 'KB5040448', 'KB5040434', 'KB5040430', 'KB5040427', 'KB5040437', 'KB5040438', 'KB5040431', 'KB5040442','KB5040435')) As SubQuery1

Manually editing the report SQL to add  KB5040435 to the criteria for SubQuery1 resolved the issue for me. Now I have 90% green instead of 90% red.

[mbsr]

Understandable. Thank you for including the references you use in the report. I see what happened, I had approved that in my WSUS -- and that's when the reports turned red. Cause and effect. 

[Esben_D · Accepted solution]

Windows 11 version 24H2 is still in preview right?

Preview builds are not supported in the PT report, I use MS official listing (https://support.microsoft.com/en-us/topic/windows-11-version-23h2-update-history-59875222-b990-4bd9-...) which doesn't have 24H2 listed yet.
If I go off of this article: https://www.windowscentral.com/software-apps/windows-11/windows-11-version-24h1-changelog-release-da...

Microsoft is shipping 24H2 already on Copilot+ PCs but isn't listing it yet? Its not even on their MSRC page (https://msrc.microsoft.com/update-guide/deployments)...

I would be happy to include it, but I a reliable index of the updates they release, I doubt they will add it until its live for everyone.