Can I see when reports are being run?

[Former Member]

I have some parameters based reports for users. Looking to see if they are being used or not. Because have to do a version change and want to do the ones in use first. I know with scheduled you can see the history but is there such a way to see the other reports when they are running?

[abhilash_kumar · Accepted solution]

Hi Paul,

Yes you can, using Query Builder.

Please have a look at these blogs for more info:

-Abhilash

[DellSC · Accepted solution]

However, QueryBuilder will not get you to information about whether a report is being viewed interactively - it will only show you the last time the report was updated or scheduled.

To get to information about the most recent "view" of a report you need to run a query against the audit database.  If you're using BI 4.x, that query might look like this:

Select

  User_Name,

  Object_ID,

  Object_Name,

  Object_Folder_Path,

  MAX(Start_Time) most_recent

from ADS_EVENT

where Event_Type_ID = 1002

group by

  User_Name,

  Object_ID,

  Object_Name,

  Object_Folder_Path

Note:  Object_Folder_Path will only have a value if you've set auditing to include the folder path.

-Dell

Message was edited by: Dell Stinnett-Christy

[Former Member · Accepted solution]

Dell, I got an error running this query.   There was an error retrieving data from the server: Not a valid query. (FWB 00025)

but this one does run. SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND = 'CrystalReport'

maybe we are not on B/O 4

[DellSC · Accepted solution]

You're not going to run this in QueryBuilder!  This is not a CMS query, it is a query against the Audit database.

If you're on version 4.x, you will have an "Auditing" option in the CMC.  You can go there to find out where your audit database is.  If you're on MS SQL Server, you can use SQL Server Management Studio (or any other query tool) to run this query.  If you're on Oracle you can use SQL*Plus, Toad, etc.

-Dell