Last patched date and patch name

[Sujay]

Hi All,

I am using below query to get the Last Install Date of a Patch, can someone please help me get the corresponding hotfixid to the last patched date?

Patch Last Install Date - WMI query issues

I am using the following WMI relevance query for “Last Install Date of a Patch”: q: if (not Windows of operating system) then "N/A" else if (exists wmi) then (maximum of (it as date) of (((it as integer as string) of preceding text of last "/" of following text of first "/" of it ) &" "& (preceding text of first "/" of it as integer as month as three letters)&" "& (following text of last "/" of it as integer as string)) of (((string value of property "InstalledOn" of it) of select objects "Inst…