I have queried the COGIPF_RUNREPORT table to view entries for dashboards.
What I found was that just opening a dashboard generates several rows of entries, all with different COGIPF_REQUESTID and COGIPF_LOCALTIMESTAMP values.
Depending on the number of tabs and filters etc., in a dashboard, you get multiple rows generated. The number of rows generated on opening is different for each dashboard.
I cannot see any attributes that will allow me to group these rows together in order to determine a single opening of a dashboard.
i.e., If I open and close a dashboard several times, with in a short time span, I cannot see any way to determine how many time the dashboard was opened?
e.g., I opened and closed a dashboard 3 times without any other actions and 30 rows were generated.
Does anyone have a sample of a query that captures each time a dashboard has been opened by a user?
Thanks
where can i find this data if i look in the table i see all the reports but i dont see the dashboards and auditing of these dashboards