Removing Historical Server Connections
| Status: | Published |
|---|---|
| Version: | 1.0 |
| Authors: | HTL QA |
| Applies to: | Supportworks ESP Version 7.x |
If you find that you are unable to terminate Supportworks client sessions via the Manage Server Connections option, please follow the instructions below:
From the Supportworks Server Go to Start > All Programs > Hornbill Core Services > Interactive SQL > and enter the below queries:
use sw_systemdb;
select sid, connectionid, analystname from swsessions;
Identify the session in question, note down the 'sid' number, then enter:
delete from swsessions where sid = ##;
NOTE* where ## should be the sid number.
Furthermore, to stop this issue happening again, on the server please go into Start > All Programs > Supportworks Server > Supportworks Server Configuration > Communications tab > check the box which says "do not allow analysts to log in more than once" and select 'Close Previous Connection' > click on Apply and OK, followed by a restart of the services.