ausgovcaf-cloudsoe/kql/windows-software-updates-ag...

8 строки
360 B
Plaintext

//Shows the oldest updates not yet installed
Update
| where MSRCSeverity == "Critical" or MSRCSeverity == "Security"
| summarize arg_max(TimeGenerated, *) by UpdateID,SourceComputerId
| where UpdateState != "Installed"
| project Computer, Product, MSRCSeverity, KBID, Title, UpdateState, HoursOld = datetime_diff('hour',now(),PublishedDate)
| sort by HoursOld