I've recently undergone training in SQL reporting services with the idea being that I would be leading our conversion from Crystal reports (Enterprise 10) to SQL Reporting services. There are 103 Crystal reports on our system however few of us are aware of the usage of these reports, almost all of them except a couple predate our current IT personal. A handful we know are used by everybody, a chunk we are sure aren't used and the rest we have no idea, some might only get used once a month, others daily by only one person in the organization.
Ideally I would like to find a way to see the hit counts on some of these reports. I already attempted to look at the IIS logs using LogParser but realized that the individual reports aren't stored as separate files but as a single page that generates the report so I have one page with a few thousand hits. I also looked at the administrative console of crystal however the last run field is completely out of whack, many reports have it as either an odd date or blank and these are reports I helped a user run yesterday so I can't consider it as reliable.
Is there a way or a particular log location of some kind that could show me how often a report is accessed over some period?
Best Answer
It's a while since I've touched Crystal Enterprise (and then, I was using Crystal Analysis Pro rather than Crystal Reports), but from what I remember, the "info object id" is on the URL to the csp page that represents the viewer - you could see if they're in your logs? each info object id represents a single report (or saved view) - with a little effort and poking around with the COM libraries that get installed when you install the CE addons to CR, you can actually pull back the actual report file from the CE infostore.
EDIT: Thinking about it, you could modify the CSP page to add some logging code -- they're effectively ASP pages with a few extra bells and whistles. The CSP pages did get compiled into CWRs, but I forget if that was CE11 or 10...