How to find an outdated Email address used in AutoTasks.

Version 1

    Details

    How to find an outdated Email address used in AutoTasks.


    Resolution

    The below SQL query will return the owner of the AutoTask (SGOwner), the name of the AutoTask (SGName), and the folder the AutoTask exists in if applicable (SGSFolder).  Replace the "Replaced-Email@company.com" with the email address needing to be found:



    SELECT SGName, SGOwner, SGSFolder
    FROM HEATSGen
    WHERE SGDetail LIKE '%Replaced-Email@company.com%'