News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Check for unsed tables

Microsoft Dynamics 365 | Integration, Dataverse...

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

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... 291,419 Super User 2024 Season 2

#2

Martin Dráb 230,492 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans