How can I create a report or a dashboard view showing when the last windows patches were applied or installed?

cfizz34

I am looking for a report or dashboard that shows when the last windows updates were installed. Can anyone assist?

jm_sysadmin

The SWQL below can go into a dashboard or report. This finds windows servers and needs the Asset Inventory to be collected. ALso remember that the inventory is polled on a cycle and may be a few days out of date. 

SELECT N.DisplayName, N.IPAddress, Max(N.AssetInventory.OSUpdates.InstallDate) as [Last Update install]
FROM Orion.Nodes N 
Where N.Vendor like 'Windows' and N.IsServer = True 
Group By N.DisplayName, N.IPAddress