Script to Undelete an Analyst that has been softdeleted

Version 5

    Verified Product Versions

    Service Desk 7.6Service Desk 7.7.xService Desk 7.8.xService Desk 2016.xService Desk 2017.x

    If you would like to restore a soft delete user the following statements can run against the database.

    The tps_name value "testuser" has to be updated for the required user.

     

    --------------------------------------------------------------------------------
    update tps_user set tps_deleted = '0' where tps_name = 'testuser'
    update tps_password set tps_deleted = '0' where tps_guid = (select tps_password_id from tps_user where tps_name = 'testuser')
    --------------------------------------------------------------------------------

     

     

    NOTE: Before carrying out these instructions, I would recommend that you try this out on a test system initially, check you are happy with the results, then roll the changes out to your LIVE database. When making the changes in your LIVE environment, please ensure that you have a full working backup of your database - and that all users are out of Console and the serviceportal. If there are any issues, restore the database backup you took immediately prior to making the changes.