No Probs mate ☺ Glad to help!
From: avhollo...@gmail.com [mailto:avhollo...@gmail.com] On Behalf Of Anthony Holloway Sent: 20 August 2014 15:45 To: Karl Smith Cc: cisco-voip@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 <ksm...@block.co.uk<mailto:ksm...@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: avhollo...@gmail.com<javascript:_e(%7B%7D,'cvml','avhollo...@gmail.com');> [mailto:avhollo...@gmail.com<javascript:_e(%7B%7D,'cvml','avhollo...@gmail.com');>] On Behalf Of Anthony Holloway Sent: 19 August 2014 22:28 To: Karl Smith Cc: cisco-voip@puck.nether.net<javascript:_e(%7B%7D,'cvml','cisco-voip@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: anth...@mydomain.com.db<javascript:_e(%7B%7D,'cvml','anth...@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 <ksm...@block.co.uk<javascript:_e(%7B%7D,'cvml','ksm...@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@01CD2E9F.09589350]<http://www.linkedin.com/companies/151857> [Description: Description: Description: cid:image008.png@01CD2E9F.09589350] <http://twitter.com/BlockSolutions> [Description: Description: Description: cid:image009.jpg@01CD2E9F.09589350] <http://www.block-solutions.net/blog/> _______________________________________________ cisco-voip mailing list cisco-voip@puck.nether.net<javascript:_e(%7B%7D,'cvml','cisco-voip@puck.nether.net');> https://puck.nether.net/mailman/listinfo/cisco-voip
_______________________________________________ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip