[cisco-voip] Jabber Conversation Logging

[Anthony Holloway]

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.

>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> 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
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140819/7c0b39af/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: BEADB938-5D5F-4494-86D5-14CE792DBB25.png
Type: image/png
Size: 3900 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140819/7c0b39af/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 84EFD6CF-059E-4C7C-AAF4-B26AD6A10969.png
Type: image/png
Size: 4048 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140819/7c0b39af/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: D5DFF335-7904-41EF-A419-5B011D417FF0.png
Type: image/png
Size: 3661 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140819/7c0b39af/attachment-0002.png>