594
Hi CRM World,
Can we delete the audit history by entity? I searched CRM SDK and found only one method:
DeleteAuditDataRequest which is used to delete all audit history inside a partition (a quarter of year as per CRM) before a
a given end date.
I am exploring if we have any other method to delete audit history only for a particular entity? Or is there any other method
to achieve this?
I am on Dynamics 365 Online.
*This post is locked for comments
Hi CRM World,
Can we delete the audit history by entity? I searched CRM SDK and found only one method:
DeleteAuditDataRequest which is used to delete all audit history inside a partition (a quarter of year as per CRM) before a
a given end date.
I am exploring if we have any other method to delete audit history only for a particular entity? Or is there any other method
to achieve this?
I am on Dynamics 365 Online.
This is now possible using the admin center you can select which tables to delete the audit logs for.
Hi ,
I believed the custom entity means, they suggested to store the audit history into custom entity as a record instead of auditing, because we cant import audit.
Hi Wei,
Thats a very good info man. Thanks for sharing. But the community post says we can import back the audit history into a custom entity or to another custom application. After importing like this, when we selected a contact record and clicked drop down (to open associated records) and clicked auditing entity associated with that contact record, we no longer see any audit history logs related to that contact.
So we have to browse back to custom entity where my audit logs are imported, search a contact by its name, find its related audit history and dig deeper into its audit.
But i am looking for a solution to attach the audit history to that particular contact record so that whenever we want, we can open the contact drop down, click auditing and view contacts audit history instead of browsing to custom entity.
IS IT POSSIBLE?
Hi Johny,
That was great explanation. Thanks for it. I have one last question.
Suppose say i extracted contact entity related audit logs data using SSIS onto my personal SQL DB and deleted the whole audit log in CRM Online. Is it possible for me to re-import back the audit logs data into CRM Online? Atleast this way i could achieve my requirement.
Thanks
Hi,
As I check from the official document and all the D365 community, the DeleteAuditDataRequest is used to delete all audit data records up until a specified end date. There's no method update about the Audit history deletion by entity in D365 Official Document as follow:
https://msdn.microsoft.com/en-us/library/microsoft.crm.sdk.messages.deleteauditdatarequest.aspx
In addition , there's also a similar solved thread for your reference.
https://community.dynamics.com/crm/f/117/t/236432
In another way , you could store D365 Audit Log offline by extracting the log details from 3rd party toolkit like the SSIS Integration Toolkit for Microsoft Dynamics 365 which works both on premise and online. Then you could delete all these audit logs to free space.
The following Toolkit details are for your reference:
Download Linkage: http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-365/download
Video of Getting Started with SSIS Integration Toolkit for Microsoft Dynamics 365/CRM: https://www.youtube.com/watch?v=5Sr2UrgACGY
Hope it helps.
Regards,
Johnny
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (