Is there a possiblity to generate a report of the list of files an user had accessed in the vault for a defined time interval.
Your help is highly apprieciated.
Regards,
Bhagavan.
Is there a possiblity to generate a report of the list of files an user had accessed in the vault for a defined time interval.
Your help is highly apprieciated.
Regards,
Bhagavan.
Lee,
Many thanks for your swift response, I am getting an error : message 102 when state 15 and line 9. i tried fixing it up and was not successful. Could you kindly help me out with it please.
Regards,
Bhagavan.
Try removing the date portion of the query.
AND (Date BETWEEN {StartDateRange} AND {EndDateRange})
Run the query, and note the date format returned. Put the line back, and then input the date in the same format as in your database.
That would be my first guess.
Lee / Joy
Could you kindly help me with this ? i am still not able to run this query to generate the report on the files an user had accesssed at specified time interval.
Regards,
Bgn
Do you have access to SQL Server Management Studio? If so, on your vault databse try running the query,
SELECT TOP 10 [Date] FROM TransitionHistory
and paste here what is returned.
Lee,
As mentioned this report shows the transitions done by any given user for a specific time.
I am also looking to generate a report to see what files have been viewed / opened by a user for a specific time.
In otherwords i am actually looking generate a "User Log for specific date & time"
Kindly Help.
Cheers !
Bhagavan.
Could anybody help me with this report ?
I am looking for the list of files accessed,Opened, Edited by a particular user in the vault.
Your help is highly appreciated.
Best Regards,
Bhagavan.
The attached report displays a list of all files edited by a particular user in the vault. To create it, I modified Lee Young's report.
A list of files accessed or opened by a user is much harder to create, since the vault does not keep track of this.
First, you would need to create a database to keep track of this information.
Second, you would need to use the API to add a record to the database each time a user Gets the Latest Version of any file.
Third, you would need to create a program to run on each user's computer that regularly clears their local cache.
Step three could be eliminated under two conditions:
1. You do not care how many days a user accesses a particular file.
2. Users do not share computers.
If you wanted to know who has opened a document via a particular application, use that application's API to record the information in the database Michael mentions. Even this way wouldn't know if the user simply used EPDM's previewer.
This should get you started.