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.