Potential alternate solution for DB logging to avoid huge production DB size

 

We all know Database logging for audit trail is one of the very common requirements in Dynamics 365 F&O, but that ends up having huge DB size issues. We were looking for some alternate solutions, this can be a potential alternate solution for this.

Developed small POCs for getting audit log in Dataverse using below options:

• Taking data from Dataverse tables and creating record in audit log file of Dataverse (Dataverse table from where data getting fetched gets populated using Dual Write).
• Taking data through Business Events of F&O and creating record in same audit log file of Dataverse.
• Reading data from Virtual Entities and creating record in same audit log file of Dataverse.

Power BI or Power Apps can be leveraged to design the required information as required from the audit log table of Dataverse.