Apr 13 2020
- last edited on
Apr 08 2022
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
Apr 14 2020 12:25 AM
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
Apr 14 2020 06:02 AM
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.
Apr 14 2020 07:23 AM
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
Apr 14 2020 09:25 AM - edited Apr 16 2020 04:32 AM
The query will show the last time generated data (Agent collected data), it doesn't show the patch applied date