how to find out last viewed details of dashboards through sql or api

satya October 24, 2024

hi Atlassian community

i have stuck in one place that is i could not find out viewed details of dashboards through sql or api, if there any option available in Atlassian jira

Thnx in advance

2 answers

2 votes
Mikel Garcia Bartolome
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 24, 2024

In Jira, unfortunately, there isn’t a straightforward way to query dashboard views directly using Jira's native SQL or REST API. Jira doesn’t track view counts for dashboards by default, so it doesn't expose any API or database table that logs dashboard view details out of the box.

However, here are a few potential workarounds you might consider:

  1. Jira Plugins: There are a few marketplace apps, such as Dashboard Hub for Jira and eazyBI Reports and Charts, that provide enhanced reporting and dashboard usage analytics. Some of these might include dashboard view analytics as a feature, so they could be worth exploring if you want detailed usage statistics.
  2. Use Google Analytics or a similar tool: If you're on a hosted Jira instance and have access to the server side, you could embed Google Analytics tracking code into the dashboard HTML (if you have customization permissions). This approach would allow you to track page views on specific dashboards, similar to how you'd track views on a website.

  3. Browser Extension: You could use a browser extension (like Tampermonkey) to log page views to a server whenever you or another user access a dashboard. The extension can make API calls or log entries to an external tracking tool to keep track of dashboard views.

  4. Custom Logging on Server: If you’re using a self-hosted Jira (Jira Server or Data Center), you could set up custom logging on your web server to track accesses to dashboard URLs. You’d need to parse the logs later to gather view counts by dashboard.

satya October 26, 2024

Thanks for reply @ Mikel Garcia Bartolome.

0 votes
Mikel Garcia Bartolome
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 25, 2024

Hope it helps

Suggest an answer

Log in or Sign up to answer