Detecting duplicate accounts in Web Help Desk

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):

    ,COUNT(*) AS "COUNT"
    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:

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.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.