Search This Blog

Wednesday, September 21, 2016

New XrmToolBox plugin : Attribute Usage Inspector

A colleague of mine recently asked if it was possible to inspect data usage to determine which attributes are useless in a CRM 2016 organization because not filled with any value. My first answer was: no. I used to know a solution named CRM Data Detective that does the same but for CRM 4 and CRM 2011 only.

Ok, I was wrong and found out that a version for CRM 2015/2016 also exists.

Anyway, the major problem with this solution is the fact that if the entity you want to inspect has more records than the AggregateQueryRecordsLimit (which is 50,000 in CRM Online and cannot be updated), then you don’t get real usage statistics.

This plugin resolves this limitation by querying actual records instead of performing aggregation query (only if aggregation query fails because of the limit). This can impact performance but if you really needs it, you get it.

You can also export the result in a raw Excel file.

Here is a screenshot

image

As usual, please use the Plugins Store in XrmToolBox to get this plugin.

Happy inspection!

4 comments:

microsoft ax said...

Hello! Thank you so much for sharing the information about new XrmToolBox plugin. I'm a beginner in Microsoft Dynamics systems, so it's a little hard for me now to concentrate on more difficult tools and features, but I'll try to do my best :)

Michal Micky said...
This comment has been removed by the author.
Mark Chaffee said...

Sorry, But can you explain what the results actually mean? How is the % calculated?

Tanguy said...

The percentage is the ratio or records that have a value for the attribute.
For example, an account name is almost always 100% whereas website might not often be filled and will have a lower percentage