Share via

Kusto Temporary table

  • Article

Question

Thursday, September 5, 2019 4:46 PM

The business rule is:

As a tech, I want to query device crashes by installed capita for machine that have software installed on 2,000 or more so that I can find incompatible top 7 app crashes sorted by total machines.

I need to join the UAApp table for MonthlyActiveComputers > 0. I also need to have a distinct count of DHAppReliability HasCrashesDaily == true.

I cannot join these tables due to the volume of records in UAApp. I need to use a temporary table to store the AppNames found in DHAppReliablility that match the AppNames in UAApp so I can filter UAApp.

All replies (1)

Tuesday, September 10, 2019 10:27 AM

You can use let statement in order to store the temporary tables. Here is the link that will help you in understanding how to use let statement.

Hope this helps!