Monitoring Chat Log

Openfire Openfire Support
1

Where i found chat log from monitoring plugin ?

Thanks.

2

They are stored in the database.

3

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: 1.3.2.27 $
4

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
where
(fromJID like 'first.person@im.somewhere.org%'
and toJID like ‘second.person@im.somewhere.org%’)
OR
(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