Skip to content

Instantly share code, notes, and snippets.

@PixelRobots

PixelRobots/Ingestiontime.kql Secret

Created July 21, 2019 13:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save PixelRobots/3b4c447b628ca6a2876c97adc77d205c to your computer and use it in GitHub Desktop.
Save PixelRobots/3b4c447b628ca6a2876c97adc77d205c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Ingestiontime.kql
Perf
| extend LatencyInMinutes = datetime_diff('minute', ingestion_time(), TimeGenerated)
| project TimeGenerated, ingestion_time(), LatencyInMinutes
| order by LatencyInMinutes
let startDate = ago(5h);
Perf
| where TimeGenerated > startDate
| extend LatencyInMinutes = datetime_diff('minute', ingestion_time(), TimeGenerated)
| project TimeGenerated, ingestion_time(), LatencyInMinutes
| summarize avg(LatencyInMinutes) by bin(TimeGenerated, 1h)
| render timechart
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment