Auth0 app dashboards are broken

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.

Rishi Divate

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.

Sourabh Jain

June 14, 2019 06:09

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

Mark Drummond

June 14, 2019 14:59

Thanks!

June 19, 2019 17:43

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

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.

Auth0 app dashboards are broken

Top 10 Users by Successful Login

Logins by Client per Day

Comments

Didn't find what you were looking for?