CODEWITHSUNDEEP
dynamics-crm-2011dynamics-crmdynamics-crm-2013dynamics-crm-4dynamics-crm-2015
Kunal Goel
Kunal Goel

Reputation: 3657

Finding unused CRM fields

We are currently using CRM 2015 ONLINE and we have a requirement to find and delete unused fields from CRM organization. Also, we feel there are certain performance gains to be had by removing unused fields – especially Lookup and Picklist/Option Set-type fields. Since, these kinds of fields force CRM to get information from other database tables every time they are referenced, so it’s wasted effort to try to fetch that data when you know there never will be anything to fetch.

Do you have any way to figure out, which “columns” are null OR Which columns has count 0 ? And does not contain any value in Table? OR I'm looking for a script/way (to do in crm ONLINE) that will do a count for every column in a table including the number of null values

Expected results

Upvotes: 0

Views: 818

Answers (3)

Henk van Boeijen
Henk van Boeijen

Reputation: 7948

When you need to find out which (custom) fields are used on forms and in views and which are not, you may find the Metadata Browser in the XrmToolBox useful. It is free and as open source available on GitHub.

Upvotes: 0

Daryl
Daryl

Reputation: 18895

You could write a console app that Performs a Metadata request to get all of the columns for each entity and create a custom Query Expression for each column for each entity. It wouldn't be very performant, but it would work. It would also take a few days to write as well.

Upvotes: 1

Andrew Butenko
Andrew Butenko

Reputation: 5456

As for me the easiest way is following:

  1. Request Organization DB backup from Microsoft.
  2. Restore that backup somewhere.
  3. Use t-sql script to analyze usage of attributes.

Upvotes: 0

Related Questions