If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Auditing dashboard usage by date and user

Started by Spyhop, 07 Oct 2020 05:55:43 PM

Previous topic - Next topic

Spyhop

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

bartburg

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