Share
ReportI was wondering if someone could share any experience/thoughts with regards to audit reporting. We have a need to do more robust reporting around audit data. Things like "find all records that have a particular field updated during the last 3 months" or "find all records where some particular user changed a value".
We already have a process that copies the audit tables off into their own database. But from there we need to be able to process it. We are thinking one of two ways to handle this (although we are open to other options)
- We leverage some existing tool that sits on top of CRM audit data, knows how to parse it, and provides a nice way that users could query the information
- We build a parser that splits the ~ delimited string of audit data and puts it into individual rows that are actually usable. Then we build our own app (possibly just leverage a tool we already use such as Qlik) to then point to that data and allow us to do custom filters and what not
Thanks in advance for your suggestions!
*This post is locked for comments
All responses (
Answers (
14,063
