Find who are using which dashboard and when?

[Devi16]

Hi Friends,

we would like to know below things please help me on it.

We have so many dashboards, so our management wanted to know that, which dashboard using by (not owned by) which user, if possible when, and how many times etc etc.. if it is not possible, at least we would like to know which report run by which user and when, if possible count of run. 

Because unnecessary dashboards we wanted to deactivate them.  

Thanks in advance.

[Devi16]

Thanks for sharing it, its not totally given the solution but some information I have found for my case. is there any table i could find the reports executed through which dashboard and by whom and when etc...

[Adam Stout]

Reports are not tracked per user/view.

[Community Alums]

As you probably know that a dashboard can consist of one or multiple reports/ widgets. So if you go with Adam's solution, you should be able to retrieve the dashboard usage directly. But not the interaction the user has with the report in the dashboard which is in read-mode only

However, if you want to know report usage which could mean either of the below

1) User goes to Reports>View/run> and opens a report

2) OR user tries to edit the report from the dashboard view.

The above interactions are stored in sys_ui_navigator_history table. While the data is here, it is protected by ACLs which restricts the viewing to the admin role and the user who for whom the history is for.  The Navigator History included the URL that was viewed which does contain the sys_id of the dashboard, but not in a reportable form.  You can use the below filters on the table.

You can customize Adam's solution to build something similar for report usage.

Please mark this answer as helpful or mark as correct as you deem fit.

[Devi16]

Actually I went to this table "pa_m2m_dashboard_tabs" in table we have to give dashboard name so it will give the reports in "summery" column under that dashboard, after that I used report execution and report stats table further analysis. 

Thanks you all for sharing helpful information.