xmppejabberd

Can I query ejabberd database for online users

I have ejabberd 16.03, I would like to query the database to get online users that are shown in admin panel.

Can someone help me? Which table do I have to query?

I think I can do something like:

SELECT * FROM lasts WHERE

I need this to make a join with another table of external database. thanks for the help!

Solution

  • You can use

    select * from sm

    for odbc as backend