Skip to content

Instantly share code, notes, and snippets.

@marcduiker

marcduiker/FunctionExceptions.sql

Created May 1, 2019 08:28
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 marcduiker/d7dc7573eedbad4535a92b7ba126f07f to your computer and use it in GitHub Desktop.
Save marcduiker/d7dc7573eedbad4535a92b7ba126f07f to your computer and use it in GitHub Desktop.
Download ZIP
Log Analytics query to get the latest 100 exceptions for a given FUNCTION_NAME in FUNCTION_APP_NAME.
Raw
FunctionExceptions.sql
requests | project timestamp, id, operation_Id, operation_Name, success, resultCode, duration, cloud_RoleName | join kind=inner (exceptions | project operation_Id, message, outerMessage, innermostMessage) on operation_Id | where cloud_RoleName =~ '<FUNCTION_APP_NAME>' and operation_Name == '<FUNCTION_NAME>' | order by timestamp desc | take 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment