News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum Check for unsed tables

Dynamics 365 general forum

Suggested answer

Check for unsed tables

(0) Share

Report

Report

Posted on by Ricardo Jacobsen

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.

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

Thanks in advance

Categories:

Dynamics 365 Administration

Customization / Solutions / SDK and API

Other Functionality

All responses Img

All responses (2)

Answers Img

Answers (0)

Ricardo Jacobsen 50 on at

Like (0)

Report

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 on at

Like (0)

Report

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 228,625 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans