How to find case mismatches between CallLog CustID and Profile CustID in HEAT Help Desk

Version 1

    Details

    Case mismatches between the CustID values on the CallLog table and the CustID values on Profile can cause issues with Web UI and HSS.


    Resolution

    Run the following in SQL Server Management Studio to identify records where the case is different between the CustID values:

    SELECT DISTINCT(CustID), CallID

    FROM CallLog

    WHERE (CustID  IN

    (SELECT CustID FROM Profile)

    AND CustID Collate SQL_Latin1_General_CP1_CS_AS NOT IN

    (SELECT CustID FROM Profile))