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.
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="">;
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/6/13, 9:33 AM|
|Seen: 5847 times|
|Last updated: 3/16/15, 8:10 AM|