Azure Logs Tricks

Azure Logs tricks are a set of useful scripts written in Kusto Query Language (KQL) to query the Azure log databases. Scripts are grouped into folders based on the specific functionality and table name in Azure Logs:

• requests
  • calculate the total number of different / long or specific requests count and with average duration within a custom time range or for the last 24 hours by default and present results in table / chart view;
  • get the top 10 failed requests;
  • get the amount of requests from the top 10 countries;
  • get the request count trend within a custom time range;
  • get the response time trend within a custom time range;
  • get the failed requests and calculate a number of impacted users within a custom time range;
• sessions
  • get the number of the distinct sessions hourly;
• pageViews
  • get top 10 slowest pages within a custom time range in table / chart view;
  • get the page views trend within a custom time range;
• exceptions
  • get the exceptions causing failures within a custom time range;
• dependencies
  • get the top 10 failing dependencies within a custom time range;
• performanceCounters
  • get the max number of requests a second for the last 24 hours to apps / within a custom time range;
  • get the number of requests in an application queue hourly for the last 24 hours / for the last hour with 15 minute breakdown;
  • get the processor time usage hourly for the last 24 hours / for the last hour with 15 minute breakdown;
  • get the average processor time usage every 15 minutes within the last hour;
  • get the number of exceptions for the last hour with 15 minute breakdown;
  • produce the request execution time chart for the last 24 hours / a custom time range with a minute step;
  • get the process IO rate for a custom time range in chart view;
  • get the process private bytes for a custom time range in chart view;
  • get the process CPU consumption for a custom time range in chart view;
• traces
  • get the count of trace statements logged with the TrackTrace() Application Insights API call hourly;
• users
  • get the number of visitors hourly;

Contribution

Hope you found these KQL scripts helpful, your contributions and suggestions will be very much appreciated. Please submit a pull request.

License

Azure Logs tricks are released under the MIT license what means that you can modify and use scripts how you want even for commercial use. Please give this repository a star if you like any of KQL queries and your experience was positive.