Currently logged users

[Knut Paulsen]

Hi guys,

Is there a way to find out exactly which users are logged on to a specific project right now?

Cheers
Knut

[qwerty]

You need to ask your DBA what the RDBMS offers in that direction.

q.

[OpenIT Solutions]

I can't see a way via standard Sparx SQL schema or the automation interface. You could use your databases built in schema (depending upon your database) to query active users. Which database are you using ?

[Knut Paulsen]

Thanks for replies :-)

We use MySql, but we all share a common DB user. Is it possible to find out how many times this user has connected?

So EA does not record the fact that a specific user logs on or off?

Cheers
Knut

[OpenIT Solutions]

I'm not sure as we don't use MySQL - you would have to check with you dba/google/mysql forums to see if you can query the number of active connections/sessions...but you may not get an accurate figure due to connection pooling etc...

[OpenIT Solutions]

Ops sorry didn't read final part of your post - if you have auditing turned on in EA you might be able to see who log into sparx - i can't remember if its shown in the audit log - i think it just shows who has made a change - you would have to test...

[qwerty]

EA does not log a login. The audit just logs changes. You might check the open sockets on the server side. But that's only a vague indication to whether a user is still "logged on" as there is no "log off" sent. Just the connection dies away after some time.

So in general: no way.

May I ask for what reason you want to have the user list? What is the use case?

q.

[Knut Paulsen]

The reason I came to think about this is that I often see locked diagrams in my model. It appears like EA not always will reset a lock when a user logs out. So, I was thinking that if the user holding the lock is still logged on I can call him, if not I can safely reset the lock.

Cheers
Knut

[qwerty]

If a user locks a diagram to edit it, he has obviously reasons for doing so. In the case where users forget to unlock anything the best approach is: a) walk in, b) phone, c) mail, d) force unlock.

q.