Consolidate and filter audit logs from multiple tables

(1) Share

Report

Posted on by Kannan.Balasubramanian

I have a requirement in Dynamics 365 which seems not possible, but I wanted to make sure before confirming to the customer.

"Customer" has unique customers.
"Customer Payment" has all the payment records for each customer with audit logging enabled. "Customer" has a 1:N relationship with "Customer Payment".
"Customer Feedback" has all the feedback records for each customer with audit logging enabled. "Customer" has a 1:N relationship with "Customer Feedback".

Now the end users should be able to **select a customer** and **see a consolidated** list of all the **audit logs from both "Customer Payment" & "Customer Feedback"** for the selected customer.

Is this possible? I know there is a possibility to use Web API to fetch audit logs, but I don't see an easy way without custom development.

All responses (1)

Answers (0)

Boolean1 60 on at

Like (0)

Report

RE: Consolidate and filter audit logs from multiple tables

I would suggest looking into Zap Objects - Audit User Actions; and see if that can help you.

It's configurable so that you can audit specific actions of selected entities. And it's got good filtering. Not sure it will fully meet your requirements, but may be a work-around.