Skip to Content
Menu
This question has been flagged
2 Replies
28300 Views

Is there a way to see all users who are logged on in OpenERP?

Avatar
Discard
Best Answer

OpenERP is essentially stateless. Every request made from the web client is logging a user in. Every user can have the web client open (and open in many browsers, in many tabs and even on many machines), but there is no load on the system if they are not doing anything. If they spend 5% of their time clicking/typing and 95% of their time reading, there is a very low server load.

So you can't get the users who are logged in, only those who have recently connected. At version 7.0 this is even harder unless you log connections because the table res_users (model res.user) that stores the last connection date for each user now stores only the day, not the time (like it did at 6.1).

What do you want to know the users who have recently logged in for? To check that you can reboot the system? To model/manage server load? Perhaps other readers of your question may have some ideas if you explain the need behind your question.

Avatar
Discard

".. stores only the day, not the time .." eww yuck, that's a backwards step.

Author

Yes, I just need to know wheather I can reboot the system or not.

I just wanted to know exact timing on which he/she/user logged in into Open ERP System without attendance Module.

Best Answer

There is no way to know the active users in OpenERP. But if you want to see if there is an openerp user active in the database, you can run this query from psql:

SELECT datname,usename,procpid,client_addr,waiting,query_start,current_query FROM pg_stat_activity WHERE datname = <name of="" your="" openerp="" database=""> AND usename = <username running="" openerp,="" ussually="" it="" is="" openerp="">;

Avatar
Discard
Related Posts Replies Views Activity
1
Mar 15
5411
1
Mar 15
7974
1
Mar 15
7883
1
Mar 15
4794
4
Mar 15
4072