Log Analytics | Query to pull the Patch installed Date/Time details

[DINESHA]

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

[#2]

@DINESHA 

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

[#3]

@CliveWatson 

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.

[#4]

@DINESHA 

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

[#5]

@CliveWatson 

The query will show the last time generated data (Agent collected data),  it doesn't show the patch applied date 

[#6]

Hello @DINESHA did you find any solution for this plz.