Audit Cisco Jabber chats

[UnicefCUC]

My organization has a need to audit a particular user's Jabber chat history content.  I know where the history database is, but I need to be able to extract the chats from that database.  I read that SQLite can be used, but there is no supporting documentation as to how to retrieve the information from the database.

[Jaime Valencia]

https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/im_presence/database_setup/10_5_1/CUP0_BK_DA667F7C_00_database-setup-guide-imp-105/CUP0_BK_DA667F7C_00_database-setup-guide-imp-105_chapter_0100.html

[UnicefCUC]

Rather than accessing the external database, I only need to access the local call history for a particular user.  How can I extract the chats for that user from the user@org.db file?

[Stephanie Knoop]

Please see my post here.  If you are using a newer Jabber client, the local db files are encrypted and cannot be opened.  

https://community.cisco.com/t5/collaboration-applications/how-to-retrieve-the-chat-history-from-cisco-jabber-for-windows/td-p/2047248/page/2

[Eric Tucker]

Its not that difficult once you get the db file open, you will have to manually clean up the file once you copy the contents into an excel or notepad ++.

[Eric Tucker · Accepted solution]

http://ccnp-v.blogspot.com/2014/12/jabber-im-chat-log.html