Users logged in to EA

[Knut Paulsen]

Hi guys,
When user security is enabled, is there any way to determine if a given user is logged in or not using the API or a database lookup?

Cheers
Knut

[Eve]

No. There is nothing saved to the DB when a user logs in (or logs out).

There are a few types of activity that you can detect.

• Search for when they last added an element or diagram.
• If auditing is enabled you could also check when they last made a change.
• Check element discussions for recent comments

Ultimately, though these will only provide a guess. They won't work if the user is only reading the model.

[Knut Paulsen]

Thanks Simon,
Would have been nice though :-)

cheers
Knut

[qwerty]

Maybe you can write a trigger in the database? I'm not a DBA. So just a guess.

q.

[Uffe]

I don't think that'd work. You could probably spot when someone reads t_secuser.password, which you could assume means that the corresponding user is being logged in -- but there's no corresponding event to signify when the user logs out.

The only alternative I can see is to DIY.

Write an Add-In which responds to EA_FileOpen() by storing suitable session info (a session GUID, the user name from Repository.GetCurrentLoginUser(), host name, Windows user name, date and time, maybe some other stuff) in a custom table, and to EA_FileClose() by clearing it.

Won't be foolproof. RDP / VM sessions is one problem, changing EA user login during a session is another (there's no EA event to tell you when that happens). Also Windows crashes will leave ghost sessions in your table.

But if your requirements aren't too harsh, and it's OK to do some cleanup in the table every now and then, it might be good enough.


/Uffe

[Knut Paulsen]

Thanks Uffe, that could be a solution :-)

cheers
Knut