powered by Jive Software

Monitoring Chat Log

Where i found chat log from monitoring plugin ?


They are stored in the database.

Is there any table or procedure to delete log certain users or all users?

[EDIT] My Database is Mysql.

  • Client Version MySQL: mysqlnd 5.0.5-dev - 081106 - $Revision: $

ofConversation and ofMessageArchive.

Personally, when I’m exporting lots of into (ie, all conversations between two users for a specific time frame) I query as follows:

select fromJID, toJID, FROM_UNIXTIME(sentDate/1000), body
from ofMessageArchive
(fromJID like 'first.person@im.somewhere.org%'
and toJID like ‘second.person@im.somewhere.org%’)
(fromJID like 'second.person@im.somewhere.org%'
and toJID like ‘first.person@im.somewhere.org%’)

order by sentDate

I won’t explain the details, hopefully they’re self explanatory enough