Plan Update audit trail

[RickD]

Is there a way of reporting an audit trail of plan opens and saves over a
period. The Last Modified and Last Published fields are insufficient. If
anyone just opens a plan in update the Last Modified date is changed even if
they don't save.

 

[Chris Marriott]

Hi

There is no audit trail in SQL

The only audit trails are connected with Protected Actuals ... but not who
saved, published the plan etc.

Sorry
--
Regards


Chris Marriott - PMP MCSE MCDBA
UK - EPM Consultant & Trainer

 

[Gary L. Chefetz [MVP]]

Rick:

You can create an update trigger in the database to handle this for you.
You'll need to create the necessary table to do the logging of course. You
should consider whether your system has the horsepower to do the extra work
before attempting this.