Microsoft Dynamics 365 | Integration, Dataverse...

Check for unsed tables

(0) Share

Report

Posted on by Ricardo Jacobsen

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 (2)

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