Application and user activities logging

[sharath]

Hello,

I would like to know, where is the application and user activities will be logged in metabase.
I want to know, which user logged in and what activities he/she did in metabase.

We have configured metabase using the java jar file deployed in nginx server.

Let me know for any other details required.

[nmg]

The (metabase) application database depends on your setup; if you've only deployed the java file and nothing else then you should find the application database in the same directory as the java file; I guess you'll just need to configure a driver for accessing the file via your preferred method / query tool.

For the activity queries, once you've accessed your application database, maybe start with this:

Metabase Metadata SQL

Metabase is lacking in some of the management information I’d like to see. Hopefully the queries below will help a few others build up a management dashboard too. In summary: List of Dashboards List of Questions List of Questions in each Dashboard List of Questions not in any Dashboard List of Users LIst of Users who have never logged in List of Dashboards viewed by each user and count of views Pretty much anything else you can dream up /* All dashboards */ SELECT rd.id, rd.name, rd.descript…