KQL Search

Query Details

HomeAI ToolsDevice Query

Update Compliance Bar Chart

Query

//Update Compliance with Barchart

Update
| join UpdateSummary on Computer
| where UpdateState != 'Installed'
| extend Resource = Computer
| extend IsUpdateNeeded = UpdateState
| extend UpdateTitle = Title
| extend UpdateType = Classification
| extend KB = KBID
| distinct Computer, OsVersion, UpdateState, Title, Classification, KBID
| sort by Computer asc 
| summarize count() by Computer
| render barchart

Explanation

This query updates the compliance with a barchart. It joins the "Update" table with the "UpdateSummary" table based on the "Computer" column. It filters out the updates that are not installed. It extends some columns and renames them for better understanding. It then selects distinct values for certain columns and sorts the results by the "Computer" column in ascending order. Finally, it summarizes the count of updates for each computer and displays the results as a barchart.

Details

Rod Trent profile picture

Rod Trent

Released: January 25, 2021

Tables

UpdateUpdateSummary

Keywords

Update,UpdateSummary,Computer,UpdateState,Installed,Resource,IsUpdateNeeded,UpdateTitle,Title,UpdateType,Classification,KB,KBID,OsVersion,distinct,sort,summarize,count,render,barchart

Operators

joinwhereextenddistinctsort bysummarizerender

Actions