Crystal Enterprise Server 1

[rp61]

Hi Folks,
Is there some way I can track the hits on the various reports on Crystal Enterprise Server. For scalability purposes, we are trying to monitor which reports are getting the most hits and the times these hits occur.

Thanks
RP

 

[Turkbear]

Hi,
From what I have read, CE 10 has this functionality included..
Prior to that you would need to use some code ( on our pages ( which are all custom), we have a hidden asp page that submits the info to an Oracle database whenever the user runs a report).
You can, with some effort, use the IIS ( assuming that web server) log files to see what is happening..

 

[MJRBIM]

Auditing is a new function in CE-10, it runs a table called CMS_AUDITTABLE that can track all of the things that you are looking for...and you can write Crystal Reports against the contents of that table.

The only downside is that you have to turn on auditing for each individual ReportObject when they are published. I have not yet found a way to set this as a DEFAULT setting for all new ReportObjects.

 

[rp61]

Sorry Folks, I forgot to mention I am currently using CE 9.

Thanks Again
RP

 

[wbbusby]

The auditing in version 10 only tracks the viewing of Crystal Reports and running programs (*.js). It can't track a user who accesses URL, Excel, Adobe, text, Word, etc. objects. If your environment is mostly Crystal Reports you'll love it. In my case, with a lot of legacy URL report links, I'm disappointed. BTW audting isn't turned on per object as they're published. It's enabled in the CMS for types of actions (i.e., log on/off, folder create/change, report viewing/scheduling/failing, etc.)

 

[MJRBIM]

Auditing is set at the server level, but if you want to audit the instances of a ReportObject you have to turn it on for each ReportObject on the Schedule --> Notification tab in the CMC.

- - - - - - - - - - - - - - - - - - - -
EXAMPLE
- - - - - - - - - - - - - - - - - - - -

Set notification

When scheduling the object, you can choose whether or not to enable audit, and email notifications.


Audit Notification: Enabled

Audit when:

[ ] A job has been run successfully.


[ ] A job has failed to run.

- - - - - - - - - - - - - - - - - - - -

You have to check those boxes for each Object.