Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Check for unsed tables

(0) ShareShare
ReportReport
Posted on by 50

I need to find the unused tables from dataverse.

I tried some solutions, here they are:

With sql server: 

SELECT *
FROM sys.dm_db_index_usage_stats
WHERE [database_id] = DB_ID()
AND [object_id] = OBJECT_ID('TableName')

Couldn't do it because of this error -> Invalid table name dm_db_index_usage_stats for schema sys. Line:2, Position:6

I tried with analytics from admin.powerplatform.com -> Only two months available to select. It would be great if I could select from the environment creation till now, that would solve my problem.

pastedimage1667286921963v1.png

Any suggestion? any tool? any way of achieving it with one of the methods above?

Thanks in advance

  • Ricardo Jacobsen Profile Picture
    Ricardo Jacobsen 50 on at
    RE: Check for unsed tables

    Steve Zhao2 Thank you, but  this tool only brings the rows count and the number of custom attributes. It does not get the last time the table was read or written for example. This would be the best indicator for the usage of the table.

  • Suggested answer
    Steve Zhao2 Profile Picture
    Steve Zhao2 on at
    RE: Check for unsed tables

    Hi Ricardo Jacobsen,

    You could use Entity Usage tool in the Xrm Toolbox to achieve this. Please refer to this:

    Entity Usage Overview  · XrmToolBox

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans