Ideas, Tips, Tools, Framework for implementing Audit

Question

I'm looking for Ideas, Tips, Existing Frameworks (based on .NET), Tools and also your experience on what's the best way to implement a good Audit Trail.

Our typical Applications are nothing fancy ASP.NET MVC 3- Security Layer - Business Layer - Data Access Layer - Database (SQL Server 2008)

My only requirement is that it has to be easy to implement and stored somehow in the Database.

Try [Audit.NET](https://github.com/thepirat000/Audit.NET) and its [extensions](https://github.com/thepirat000/Audit.NET#extensions) — thepirat000, Nov 09 '18 at 02:33

score 2 · Answer 1 · answered Feb 02 '11 at 10:20

2

For auditing user actions, I had used Log4Net. While for auditing CRUD operations, triggers were used.

Here you could find some resource articles(Article1, Article2) on implementing Audit log.

answered Feb 02 '11 at 10:20

AbrahamJP

3,425
7
30
39

Triggers are not so easy to maintain in my opinion. – gsharp Feb 02 '11 at 12:10

score 0 · Accepted Answer · answered Feb 13 '11 at 07:31

0

I've found some nice tools like OmniAudit etc, but not actually exactly was i was looking for. So i've decided to write my own Audit Trail Tool to generate and maintain Triggers.

answered Feb 13 '11 at 07:31

gsharp

27,557
22
88
134

score 0 · Answer 3 · answered Mar 10 '11 at 09:53

0

if you're using entity framework, please refer to: http://www.codeproject.com/KB/database/ImplAudingTrailUsingEFP1.aspx

answered Mar 10 '11 at 09:53

John Cai

16
1

Ideas, Tips, Tools, Framework for implementing Audit

3 Answers3