Allen Browne's Audit Log

[raja07]

Hello Everyone,
I'm about to try Allen's Audit Log because I've read so many positive
feedback about it. I'm just wondering before I get started if anyone who's
tried it can answer this question--

My table that's going to be edited contains 200 fields...does the audit log
only log the field(s) that was edited? and will the other fields (unedited)
contain nulls? My manager wants a weekly report of only changes...not the
entire record(s)
Appreciate any feedback!

Thanks,
raj

 

[Rick A.B.]

Hello Everyone,
I'm about to try Allen's Audit Log because I've read so many positive
feedback about it. I'm just wondering before I get started if anyone who's
tried it can answer this question--

My table that's going to be edited contains 200 fields...does the audit log
only log the field(s) that was edited? and will the other fields (unedited)
contain nulls? My manager wants a weekly report of only changes...not the
entire record(s)
Appreciate any feedback!

Thanks,
raj

raj
It logs all the fields. If a record is changed it will log two
records Edit From and Edit to. If a record is inserted or deleted it
will log one record.

Hope that helps
Rick

 

[raja07]

Oh bummer now i have to figure out how to easily tag just the fields that
were changed...back to the drawing board.

Rick thanks for getting back to me, appreciate it