How to find all AutoTasks using Create Call and If Call is New Use It Functionality

Version 1

    Details

    Is there a way to find all of the AutoTasks that have a Create Call action that is set to use the functionality of "If the current call is a new call, then use it"?


    Resolution

    Running the following query in SQL Server Management Studio will return a list of names, Owners and storage folder for all AutoTasks with a Create Call action using the "If the current call is a new call, then use it" option:

    SELECT SGName, SGOwner, SGSFolder FROM HEATSGen

    WHERE SGDetail LIKE '%Create Call%'

    AND SGDetail LIKE '%CreateFlag=0%'

    ORDER BY SGOwner