Hello,
I have a little problem with our online D365.
I see in Organization Insights the the AuditBase is about 27 GB and I see that the active audit log is about 7 GB.
Is the AuditBase table something diffrent than the active audit log table?
Can I shrink this AuditBase tablke somewhere?
Kind regards,
Arie
*This post is locked for comments
Did you ever find that "plain english" version you were seeking? We have an issue with the table size and need some assistance as well! thanks! Laura
This has me perplexed. Like so many commenting:
My conclusion so far is that whoever mentioned indexing must be correct. Has anyone found a plain english article about how exactly the auditbase size is calculated? How can one reindex it? Does the system simply flag them for deletion and not actually delete them? Having 16GB tied up for a 3.4GB audit log, with no apparent way to delete or reduce it is ridiculous. If Microsoft picks up on this, some clarifying documentation would certainly help.
Code follows. Apologizes for lack of security or error handling. Use at your own risk.
Share
Report
All responses (
Answers (
using System;
using Microsoft.Xrm.Sdk;
using Microsoft.Crm.Sdk.Messages;
using Microsoft.Xrm.Tooling.Connector;
namespace DeleteSandboxAudit
{
class DeleteAuditLog
{
static void Main(string[] args)
{
string CRMConnectionString = @"AuthType = Office365; URL = xxxxxxxxxxxxxxxx.crm.dynamics.com; Username=XXXXXXXXX@XXXXXXXXX.com; Password=XXXXXXXXXXXXXXX";
//Get CRM Connection
Console.WriteLine("Connecting to Sandbox. Please Wait... ");
CrmServiceClient crmConnection = new CrmServiceClient(CRMConnectionString);
IOrganizationService crmService = crmConnection.OrganizationServiceProxy;
Console.WriteLine("Connected to Sandbox.");
// Get the list of audit partitions.
Console.WriteLine("Retrieving Partions...");
RetrieveAuditPartitionListResponse partitionRequest =
(RetrieveAuditPartitionListResponse)crmService.Execute(new RetrieveAuditPartitionListRequest());
AuditPartitionDetailCollection partitions = partitionRequest.AuditPartitionDetailCollection;
Console.WriteLine("Retrieved Partitions: " + partitions.Count);
Console.WriteLine(partitions.ToString());
// Create a delete request with an end date earlier than possible.
DeleteAuditDataRequest deleteRequest = new DeleteAuditDataRequest();
deleteRequest.EndDate = new DateTime(2000, 1, 1);
// Check if partitions are not supported as is the case with SQL Server Standard edition.
if (partitions.IsLogicalCollection)
{
// Delete all audit records created up until now.
Console.WriteLine("No Partition Collection Found. Attempting Deletion of unpartitioned audit log to current date.");
deleteRequest.EndDate = DateTime.Now;
}
// Otherwise, delete all partitions that are older than the current partition.
// Hint: The partitions in the collection are returned in sorted order where the
// partition with the oldest end date is at index 0.
else
{
for (int n = partitions.Count - 1; n >= 0; --n)
{
Console.WriteLine("Partition " + n.ToString() + " EndDate:" + partitions[n].EndDate.ToString());
if (partitions[n].EndDate <= DateTime.Now && partitions[n].EndDate > deleteRequest.EndDate)
{
Console.WriteLine("Setting deleteRequest.endDate to Partition " + n.ToString() + " :" + partitions[n].EndDate.ToString() + " Size(b):" + partitions[n].Size.ToString());
deleteRequest.EndDate = (DateTime)partitions[n].EndDate;
break;
}
}
// Delete the audit records.
Console.WriteLine("Attempting Deletion");
try
{
Console.WriteLine("deleteRequest.endDate:" + deleteRequest.EndDate.ToString());
if (deleteRequest.EndDate != new DateTime(2000, 1, 1))
{
crmService.Execute(deleteRequest);
Console.WriteLine("Audit records have been deleted.");
}
else
Console.WriteLine("There were no audit records that could be deleted.");
}
catch (Exception ex)
{
Console.WriteLine("Unable to delete partitions. Exception:\n" + ex);
}
Console.ReadLine();
}
}
}
}
I think I have found the reason why the AuditBase is so big.
We got from MS a view of our comsumption and indeed, the AufditBase is at the moment about 31 GB, 10 GB is data (and which we probably see in our Audit logs) and 21 GB of index files for that AuditBase log.
So we see in Organization Insights the total of these two files and in the Audit log files we see only the data file.
Hi Arie, Yes you can delete the oldest logs as well.
Hi James,
Thx a lot for the info, I will digg into this .......... ;-)
Hi Arie
I got the detailed report via our Support Partner.
I have been given this link for Dynamics 365 support in the past: https://www.microsoft.com/en-gb/dynamics365/contact-us, but it looks to be more sales focused (I never used it in the end). I also have 0800 032 6417 as a phone number (in the UK).
Good luck getting the information.
James
Hi James,
Tnx for the detailed info, it looks like what we have experience over the past year. We have growed also some extra GB's overnight and a few days later we were also back to 'normal'.
We don't use the storage for Mail or Notes so that isn't the case here.
I also agree we get every day a warning e-mail about our GB comsumption but we would rather have a detailed overview so we can see where our data is going to.
Do you know where I can ask MS for a detailed list of all our tables?
I should also mention that when I have looked at the detailed storage reports, there is often quite a bit of storage taken up in reserve, but 17GB seems excessive!
Hi Arie
Unfortunately, I am finding this happens more and more often. The tables seem to get bloated and take up more room than they should. This might not be happening in your situation, but it has happened to me several times. A couple of weeks ago I noticed 6GB of data was consumed overnight. I did all my usual checks and nothing seemed to explain why it had grown so quickly. It continued to grow over the next few days (over 10 GB bigger than it started) and I eventually gave in and purchased more storage. Within 24 hours, the overall storage being consumed had shrunk back down to where I would expect it to be (so I removed some of the extra storage I purchased!). This also happened the last time it unexpectedly grew.
I asked our MS Partner if we could request for the tables to be reindexed, but they said it was an automated process controlled by MS and the MS Support guys didn't know much about the details, just that it ran more regularly for bigger databases (we are just over 100GB). Microsoft can provide a detailed list of all the tables upon request, and this might give a better indication of where storage is being consumed (Notes & Email attachments are usually to blame!).
It is quite frustrating that we have such little control over this and the automated 80% warning emails push you to purchase more storage, but I guess that is what we have to cope with for the convenience of being in the cloud.
James
Yes, it looks inconsistent. Still, it depends on what is counted where.. I don't know how exactly those numbers are calculated on both sides. For example, I'm wondering if index size is included into those 5 numbers you posted (and it might be included into the 27GB)
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