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
I had a thought to Request Organization DB backup from Microsoft, Restore and Use t-sql script to analyze usage of attributes, but as of now it seems to be a very long & time consuming process, as lot of approvals & other stuff would be involved in this process down the hierarchy.
So, what I was wondering if we can do it custom, using CRM SDK. Do you think if there is way using CRM SDK, we can achieve this? Any pointers would be helpful.
I also came across with a tool for this called, “CRM Data Detective”. But maybe it is not supported for CRM 2015. FYR: crmdatadetective.codeplex.com would be happy to listen your views!
