Skip to content

Instantly share code, notes, and snippets.

@flinox

flinox/requests-by-api-by-time.kql

Last active March 21, 2024 13:47
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 flinox/f440f3e0a3bad631beec5501d3c1243c to your computer and use it in GitHub Desktop.
Save flinox/f440f3e0a3bad631beec5501d3c1243c to your computer and use it in GitHub Desktop.
Download ZIP
KQL - Filtrar Requests por API Name em um intervalo de tempo especifico (UTC to Local)
Raw
requests-by-api-by-time.kql
requests
| extend timestampSP = datetime_utc_to_local(timestamp,'America/Sao_Paulo')
| where timestampSP > datetime("2024-03-20T20:00:00.000Z") and timestampSP < datetime("2024-03-21T09:00:00.000Z")
| summarize TotalRequests = count() by tostring(customDimensions["API Name"])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment