Forum Discussion

GouravIN's avatar
GouravIN
Brass Contributor
Jul 19, 2019

Render Piechart

Hi All,   I want to create a pie chart that can populate the count of two types VMs that has either security or critical patch missing. Like : - I have 20 VM and 15 have Critical patch missing whe...
  • CliveWatson's avatar
    CliveWatson
    Jul 22, 2019

    GouravIN 

     

    Update 
    | where TimeGenerated >= ago(1d) 
    | where (Classification == "Security Updates" or Classification == "Critical Updates") 
    | where UpdateState == "Needed"
    | extend su = iif(Classification=="Security Updates", 1,0) 
    | extend cu = iif(Classification=="Critical Updates", 1,0) 
    | summarize dcount(su), dcount(cu) by Computer
    | where dcount_cu > 1 and dcount_su > 1
    | count 

Share

Resources