steampipe plugin install auth0

Table: auth0_stats_daily - Query Auth0 Daily Statistics using SQL

Auth0 is an identity management platform for application builders and developers. It provides a universal authentication & authorization platform for web, mobile and legacy applications that focus on identity types like SSO, MFA, user management, and more. Auth0 is designed to make it easy for developers to manage user identities and create secure, seamless experiences for their users.

Table Usage Guide

The auth0_stats_daily table provides insights into daily statistics within Auth0 Identity Management. As a security analyst, explore daily log event details through this table, including log event count, log event types, and associated metadata. Utilize it to uncover information about application usage patterns, such as peak usage times, most frequently used features, and potential security incidents.

Examples

Top 5 days with the highest number of sign-ups

Discover the dates that had the most user sign-ups, which can be useful for identifying trends or the impact of specific marketing campaigns.

select
sign_ups,
date
from
auth0_stats_daily
order by
sign_ups desc
limit
5;
select
sign_ups,
date
from
auth0_stats_daily
order by
sign_ups desc
limit
5;

Last 12 months average number of logins

Explore the average frequency of user logins over the past year to understand user engagement and activity trends. This can help in identifying patterns and informing strategies for user retention and engagement.

select
avg(logins) as average_logins
from
auth0_stats_daily
where
date > current_date - interval '12' month;
select
avg(logins) as average_logins
from
auth0_stats_daily
where
date > date('now', '-12 month');

Days when the passwords were leaked

Identify instances where passwords have been compromised, allowing you to understand the severity and frequency of such security incidents.

select
leaked_passwords,
date
from
auth0_stats_daily
where
leaked_passwords != 0
order by
leaked_passwords desc;
select
leaked_passwords,
date
from
auth0_stats_daily
where
leaked_passwords != 0
order by
leaked_passwords desc;

Schema for auth0_stats_daily

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
created_attimestamp with time zoneTimestamp of when the stat started to count.
datetimestamp with time zone>, >=, =, <, <=Date of the stats.
domain_nametext=, !=, ~~, ~~*, !~~, !~~*The name of the domain.
leaked_passwordsbigintNumber of leaked passwords.
loginsbigintNumber of logins.
sign_upsbigintNumber of sign ups.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
updated_attimestamp with time zoneTimestamp of the last update to stat of the day.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- auth0

You can pass the configuration to the command with the --config argument:

steampipe_export_auth0 --config '<your_config>' auth0_stats_daily