Announcing Dynamic Audit Locker
We’re excited to announce one of the first products developed here at Dynamic Consulting, Dynamic Audit Locker. Before we dig in, it’s important to understand a bit of the history of how this came to be.
As you’ve probably heard, and seen in the Power Platform Admin Center, the way that Microsoft is licensing storage is changing this year. We’re moving from one big bucket of storage for everything (which cost around $10/GB/mo) to three distinct buckets:
Database Storage: This is your system configuration and the basic data stored in CRM like your Accounts and Contacts.
File Storage: These are attached documents to Notes and Activities.
Log Storage: This is your Audit History, which shows changes to field values, who changed them and when for entities enabled for Auditing.
Each tenant comes with a default storage amount, plus some additional storage is granted with each user licensed for D365. Here’s a breakdown of the defaults, per user entitlements and the cost for additional GBs:
As you can see, the included Database and File storage will grow based on adding more users, but the Log storage does not. After looking at what this would mean for our clients, we found that most would either need to delete valuable audit history data, or pay thousands in extra log storage licensing each month just to keep what they have.
So we decided to create another option: a way to create a copy of the audit history data in Azure and make it available on the CRM records right next to the default audit history. The idea was to be able to delete the normal audit logs that were driving up the cost while keeping the data accessible to the users from a safe, secure, scalable database in Azure. After some trial and error, we got this to work and Dynamic Audit Locker was born!
With the audit data available in Azure, not only were we able to replicate the default audit history, but we were able to improve upon it with the ability to sort and search the audit history with a record.
And by connecting Power BI to the Azure database, we were able to create a rich set of reports showing the composition of the audit log database, plus system and user-level usage statistics that can help to flag issues and monitor system adoption.
We’re in the process of getting Dynamic Audit Locker up on AppSource, but in the meantime, we’re excited to announce that it’s available as a manual install. With these improvements over the out-of-the-box audit history, and a lower cost than the normal log storage (the Audit Locker is just $5/GB/Mo), we think this is a win-win all around.