Looking for a Livelink Report that gives the stats on how many times a Folder is accessed...

Terry_O'Reilly_(citimmadmin_-_(deleted))

Does anyone have a Livelink report that can show how many times a folder has been accessed in a given time frame? Is there a way to get a count of how many people have logged in to Livelink in a given time frame that displays numbers not names, and it removes duplicates? I know I can view the audit trail of the gif. attached to the customview on the Enterprise WS for the names.

Find more posts tagged with

Comments

Dave_Ebels_(jocoadmin_-_(deleted))

As far as I know there is not a good way of knowing how many hits happen to a folder. I do however have two livereports that I use to record the number of hits to documents in folders.The first I call 'Number of hits' The SQL is ,,,,select count(*)"number of hits" from daudit where (EVENT='VIEW' or EVENT='FETCH') and dataid in (select dataid from dtree start with dataid in(%1) connect by prior dataid=parentid)Make it an auto livereport, check 'show prompt', in the inputs section, include an input of type 'number', with a prompt like 'Enter Object ID'. Param %1 is 'User input 1'. And you are ready to go. This returns a total number of hits for the contents of a folder, and its sub folders.The second report I use goes a bit further. I call it 'Number of hits expanded'. the SQL is ,,,,,select name, count(*) "number of hits" from daudit,kuaf where userid=id and (EVENT='VIEW' or EVENT='FETCH') and dataid in (select dataid from dtree start with dataid in (%1) connect by prior dataid=parentid) group by name order by count(*)descSet this one up exactly the same as the first one with the addition of setting the record limit to something large, I use 10000. This report returns hits by users, identifying the user by their user ID, and it's very useful! Good luck!

OSHA_ICT_team_member_1_(oshauser1_-_(deleted))

This will be very useful for many of us, thanks for your sharing Dave. I also think it's now time for Opentext to *seriously* think in providing default livereport to adress such statistics needs (I even don't undestand why and how they didn't do so until now !) Best Regards from SpainLila

Paul_O'Hagan_(pohagan_(Delete)_2164647)

Hi Lila,Long time no talk! I hope all is well with you.With LL9.2.0 we have put the formerly optional module called the Recommender into core product. One of the features of this module is that it tracks all user interaction with the system, including fetches, views, etc. on all objects. The data you're asking about is stored in a table called "Recd_OperationSummary" and the relevant column is "refCount." This information is of course available through LiveReports.Today the Recommender only exposes hit counts on objects of document type (that which you can explicitely rate). As you can see, we do store this data for all object types and are planning on working to expose more of it in the future.If you or anyone else would like more information on this, please feel free to contact me directly.Hope it helps!Paul O'Haganpohagan@opentext.com519-888-7111 x2632