[cisco-voip] Jabber Conversation Logging

[Anthony Holloway]

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> 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
>
> F    +44 (0) 844 9671642
>
>
>
>
>
> M  +44 (0) 772 0548903
>
> W  www.block <http://www.block-solutions.net/>.co.uk
>
> Click to follow us on
>
> [image: Description: Description: Description:
> cid:image007.png at 01CD2E9F.09589350]
> <http://www.linkedin.com/companies/151857>   [image: Description:
> Description: Description: cid:image008.png at 01CD2E9F.09589350]
> <http://twitter.com/BlockSolutions>   [image: 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/0c8a1c26/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 4048 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140820/0c8a1c26/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 3661 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140820/0c8a1c26/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3900 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140820/0c8a1c26/attachment-0002.png>