Query for on-line users

I am running Openfire 3.6.4 on Redhat Linux with a MySQL db. Is there a way to determine what users are on-line and their status (available, idle, etc) from a db query or shell command (without having to login to the Admin console and viewing client sessions)?

Hi,

this kind of information is not persisted in the database as it is fine to handle this in memory. So you may want to write a plugin to get the information - it could bypass authentication and deliver a HTML or XML page with the desired format.

LG