Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

How to Extract the IM transcripts from Jabber database

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

1 REPLY
Bronze

How to Extract the IM transcripts from Jabber database

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

417
Views
0
Helpful
1
Replies
CreatePlease to create content