Users Unable to access CSI\Syteline because of too many Users

Created by Andrew Dewell, Modified on Tue, 12 Mar, 2024 at 12:12 PM by Andrew Dewell

Check the number of users using Power BI dashboard.
If number is 65 then some abandoned sessions will need to be removed
These can be Identified by the CreateDate if the is previous to the current date then this use will be an old session that hasn't logged out.
If the user that is attempting to log in has a service licence and there are 14 Service Licence users logged in, then the user will be unable to sign in.
For both scenarios the following SQL script can be used.
select * from SiteConnectionInformation WHERE username <> '$service' AND username <> 'sa' ORDER BY username
/*The above script will provide a list of users currently signed in - ensure that BEL_App is the selected database.

/*If too many connections exist(we have a max of 65 licences) and users have more than one sessions open, If one session is from the previous day its likely that this session can be deleted.
Use the query below to delete an individual session by editing the query with the user name and connectionID:
delete from SiteConnectionInformation where username = 'andrew.rodgers'
and ConnectionID = '38f51282-ac18-4caf-9b3c-b8d6b54f2ee6'

Use the query below if there are a large number of old sessions, this can happen if the Syteline servers are restarted and there are a number of sessions still signed into the system previous to the server restart. Edit the query by updating the dates to the beginning and end of the day where the abandoned connections were created.

delete from SiteConnectionInformation WHERE username <> '$service' AND username <> 'sa'
and createdate >= '2024-03-11 00:00:00.000' and createdate <= '2024-03-11 23:59:59.543'
*/