Count the number of times a user viewed a file on Content Server

Shai Abadi

I'm using the CS database in order to get some reports about user activity.

Examples :

Number of login and logouts of a user. Number of documents created by a specific user etc...

I'm using the DAuditNewCore table to get that info.

Unfortunately I didn't manage to get the number of times a user viewed / read a file.

There is an audit which called "View" but it's not representing the actual action.

Any ideas?

Thanks.

Appu Nair

Download ,Open, View ,Fetch (select distinct(auditstr) from DAuditnew can be used to see how many events are in your CS and add anything that you think is useful).When someone is seeing the content of a file depending on the htmlviewer the view is registered but if they use brava another event may show up. The adminster event auditing page sometimes has a descriptive name for the available ones

I don't fully know what happens when smartui opens a file you might trap that event and come up with some meaningful way.