[sims] Is there a way I can see all users currently logged into sims?

[tj2419]

I am trying to find a way to see a live list of who is logged into sims currently. Does anyone know if this is possible in SIMS or within SOLUS 3?

 

I found Focus > System Manager > User Access Logs but it seems to just show everyone who has logged in at some point on this day.

 

Cheers

[ICT_Pro]

You can get some inforamtion through SQL Server Management Studio-Activity Monitor.

[TwistedHelixis]

Many years ago they did have a system for displaying logged in users, but that was back in the floppy disk days. Would have thought it must be possible.

[Chuckster]

I am trying to find a way to see a live list of who is logged into sims currently. Does anyone know if this is possible in SIMS or within SOLUS 3?

 

I found Focus > System Manager > User Access Logs but it seems to just show everyone who has logged in at some point on this day.

 

Cheers

 

You could use the SQL Management Studio and type this in...

 

sp_who2

[vikpaw]

If you're playing in SQL, then I think this used to work quite well, you'll have to edit line 16 with the name of your database(s).

*Usual caveats apply: use at own risk - don't mess if you don't know what you're doing.*

 

The output is useful, however I don't think it's a complete cover all. If you're doing it pre-upgrade, I used to remove share permissions (where they got their connect.ini from) then disconnect all the users, so they couldn't reconnect.

use master;

select distinct sysprocesses.loginame,
--sysprocesses.spid,
sysprocesses.hostname,
sysdatabases.name,
/* sysprocesses.nt_username,
sysprocesses.login_time, */
sysprocesses.status,
sysprocesses.memusage,
sysprocesses.dbid
from sysprocesses

join sysdatabases on sysprocesses.dbid = sysdatabases.dbid

where sysdatabases.name = 'sims' OR sysdatabases.name = 'fms'

order by sysdatabases.name, sysprocesses.loginame

 

Other than that, i vaguely recall SOLUS2 used to tell you at one point if there were logged in users. Or maybe it was an executable that we got from the LA support team in Northants.