The default auditing functionality only works when changes are made via the front end of DSP. When there are lots of changes that needs to happen, it's not uncommon to make the changes directly in SQL. To that end, I've written some SQL triggers to accomplish this. They work in conjunction with the standard DSP Auditing. There could be a button added to the Auditing page that allows you to create/drop these triggers as desired.