Accessing list of logged in users from external

[srx308]

Hi everybody,

Does somebody know if it's possible to access the list of the currently logged in users in OTRS from external?
Need this information for statistics stuff. Of course it would be best if I could find this information in the database.

Maybe someone can help me

Thanks,
Florian

EDIT: Oh sorry I forgot an important information for you: It's about OTRS 3.0.11

[jojo]

you can check the session table

[srx308]

Hi jojo,
thank you for your answer!

I have checked the sessions table, but all the informations are encrypted?
I see there is a parameter 'UserID' in column session_value, but is there a way to decrypt?

Thanks!

[jojo]

it is just a base64 encoding, so it can be decoded.

[srx308]

Ah okay, great! Thank you very much.

And does somebody know how I have to filter the parameters, to get the result like it's in the 'Online'-Box in OTRS-Dashboard?

dashboard_online_box.jpg

[jojo]

have a llok in the code?

[srx308]

Hi,

I had a look in the code.
There is a LastRequestTime (GMT Unixtimestamp) parameter in the Sessions-Table.

DashboardUserOnline.pm Revision 1.20 - Line 165

If: LastRequestTime + (configuired IdleTime or as default 60 minutes) > SystemTime
Then: Show User in the Online-Box

Thanks for your help : )