Intro

This application was created to export audit events from multiple site collections to an external database . The application is managed from the app.config file. 

The application can be executed multiple times. If the event already has been saved to the database then the event is skipped.



App.config

Key Value ex Explanation
Site http://site
(string)
The base URL of the web application. Multiple paths can be added separated by ; The application will iterate all site collections in the site.
EventTypesToSave delete
(string)
Add multiple eventtypes to save into database by separating them with ;. Only use small letters. A list of all the Eventtypes can be found below.
ClearAuditHistory True/False
(Boolean)
If set to true then all the events in the Audithistory are deleted.

 

AuditLog values

All (not implemented)
none
checkout,
checkin,
view,
delete,
update,
profilechange,
childdelete,
schemachange,
securitychange,
undelete,
workflow,
copy,
move,
search

 

 Database

The database and stored procedure can be created using the script below. Database is MS SQL.

DatabaseScript.txt

Last edited Aug 24, 2014 at 9:32 PM by TomasN, version 2