How to Extract the IM transcripts from Jabber database

[Asad Hanif]

Hello Everyone,

Just wondering is there way we can extract the IM user transcripts from the Jabber database? We have a postgreSQL DB that is setup to journal all IM’s I want to know how I can extract the IM conversations.

it is not about deleting the record it is about extracting the user chat history from the database.

Thanks,

Asad Hanif

[garethpeart]

I am sure that someone will come by with some great SQL skills to make this easier, but in the meantime here's what I do:

Download the PGAdmin tool and connect it to your postgreSQL DB. Go to the Graphical Query Builder and chose Schemas > Public> jm  From there, check box the tables you want (body_string is the actual text)and then run the query.

Again, this is the quick and dirty version I've been using for testing, but it does the trick.

Gareth