We run a copy of Web Help Desk and from time to time we end up with duplicate client entries. Our WHD is connected to AD so you’d think this wouldn’t be possible but….. surpriiiiiiise.
Our monitoring platform, PRTG, allows us to run SQL queries and alert based on the response we get. I’ve created a monitoring rule for this SQL query (with this excellent help):
SELECT
[EMAIL]
,[USER_NAME]
,COUNT(*) AS "COUNT"
FROM
[WebHelpDesk].[dbo].[CLIENT]
WHERE [DELETED] != 1
GROUP BY
[EMAIL]
,[USER_NAME]
HAVING
COUNT(*) > 1
If it ever returns more than 0 rows it means there is a duplicate account we need to find, merge and purge using SolarWinds procedure: https://support.solarwinds.com/Success_Center/Web_Help_Desk_(WHD)/Knowledgebase_Articles/Merge_duplicate_WHD_clients_in_bulk
Our Web Help Desk is backed by a MSSQL Database instead of the built-in PostgreSQL. You may need to tweak the query if you are using PostgreSQL and can even get into the embedded database.