Tuesday 12 January 2021

Simple Kusto Queries for beginners ?



1. Sample kusto query to extract last 24 hours logs.


AzureDiagnostics 
| where TimeGenerated > ago(24h)


2. Using below kusto query you can extract logs between any two datetimes. 

 AzureDiagnostics  
| where TimeGenerated between (datetime(2021-01-12 10:30:00) .. datetime(2021-01-12 11:30:00))



3. This is sample kusto query to search particular keywords on any column. Below query is to search all the records from Diagnostics table where backendUrl_s contains a giving string


AzureDiagnostics 
| where backendUrl_s contains "SomeString"


No comments:

Post a Comment