TRIMCat, the tool is available from support. It allows you to consolidation locations, but not in a way that is extremely useful from my point of view. Since it's not publically available you should really contact them and ask the questions.
Here's an explanation I received about what the tool does. This may help you decide if it does what you're hoping it will:
The way it works is as follows:
1. You have the option of choosing a single unknown location to clean up or it gives you the option to do all unknown locations simultaneously
2. You will then be prompted to choose a dataset to connect to and act upon
3. Assuming you choose all unknown locations, it grabs the first unknown location, then looks for other unknown locations that have the same email address listed in TRIM
4. It will then replace the record associations (home location, owner location, contacts, etc.) of records that are associated with the unknown location that is to be deleted, with the replacement unknown location
5. It will continue doing step 3 until there is only a single unknown location left with that email address in the dataset
6. If it can find a known (internal person) location with the same email address, it will continue using the known internal person location as the replacement, thereby ultimately deleting all the unknown locations with that email address.
7. It will continue going through all the unknown locations until finished with the dataset.
If there are multiple unknown locations but no known internal person locations in the dataset, then you will be left with a single unknown location, and all previous record associations will be replaced with the remaining unknown location.
If there is a known internal person location, it will use this instead, leaving you with no unknown locations with this email address.
Note there is no progress bar for the utility, the only indication that the utility is still successfully running is by checking in task manager and watching that the CPU / memory usage of the utility is changing periodically. It is likely that this utility will take quite some time to complete depending on the number of unknown locations present in the dataset.
I recommend you test this utility on a backup of the dataset before applying to production.
Note: Any posts I make on this forum are my own personal opinion and (unless explicitly stated) do not constitute a formal commitment on behalf of HPE.
(Please state the version of CM you're using in all posts.
HPE Software Support Online (SSO): https://softwaresupport.hpe.com/