6

Scenario

In my grown org (200 objects, thousands of fields) some fields are not in use. We define as not in use by the following criteria: (A) No records for the whole object or (B) not populated within the last 6 months.

Question

  1. Is there any way to determine field without value and modified within the last 6 months?
  2. What is the best approach to find the fields?
Improve this question
2
  • I am also struggling with this. I have launched Salesforce Optimizer but never get a selection of production or sandbox. Just a popup saying my org is being analyzed. I never get a report. It's very strange. Any ideas what ma be going on? I have all the correct permissions.
    – Jane
    Jun 25, 2017 at 21:29
  • For me also Optimizer didn't send the report. But when I went to my org and check the 'Files' it's there.
    – highfive
    Feb 13, 2019 at 7:24

2 Answers 2

Reset to default
6

One native way is to run Salesforce Optimizer from setup

Salesforce Optimizer analyzes a suite of features and sends you a personalized report about how you can improve your implementation. You can run Optimizer for both sandbox and production environments.

You will get a personalized report on your instance. Specific to your requirement you will get fields related statistics - Field Usage - Optimizer

For e.g. unused fields - enter image description here

Improve this answer
5

The folks at Qandor developed a great app called Field Trip perfect for the job. And even better, it is free! This tool analyzes both standard and custom fields across all objects and tells you how many records each field is populated in and the percentage of records that have that field populated.

More info is avaialbe on USING FIELD TRIP APP TO CLEAN UP YOUR SALESFORCE INSTANCE

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .