Soft Delete Inactive End Users

Version 1

    Verified Product Versions

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