Soft Delete Inactive End Users

Version 1

    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

    Attached is a SQL Server script to soft delete inactive end users i.e. End Users which were created over a number of days ago and who have not raised an incident for over that number of days.  In this case the number of days is 730 days (approx 2 years) but this can be amended as required as shown at the top of the script.

     

    This may be useful when there are a number of End Users who have subsequently left or do not raise incidents any more and are still taking up licences.

     

    Always take a backup of the database before applying scripts and test on a copy of the database first.