Forum Discussion
DINESHA
Apr 13, 2020Copper Contributor
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 ...
CliveWatson
Apr 14, 2020Former Employee
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
DINESHA
Apr 14, 2020Copper Contributor
The query will show the last time generated data (Agent collected data), it doesn't show the patch applied date
- SalvatoreSLOAug 04, 2023Copper Contributor