Need a relevance query to get the list of installed KB patches

[brolly33]

@tarwaniv

Here is a post that should help get you started.

List all KB Updates in Add/Remove Programs

Maybe This relevances will help you HotFixID; if (exists wmi) then ((string value of property "HotFixID" of it) of select objects "HotFixID from Win32_QuickFixEngineering where HotFixID != 'File 1'" of wmi) as string else ("N/A") InstalledOn; if (exists wmi) then ((string value of property "InstalledOn" of it) of select objects "InstalledOn from Win32_QuickFixEngineering where HotFixID != 'File 1'" of wmi) as string else ("N/A")

Add a whose clause to filter for 7 days (or tweak the wmi call and add your filter there).