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 barchartExplanation
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
Released: January 25, 2021
Tables
UpdateUpdateSummary
Keywords
UpdateUpdateSummaryComputerUpdateStateInstalledResourceIsUpdateNeededUpdateTitleTitleUpdateTypeClassificationKBKBIDOsVersiondistinctsortsummarizecountrenderbarchart
Operators
joinwhereextenddistinctsort bysummarizerender