I have a setup for Zendesk where tickets are created using multiple methods. One of these methods is via MyFusion Notes, and with this method, a new ticket and a new user is created in the database, with nothing more than the phone number, in this format: +1 (888) 888-8888.
Now, when the same customer calls, the same happens, but the phone number comes up like this: +18888888888
The problem is that when the customer called again, that new phone number format is not recognized as already in the system, and a new user is created.
What I want to do, is to first get a list of users where this happened. In database querying terms, I want something similar to SELECT * FROM users GROUP BY phone having count(*) >= 2. Then I can figure out how to merge these users or just delete the empty ones.
Is this even possible?