[cisco-voip] Jabber Conversation Logging

[Karl Smith]

No Probs mate ☺

Glad to help!

From: avholloway at gmail.com [mailto:avholloway at gmail.com] On Behalf Of Anthony Holloway
Sent: 20 August 2014 15:45
To: Karl Smith
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Jabber Conversation Logging

Doh! I forgot about that simply because I have only read about it and never deployed it.

Thanks for steering me in the right direction.

On Wednesday, August 20, 2014, Karl Smith <ksmith at block.co.uk<mailto:ksmith at block.co.uk>> wrote:
Hi Anthony,

The way to centralise all the data is to setup an external PostgreSQL database on your imp server.

This will write all data to this database which then can be queried.

Thanks,
Karl


From: avholloway at gmail.com<javascript:_e(%7B%7D,'cvml','avholloway at gmail.com');> [mailto:avholloway at gmail.com<javascript:_e(%7B%7D,'cvml','avholloway at gmail.com');>] On Behalf Of Anthony Holloway
Sent: 19 August 2014 22:28
To: Karl Smith
Cc: cisco-voip at puck.nether.net<javascript:_e(%7B%7D,'cvml','cisco-voip at puck.nether.net');>
Subject: Re: [cisco-voip] Jabber Conversation Logging

Karl,

I took a quick look in to this when Matthew first asked, just to see what I could whip up, and what I saw was a local folder on my Windows PC, with files that were encoded in sqllite v3 format.

Windows 8.1 Folder: C:\Users\anthony\AppData\Local\Cisco\Unified Communications\Jabber\CSF\History

I downloaded SQLiteBrowser (http://sqlitebrowser.org/) and then open the file: anthony at mydomain.com.db<javascript:_e(%7B%7D,'cvml','anthony at mydomain.com.db');>.

From this DB, the tables: history_item and history_participant looked to be what I need to generate a pretty report.

So, now I'm thinking about how I would have a web browser load this data locally on the client machine without server side help, so that viewing chat history can be done offline.

Am I on the right track?  What can you share publicly about your own solution?

Thanks.

On Mon, Aug 18, 2014 at 5:02 AM, Karl Smith <ksmith at block.co.uk<javascript:_e(%7B%7D,'cvml','ksmith at block.co.uk');>> wrote:
Hi Matthew,

We have a self created web application which allows you to view Jabber logs via a webpage.

There are 4 different search types in our solution, Username, Date, Word/Phrase and Conversation. Conversation works via a unique conversation id that Jabber assigns to each conversation.

If you have any questions do not hesitate to get in contact.

Regards
Karl Smith
Unified Workspace Engineer

ǀ BLOCK ǀ
Cisco UK&I Solution Innovation Partner of the Year FY15
Visit our new dedicated Healthcare site at www.block.co.uk/health<http://www.block-solutions.net/health>

D   +44 (0) 1270 446759<tel:%2B44%20%280%29%201270%20446759>
F    +44 (0) 844 9671642<tel:%2B44%20%280%29%20844%209671642>



M  +44 (0) 772 0548903<tel:%2B44%20%280%29%20772%200548903>
W  www.block<http://www.block-solutions.net/>.co.uk<http://co.uk>

Click to follow us on
[Description: Description: Description: cid:image007.png at 01CD2E9F.09589350]<http://www.linkedin.com/companies/151857>   [Description: Description: Description: cid:image008.png at 01CD2E9F.09589350] <http://twitter.com/BlockSolutions>    [Description: Description: Description: cid:image009.jpg at 01CD2E9F.09589350] <http://www.block-solutions.net/blog/>


_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<javascript:_e(%7B%7D,'cvml','cisco-voip at puck.nether.net');>
https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140820/9344242f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3900 bytes
Desc: image001.png
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140820/9344242f/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 3661 bytes
Desc: image002.png
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140820/9344242f/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 4048 bytes
Desc: image003.png
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140820/9344242f/attachment-0002.png>