11-26-2009 03:59 AM
Solved! Go to Solution.
11-26-2009 06:25 AM
11-26-2009 04:19 AM
11-26-2009 05:22 AM
11-26-2009 06:25 AM
11-27-2009 03:07 AM
Hi Wayne
Thats very good of you, any help if you can spare would be appreciated. I have enclosed a screenshot of of Auditviewer utility and a sample of the SQL table.
The audit viewer displays audit log informatin from the database, and although most of the field heading are obvious, I am not sure how to interpret "Object ID" or "Archive". I assume they are stored somewhere in SQL.
Although we can see what user id has search, when and what directory, it doesn't easily identify the document name directely. The audit database in SQL contains this information, however it is even less readable. ie userID=1 refers to a specific A.D account. This make it difficult to export in a meaningful format for managers.
I have enclosed an excel file with a sample export from SQL.
Essentially we are looking to perform adhoc queries to identify the follow.
Who has searched for a document and when, including the docuMent path and name.
Who has opened a document and when, including the docuMent path and name.
Who has searched for a document and when, including the docuMent path and name.
Hopefully this makes sense.
Regards
Nick Thompson
I cant seem to find an option to attach a file with the sample audit log in excel format.