Hello All -
We are in the process of migrating an on-prem instance of CRM to the cloud, and part of what we are needing to do is identify a lot of the customizations that we've made over the years. It is easy enough to identify custom columns and tables - and we've written some queries to pull information about these items from the metadata schema, but one thing we have not been able to find in the database is whether or not a custom column is actually used in a form in the application, and if so what form(s) include that column.
If you try to remove a field (column) in CRM and it is used in a form, the application stops you and reports a dependency. So it seems clear that the data exists somewhere. What we are hoping to find is a list of all of the columns actually used in forms.
Basically the purpose of this is to get an idea of the level of effort needed to remove obsolete custimizations.
thanks in advance.