A code based solution to creating a comprehensive audit view of submissions in Planner Server

Happy New Year!

Whether it be for year-end review or on a regular basis, you may have the need to perform analysis on all submissions made in Planning Server. It's possible that many users are editing the same area or slice of data. Your analysis may include zeroing in on which user submitted the data, what time and day it was submitted, and what the value was before it changed -- just as a starter.

You may already know that when using the PerformancePoint Add-in for Excel you can look at all the details of your submissions within an individual assignment by clicking "Show Current Changes".  But you have to have the assignment open, and the data is presented on an individual basis. That's not practical for those who need a single comprehensive look at the audit trail data. Doing so requires a few bits of code.

Before you get started you will need to make some key design decisions on the audit lifetime, the data retention period, and the data volume. To create this solution you need to be a Visual Studio developer with experience writing a C#/Visual Basic .NET application, experience writing and optimizing SQL stored procedures, and knowledge of how to create and schedule an executable file.

Check out the full article, complete with code, here:    Creating an audit view of submissions in Planning Server