Where to change the frequency of Surveys being sent

Version 2

    Verified Product Versions

    LANDESK Service Desk 7.6LANDESK Service Desk 7.8.xLANDESK Service Desk 2016.x

    Question:

    Where and how can I change the frequency of survey being sent out

     

    Answer:

     

    There is a trigger called "tps_survey" under the table im_incident which will need to be amended.  Open that up and there is a line you need to edit to change to the frequency you want (it is clearly marked out in the trigger and marked as red below):

     

    declare @constant int
    select @constant=10 -- amend this value to change frequency of survey

          declare     @pm_lifecycle_guid      uniqueidentifier

     

     

    NB:

    Please ensure this is done by your DBA and a backup of the database is done before making any amendments on your database.  Where possible please ensure it is tested on a test system before applying it to your live environment.