No but I have built my own log files for some of the tables in Vantage that don’t have logs.
If you want that, let me know.
Has anyone successfully setup a BAM Change Log that only logs modified records and excludes new records?
We are logging the field JobOper.CommentText with a BAM along with several other key fields throughout the database. Over time the JobOper section of our ChgLog table has over 1.1 million records. 99.98% of them are entries for newly created operations. Only a couple thousand are actual modifications to the Operation Comment. My hope is to exclude all the entries for 'New record.' and just show the "real" changes where someone went in and modified the Operation Comments.
I've tried a variety of BAM rules on the CommentText field with limited success. Has anyone successfully excluded New Records from a BAM Change Log?
Thanks,
Eric