-
Re: Generating Report for the files accessed by a user
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 ]-
Re: Generating Report for the files accessed by a user
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.
-
Re: Generating Report for the files accessed by a user
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.
-
Re: Generating Report for the files accessed by a user
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
-
Re: Generating Report for the files accessed by a user
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.
-
Re: Generating Report for the files accessed by a user
Joy Garon
Dec 1, 2009 8:30 AM
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
-
-
Re: Generating Report for the files accessed by a user
Joy Garon
Dec 1, 2009 9:04 AM
Hi Raghavendra -
Attached is a zip file containiing the report supplied by Lee (just to rule out typos and such).
Joy
-
Re: Generating Report for the files accessed by a user
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.
-
-
Re: Generating Report for the files accessed by a user
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.
-
-
-
-
-
-
Re: Generating Report for the files accessed by a user
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.
-
Re: Generating Report for the files accessed by a user
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.
-
Re: Generating Report for the files accessed by a user
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.
-
-