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.
Hi Raghavendra,
The issue might be that your date format is different. Follow the directions provided by Lee to see what you date format is and modify your input to the query accordingly.
Regards,
Joy
Hi Raghavendra -
Attached is a zip file containiing the report supplied by Lee (just to rule out typos and such).
Joy
This report is an example of how you could see when a file changes state.
You could tweak it to show you whenever someone checks in/out a document.
It isn't going to be able to show you whenever someone opens or looks at a document.
Raghavendra,
Try the attached report.
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.
@[FilesUserAccessed] §Name [Listing of files specified user accessed between provided date range.] §Company [Lee C.S. Young] §Description [This query will list files the specified user performed a state change during a provided date range.] §Version [1.0] §Arguments [ UserID TheUserID[N] [Select user] String StartDateRange [1] [Enter begining date range, format 'yyyy-mm-dd'.] String EndDateRange [1] [Enter end date range, format 'yyyy-mm-dd'.] ] §Sql [ SELECT DISTINCT D.Filename ,[Date] ,u.Username ,t.[Name] FROM [TransitionHistory] th JOIN Users u ON th.UserID = u.UserID JOIN Documents D ON D.DocumentID = th.DocumentID JOIN dbo.Transitions t ON t.TransitionID = th.TransitionID WHERE u.UserID = {TheUserID} AND (Date BETWEEN {StartDateRange} AND {EndDateRange}) ORDER BY th.Date DESC ]