I am trying to figure out how to build a report for Windows 10 1909 which shows in common language on which patch level (based on installed KB) a system is.
I know from MS documentation that for example if KB4530684 is installed, patch level = December 2019 and if KB4528760 or KB4532695 is installed, patch level = January 2020 (sometimes they release multiple KBs in one month).
My report should show AssetName, UserName, IPAddress, IPLocation, Manufacturer, Model, OS, LastSeen, LastTried, WindowsUpdateInfoLastScanned and of course the patch level (in format Month Year).
I'll probably have to incorporate soemthing like
Case
When tblQuickFixEngineeringUni.HotFixID = 'KB4530684' Then 'December 2019'
When tblQuickFixEngineeringUni.HotFixID = 'KB4528760' or tblQuickFixEngineerUni.HotFixID = 'KB4532695' Then 'January 2020'
....
But unsure how to format everything... Any help would be much appreciated.
