OpenFire table (online user)


What tablo of OpenFire structure I can see online users or offline users.

I´d like to get presence by select on tables… it is possible?



it is possible?

no, that information is not stored in database, because it does not make sence to recover this data after a reboot or crash. It’s only kept in memory. You can find a list of all database tables here.

If you want to get this information you will need some kind of plugin that provides this information. Probably the “Presence Service”-Plugin is what you are searching for. Maybe you will need to modify it a bit.