Skip to main content

Notifications

Service | Customer Service, Contact Center, Fie...
Suggested answer

View Audit Storage usage by Table/Entity

(2) ShareShare
ReportReport
Posted on by 68
Hi All!
 
Is there a way to be able to view which Tables/Entities are using the most storage? Our Log table is large, and we would love to see outliers.
 
I have taken several attempts, most lately using Powershell, but it keeps timing out due to size. I haven't been able to find any XrmToolbox addons that help, either.
 
Would love to get some insight on this. Thanks!
  • J Coad Profile Picture
    J Coad 68 on at
    View Audit Storage usage by Table/Entity
    Thanks for both of those replies - Downloading the excel of database storage does not show Audit breakdowns. 
     
    Also, yes, I have looked at the total size of Audit data. I need a way to see by Entity, which is taking up the most Audit space, so I can reduce storage. What I mean by that, is for instance, seeing how much the audit data in Account, or Case, is taking up. 
  • Suggested answer
    Jimmy Passeti | MVP Profile Picture
    Jimmy Passeti | MVP 253 Super User 2025 Season 1 on at
    View Audit Storage usage by Table/Entity
    Hello,
     
     
    And select the environment that you want to analyze and click on the below icon:
     
    On the first chart, you can use below icon to generate an excel with all the storage for all the tables on Dataverse.
     
    Regards,
    Jimmy Passeti | Microsoft MVP
    ✅ Please mark as Verified if this answered your question!
  • Suggested answer
    ba365guy Profile Picture
    ba365guy 2,948 on at
    View Audit Storage usage by Table/Entity
    Have you tried looking at the details provided here already? (Top log capacity usage by table)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans