In AWS quick sight tool how to create Audit report to monitor usage of published dashboard

Q&A
,
1

Dear Experts,

I require your assistance!
In the AWS QuickSight tool, how can I create an Audit Dashboard to monitor the usage of published dashboards?

The objective is to develop an Audit Dashboard that provides a detailed report of all users to track report usage and user activity, including:

  1. Who executed the Dashboard/report,
  2. Who viewed or downloaded the Dashboard/report,
  3. The most accessed Dashboards.

Thanks

Santosh Kumar

2

Hi @CoolSam

Welcome to the Quick community!

The recommended approach to track dashboard usage involves using AWS CloudTrail to capture QuickSight API events, processing them with AWS Glue, querying the data via Amazon Athena, and visualizing the results in a QuickSight dashboard. This allows you to track:

  • Who accessed or viewed specific dashboards
  • When those actions occurred
  • Which dashboards are most frequently accessed

I was able to find this community discussion where a community member noted that CloudTrail QueryDatabase events may sometimes include a queryIntent attribute with values such as EXPORT_TO_CSV or EXPORT_TO_EXCEL. While this is not officially documented, it may be worth exploring to see if it provides useful insight for your use case.

For a detailed walkthrough on setting this up, please refer to the following official AWS blog posts:

3

Dear @Xclipse,

Thanks for quick response.

I will go through the details you shared.