Redash User Usage report Statistics

Support Self Hosted Redash Support
,
1

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.

image
image879×1200 55 KB

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.

2

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: