I am working on an assignment wherein I have to identify all the contacts where are not used anywhere in our Salesforce org. What could be the best way to approach this? Are there any apps available which can help.
- Get a complete data export for the Contacts and any objects you are interested in that may reference those contacts.
This will give you zip files containing CSVs with all the columns for those objects, including any Contact references.
- For each contact Id, do a local text search on the contents of the CSV files. If you find the contact Id anywhere other than on that Contact itself then you know it is referenced at least once.