Odoo Help


How to see all users who are logged on?

on 5/6/13, 9:33 AM 7,708 views

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

Ray Carnes
On 5/6/13, 3:47 PM

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.

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

Ian Beardslee
on 5/6/13, 10:50 PM

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

on 5/7/13, 3:21 AM

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

on 8/5/13, 5:03 AM
On 5/6/13, 5:02 PM

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="">;

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/6/13, 9:33 AM
Seen: 7708 times
Last updated: 3/16/15, 8:10 AM