Script to Undelete an Analyst that has been softdeleted

Version 5

    Verified Product Versions

    LANDESK Service Desk 7.6LANDESK Service Desk 7.7.xLANDESK Service Desk 7.8.xLANDESK Service Desk 2016.xLANDESK Service 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.