Auth0 app dashboards are broken

Follow

Mark Drummond

• June 06, 2019 23:02

The queries behind at least some of the default dashboard panels in the Auth0 app are pretty broken. Two examples (there are more):

Top 10 Users by Successful Login

_sourceCategory = my/auth0/logs 
| json "type", "user_name" 
| where type matches "s*" 
| where !isEmpty(user_name) 
| count user_name 
| top 10 user_name by _count

This query includes all log event types** that start with an "s", which includes "ssa" silent login events (user is issued a new auth token behind the scenes, not actually a "login"), and "slo" events which are successful logouts!

**every log entry has an associated type, made up of a 1-4 (1-5?) character string. The various types are documented here: https://auth0.com/docs/logs

Logins by Client per Day

_sourceCategory = my/auth0/logs 
| json "client_name" 
| where client_name matches "*" 
| timeslice by 1d 
| count by _timeslice, client_name 
| transpose row _timeslice column client_name

This isn't filtering on login events at all! It is capturing all log events by client.

0

• 

  Rishi

  • June 08, 2019 00:39
  • Edited

  Hi Mark, 

  Thanks so much for highlighting this. We are reviewing these items and other panels and one of us will get back to you. 

   

  Rishi.  

  1

  Comment actions Permalink
• 

  Sourabh Jain

  • June 14, 2019 06:09

  Hi Mark,

  We have made the changes to all the affected queries. Criteria for the Type field has been narrowed to select only the particular events. 

  App with the modified changes will be available in the App Catalog Latest by Monday.

   

  Sourabh

  1

  Comment actions Permalink
• 

  Mark Drummond

  • June 14, 2019 14:59

  Thanks!

  0

  Comment actions Permalink
• 

  Sourabh Jain

  • June 19, 2019 17:43

  Hi Mark,

  Changes have been moved to production. It will helpful if you can review the changes and provide the feedback for the changes done.

   

  Sourabh

  1

  Comment actions Permalink
• 

  Mark Drummond

  • June 19, 2019 19:47

  Hello Sourabh. I haven't gone through all the panels in detail, but the ones I had a look at look good to me. Thanks for fixing this up.

  0

  Comment actions Permalink

Please sign in to leave a comment.