Forum Discussion

gcongrove's avatar
gcongrove
Copper Contributor
Oct 23, 2019
Solved

Kusto Query help

Here are two separate Kusto queries that provide

DriverName, Driver Version, Total_Crashes

And

DriverName, Driver Version, Total_Installs

 

I can’t figure out how to combine this into one query that results in

DriverName, Driver Version, Total_Crashes, Total_Installs

 

 

DHDriverReliability

| summarize Total_Installs=count() by DriverName, DriverVersion

 

DHDriverReliability

| summarize Total_Crashes=sum(DriverKernelModeCrashCount) by DriverName, DriverVersion

  • Try this:

    DHDriverReliability
    | summarize Total_Crashes=sum(DriverKernelModeCrashCount), Total_Installs=count() by DriverName, DriverVersion

2 Replies

  • Try this:

    DHDriverReliability
    | summarize Total_Crashes=sum(DriverKernelModeCrashCount), Total_Installs=count() by DriverName, DriverVersion
    • gcongrove's avatar
      gcongrove
      Copper Contributor

      Yoni this is exactly what I needed.  I knew it would be simple, but I just couldn't get it worked out right. 
      Thank you