Redash User Usage report Statistics

Hi Team, I’m using a self-hosted Redash on docker containers. I did some research and i added a Datasource to connect to Redash own Database in Redash UI. I can access the events table and queries table as shown in the attached screenshot.

Is it possible to get Usage report statistics for the past 6 monthsi.e. to be more precise, i want reports/queries for below 2 use-cases.

1—which user ran which queries for the past 6 months
2—which user viewed which dashboard for the past 6 months.

Keeping in mind that the events table isn’t really meant for these kinds of statistics, the two stats you mentioned should be easy enough to gather. Just query the events table for them :smiley: