Got a requirement to audit a number of document libraries in a solution of mine.
Basically need to log all CRUD operations on a file within a document library to a SQL Server database and use an external list to pull data back into SharePoint for BI usuage.
The OOTB auditing feature doesn't cover the requirements so I have a couple of options:
Investigate usage and analysis logs to see if I can extract data from them, again I suspect these won't cover it. Plus how to I hook into the data, not investigated this before?
Use a custom HTTP module to intercept the request and check for files etc being open then log to database.
I can't use event receivers because there is no read event on a file, or is there something I don't know here.
Can't use a workflow because again it can only be triggered through updates and additions.
So wanted to ask you guys if there is a better solution before I dive into the second option above.