Removing Historical Server Connections

From support-works
Revision as of 15:48, 23 January 2018 by Deenc (talk | contribs) (Created page with "{{Template:Basic Cover |title=Removing Historical Server Connections |type=FAQ |htl=Y }} {{Template:Basic Status |status=Published |version=1.0 |authors=HTL QA |applicableto=...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search



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.