SOLVED

Kusto Query help

Copper Contributor

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

2 Replies
best response confirmed by gcongrove (Copper Contributor)
Solution
Try this:

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

@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

1 best response

Accepted Solutions
best response confirmed by gcongrove (Copper Contributor)
Solution
Try this:

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

View solution in original post