Clear partial audit history

(0) Share

Report

Posted on by Community Member

Hello,

My database is growing quickly because of emails sent by Quick Campaign.

The size is now 150 Gb.

Is it possible to clear "some" email (NOT ALL) from Audit History ? Because the delete only move the e-mails to the history and the database size is the same.

Thanks in advance,

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Kokulan 18,054 on at

Like (0)

Report

RE: Clear partial audit history

Hi

Yes you can clear old audit logs, please see below

Go to Settings Auditing and then Audit Log Management, you can delete audit logs from there

Delete the older ones first and you may want to keep the recent ones

[View:/cfs-file/__key/communityserver-discussions-components-files/117/ScreenClip-_5B00_359_5D00_.png]

[View:/cfs-file/__key/communityserver-discussions-components-files/117/ScreenClip-_5B00_361_5D00_.png]

Also, follow methods recommended by Microsoft to free up storage space from the following link

[View:https://docs.microsoft.com/en-us/dynamics365/customer-engagement/admin/free-storage-space]

Was this reply helpful? Yes No
Suggested answer

Rajesh Chungath 467 on at

Like (0)

Report

RE: Clear partial audit history

Yes you can clear the audit logs from audit log

1) Settings > Auditing > Audit Log management and delete the old logs

To reduce the storage also check system job logs. Delete the failed and success job logs on time. Please configure a Bulk delete job to delete the old log files.

Search for System jobs using advanced find.

Use power admin to monitor the storage

admin.powerplatform.microsoft.com/environments

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Clear partial audit history

Thanks but I want to clear only some emails, not an entire log file.

Is it possible ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Clear partial audit history

I've a On Premise CRM 2016 install not 365

Was this reply helpful? Yes No
Suggested answer

Kokulan 18,054 on at

Like (0)

Report

RE: Clear partial audit history

No you wont be able to selectively delete audit logs.

What do you mean by clear email?

audit logs only store the change history to records they do not store actual records

You can certainly delete emails and attachments, you can decide which ones you want to keep and which ones you want to delete

Please refer to the methods recommended by Microsoft

docs.microsoft.com/.../free-storage-space

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (0)

Report

RE: Clear partial audit history

To clarify across some of the previous posts:

Audit data is a record of changes to records of all entity types enabled for audit. This data can only be cleared in bulk by deleting audit logs, which will delete all data based on the time period of the log, and you cannot only delete audit data for some records

You're referring to clearing email, which I understand means that you want to delete the email records. This you can do with bulk delete jobs, where you can specify criteria for which records to delete.

Note that, once you have cleared out records, there may still be allocated space in the SQL database. If you want to reclaim this, you can shrink the database using SQL Management Studio

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Clear partial audit history

Thanks for yours answers. But I think that when I delete emails, there are still in the log to recover these emails. So the database size is the same ? No ?

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (1)

Report
RE: Clear partial audit history

When you delete records, the space they take up will become available, but it may remain allocated in SQL Server. This allocation works at 2 levels:

At the table and index level. If any page (8K of space) still has at least 1 record, then this is still allocated. To reclaim the space, rebuild the indexes on the table

At the database level. Even if the pages have been freed up, the database size will stay the same (unless you either have Autoshrink enabled). You can shrink the database using SQL Management Studio

There will still be space taken up by the SQL transaction log, and deleting a record will add to the transaction log. However, it should be part of your standard database maintenance procedures to periodically truncate the log, preferably by backing it up

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Clear partial audit history

Thanks. I'll see for this.

Was this reply helpful? Yes No