Skip to content

Instantly share code, notes, and snippets.

@flinox

flinox/operation-used-on-api-by-time.kql

Created March 21, 2024 13:18
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/ff978e86a9aa7ff32eac81be245bb70b to your computer and use it in GitHub Desktop.
Save flinox/ff978e86a9aa7ff32eac81be245bb70b to your computer and use it in GitHub Desktop.
Download ZIP
KQL - Operações da API usadas em um intervalo de tempo
Raw
operation-used-on-api-by-time.kql
requests
| extend timestampSP = datetime_utc_to_local(timestamp,'America/Sao_Paulo')
| where timestampSP > datetime("2024-03-19T20:00:00.000Z") and timestampSP < datetime("2024-03-20T10:00:00.000Z")
| where customDimensions["API Name"] == "<api-name>"
| distinct tostring(customDimensions["Operation Name"])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment