How to get the Survey ID for use in the Survey Notification email sent on close of an incident

Version 1

    Details

     

    How to get the Survey ID for use in the Survey Notification email sent on close of an incident.
    In version 2014.3.1, the survey ID is no longer available when editing the survey properties.  To get the Survey ID you will need to query the database.

     


    Resolution

     

    You will need to query the database to get the survey id.   (this query assumes you are using the HeatSM db.  Your dba may need to adjust this to query the appropriate db.


    SELECT 
           [SurveyId]
          ,[Title]
          ,[Description]
      FROM [HEATSM].[dbo].[FRS_Survey]

    Find the appropriate survey and copy the Survey ID.  This is the survey ID used in the Survey Notification email.