Can I kick someone out of a session?
Hi.. In Software Planner I don't see the ability anywhere to kick a user out of a session (if logged in). I do have my session timeout set at default (30 minutes)... but was wondering if Software Pla...
Forum Discussion
Kary, there is a way for administrators of self hosted ALM sites to kill user sessions, but it currently is broken. After you're logged in, change the URL to: {yourWebsiteDomain}/Common/Logon.asp?WCI=tplUserList
It will provide you with a way to see who currently has open sessions in the database.
Each username is a link, which when clicked on, should clear that user's session.
Until SmartBear provides a fix for this, you can clear sessions using the following SQL directly in your databases sql window, after substituting curly braces and their contents with your actual data:
UPDATE PersonLogins SET DateLogout=GETDATE(), LoggedOutBy='Your Name'
WHERE UserId IN ({PUT COMMA SEPARATED USERIDS TO CLEAR SESSIONS FOR HERE})
AND DeptId={THE DEPT ID FOR THE USERS ABOVE}
AND DateLogout IS NULL;
Then run:
UPDATE Persons SET IsLoggedOn = 'N'
WHERE (UserId IN ({SAME COMMA SEPARATED USERIDS AS ABOVE})) AND IsLoggedOn = 'Y';
It will provide you with a way to see who currently has open sessions in the database.
Each username is a link, which when clicked on, should clear that user's session.
Until SmartBear provides a fix for this, you can clear sessions using the following SQL directly in your databases sql window, after substituting curly braces and their contents with your actual data:
UPDATE PersonLogins SET DateLogout=GETDATE(), LoggedOutBy='Your Name'
WHERE UserId IN ({PUT COMMA SEPARATED USERIDS TO CLEAR SESSIONS FOR HERE})
AND DeptId={THE DEPT ID FOR THE USERS ABOVE}
AND DateLogout IS NULL;
Then run:
UPDATE Persons SET IsLoggedOn = 'N'
WHERE (UserId IN ({SAME COMMA SEPARATED USERIDS AS ABOVE})) AND IsLoggedOn = 'Y';
