Querying Logs

Nitro admins can access internal action logs for Explorer to gather usage data, including how frequently users access Explorer, most popular dashboards, and other, similar usage insights.

To query Explorer action logs:

  1. Log into the SQL Editor with admin credentials.

  2. Select the logs Explorer Database displayed.

  3. Select the schema displayed. There should only be one schema in the database corresponding to the Nitro Explorer you logged into.

  4. Run a query on logs table.

Nitro admins can query the logs database using SQL Lab to see a list of users and their attributes, for example, first name, last name, email, and login events:, last login time, login count, and failed login count.

To query the logs database, run the following query on the ab_user table:

SELECT id, first_name, last_name, active, email, last_login, login_count, fail_login_count FROM ab_user