Thursday, May 30, 2013

Retrieving Lync Mobile device IM’s from Archiving Server

Due to limitations in Exchange and Lync integration, conversations and calls from a Lync Mobile device cannot be saved to the user’s Microsoft Exchange mailbox. Only calls and conversations from that particular device are displayed on the Conversations tab in the Lync Mobile client. Therefore, these conversations and calls don’t appear in the Outlook conversation history folder. No method currently exists to synchronize this data.

Ref: http://support.microsoft.com/kb/2806019/EN-US


So, how can you retrieve these IM’s? Well the workaround is to use the Lync Server Management Shell cmdlet “Export-CsArchivingData”.


Command:
Export-CsArchivingData –DBInstance sqlservername\sql instance name –StartDate "m/d/year" –EndDate "m/d/year " –OutputFolder "C:\Logs"

Example:
Export-CsArchivingData –DBInstance Lync-SQL-01\LyncArchiving –StartDate "3/1/2012" –EndDate "5/31/2012" OutputFolder "C:\Logs"


Note: The exported files in your c:\Logs folder will be listed with an .eml extension. You can open these files with an e-mail client. You can also rename the files with an .mht extension and view them with Internet Explorer.

-or-

You can run this from the SQL server backend Database


Click on "new query"


In the SQLquery1.sql window type the following:

Type: USE LcsLog <enter>
Type: GO <enter>
Type: SELECT * FROM Messages <enter>
Then click Execute (on menu)

From results, scroll over to the body column to view the results.
You can then export to XML for viewing.


Additional inks:

http://technet.microsoft.com/en-us/magazine/hh328432.aspx
http://blogs.technet.com/b/csps/archive/2011/04/14/haiku089.aspx