Forum Discussion
Log Analytics | Query to pull the Patch installed Date/Time details
Hi Guyz,
Patch InstallTimeAvailable (installed Date/Time) column showing no result while pulling the report for Windows server(s).
Thanks in advance to provide the necessary query to pull those details
6 Replies
I don't re-call that column being used, but please check https://docs.microsoft.com/en-us/azure/automation/automation-update-management-query-logs
Thanks for the quick response, We had gone through with many website(s) including the one you mentioned..still we failed to get any details related to that.
Could you do this another way, this gets the last time an update was applied?Update | where UpdateState == "Installed" | summarize arg_max(TimeGenerated,*) by Title, Computer, Product, ComputerEnvironment, KBID, ApprovalSource, Type
