Usage Stats

[ShortyA]

Hi there,
is it possible to report on the usage of Crystal Enterprise, eg userids, reports opened etc ?


Thanks very much - Alec

 

[RoughingIT]

Not very easily, I suppose. That information is not stored anywhere, so you would have to trap it. Everytime someone requests a report or logs in a URL string is passed to the webserver. If you find a way of trapping those calls and then digging out the information...
Unless of course you can use a custom frontend in asp or csp. Then it should be possible to keep track of what your users request...

 

[ShortyA]

Thanks for the info. I will see if I can grab the info when the URL is passed through.

Cheers,
Alec

 

[kwarner]

We have had some luck using Microsoft Site Server Analysis reports to gather information on what our Crystal Enterprise users are viewing. I can't tell which specific reports have been opened, but I know by directory. From what I can tell, the ActiveX Viewer file, viewrpt.cwr, logs a request everytime it is opened or refreshed. Of course you do have to set up the log files to track this information.

I have also thought about setting something up similar to what Roughing IT suggested...trapping logon information and storing it in a database.

Good luck,

Kent

kwarner
tdcs2000@davesworld.net

 

[synapsevampire]

Kent: You can get lots more info. from the logs if you expand your IIS logging to include extended properties.

as in:
URi Stem
Uri Query
etc.

For instance you can get:

User
IP
Server
Time
Which report (the ID, you can derive the name)

Here's a record from it, I've separated some of the text for readability:

2002-06-20
23:03:17
XXX.XX.19.80 (I masked this IP manually for obvious reasons)
- W3SVC1
KAI01
POST
/crystal/enterprise/ePortfolio/en/viewrpt.cwr
id=2414&cmd=get_ttl&viewer=actx&vfmt=encp&ttl_info=&PVERSION=3 200 0 60
Mozilla/4.0+(compatible;+MSIE+5.5;+Windows+NT+5.0)
Admin_logonForm_usr=nuasis;+Admin_logonForm_auth=Enterprise;+database_lastaps=KAI01;+database_lastaut=secEnterprise;+database_lastusr=Administrator;+ePortfolio_lastaut=secEnterprise;+ePortfolio_lastusr=nuasis;+developer_samples_app_lastaps=KAI01;+developer_samples_app_lastaut=secEnterprise;+developer_samples_app_lastusr=nuasis+reports+administrator;+WCSID=102461355678-2886734672:6401;+ePortfolio_logontoken=KAI01%402559JQ%3A%27R%3DAa%60MnXw.f%26;+ePortfolio_prefs=view%3D175%26vwm%3D0%26dv0%3D1%26dv1%3D1%26dv2%3D1%26dv3%3D1%26dv4%3D1%26csn%3D3%26cbr%3D0%26vwr%3D0%26list%3D1%26rpp%3D30%26menu%3D0%26zone%3D0;+VIEWINGCOOKIE=RCOOKIE%3D2414%26apstoken%3DKAI01%25402559JQ%253A%2527R%253DAa%2560MnXw.f%2526%26PSCOOKIE%3DCServerCookie%253FId%253D2886734672102461419627011701433%2526Flg%253D0%2526TId%253D2886734672102461419727013178554%2526CTCS%253D1024352753000%2526DATA%253D2886734672102461419827013221655%26promptonrefresh%3D1

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[ShortyA]

Thanks folks. Looks like I will be able to get some stats off it without buying DocAssist.
Cheers - Alec

 

[mblampe]

We make a copy of the Crystal Info database each night and then run a report from the copy of the database. We are using Seagate Info 7, and I am not familiar with the database structure of Enterprise, but some of the tables are CI_GRPUSERS, CI_GRPINFO, CI_USERS, CI_RUNTIMEIMAGE (has report run times)