What is the SQL query to find all linked call tickets on a deleted HEATBoard issue

Version 1

    Details

    This article explains how to find all the CallID's that were linked to a deleted HEATBoard Issue using a SQL query.


    Resolution

     

    To find all linked calls to a HEATBoard issue that has been deleted run the following query:


    SELECT
    * FROM HEATHot

    WHERE HotName IN

    (SELECT SGName

    FROM HEATSGen

    WHERE SGCode = 'HD')