Hi,
It would be great if the monitoring plugin was able to expose all the statistics via a URL which didn’t require authentication, like the Presence Service plugin does for presence information. Plain text, or even XML would be great.
If that’s not an option (or it can already be done), can someone tell me how to expose the statistics so that I can monitor them with an external application (Cacti)?
I can get the active users and active conversations stats with a couple of database queries:
Active Users:
SELECT COUNT(bareJID) FROM ofconparticipant WHERE leftdate > UNIX_TIMESTAMP(DATE_SUB(NOW(),INTERVAL 10 MINUTE))*1000;
Active Conversations:
SELECT COUNT(conversationID) FROM ofconversation WHERE lastActivity > UNIX_TIMESTAMP(DATE_SUB(NOW(),INTERVAL 10 MINUTE))*1000;
But I can’t figure out how to get the other stats out.
Many thanks,
Ben.