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, datefrom auth0_stats_dailyorder by sign_ups desclimit 5;
select sign_ups, datefrom auth0_stats_dailyorder by sign_ups desclimit 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_loginsfrom auth0_stats_dailywhere date > current_date - interval '12' month;
select avg(logins) as average_loginsfrom auth0_stats_dailywhere 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, datefrom auth0_stats_dailywhere leaked_passwords != 0order by leaked_passwords desc;
select leaked_passwords, datefrom auth0_stats_dailywhere leaked_passwords != 0order by leaked_passwords desc;
Schema for auth0_stats_daily
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
created_at | timestamp with time zone | Timestamp of when the stat started to count. | |
date | timestamp with time zone | >, >=, =, <, <= | Date of the stats. |
domain_name | text | =, !=, ~~, ~~*, !~~, !~~* | The name of the domain. |
leaked_passwords | bigint | Number of leaked passwords. | |
logins | bigint | Number of logins. | |
sign_ups | bigint | Number of sign ups. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
updated_at | timestamp with time zone | Timestamp 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