Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

Check for unsed tables

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,625 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans