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

Copper Contributor

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

 

Screenshot.png

6 Replies

@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.

@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

 

@CliveWatson 

 

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

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

@jalilmed 

You have to query the table "UpdateRunProgress"

Example RecordExample Record