Hello,

I understand you can access Lync archiving data via powershell, however, I am looking for a way to access the archive data programmatically.

Is there an API to access Lync archiving data stored in the Sql database?

If not, what do you do to access it? Access the database directly?

Is this (http://technet.microsoft.com/en-us/library/dd572568(office.13).aspx) still valid archiving database schema for Lync 2010 and 2013 (for some reason, it is not listed under Lync 2013 database schema reference link)? 

My second question, with Lync 2013, one can choose to archive Lync data to Exchange 2013. Is there a way to tell which user is archived to Exchange 2013 vs to Sql database? An archive policy somewhere, perhaps?

• Edited by Blackfield Wednesday, January 15, 2014 11:06 PM

Hi,

If you deploy Archiving using the Microsoft Exchange integration option, Lync archive data is stored with Exchange 2013 compliance data only for the users who are homed on your Exchange 2013 servers.

SQL Server database storage for Archiving supports users who are not homed on Exchange 2013 servers, or if you do not want to use the Microsoft Exchange integration option, you must deploy Archiving storage using a SQL Server database

More details:

http://technet.microsoft.com/en-us/library/jj205059.aspx

http://technet.microsoft.com/en-us/library/jj204900.aspx

Best Regards,

Eason Huang

You can use the following Lync cmdlet to export all users where archiving storage in not Exchange to text file: Get-CsUser | Where-Object {$_.ExchangeArchivingPolicy eq "Uninitialized"} | Select-Object SipAddress > c:\LyncAchiving.txt

Also, take a look at Export-CsArchivingData cmdlet: http://technet.microsoft.com/en-us/library/gg398452.aspx

.

Drago

Hi,

If you deploy Archiving using the Microsoft Exchange integration option, Lync archive data is stored with Exchange 2013 compliance data only for the users who are homed on your Exchange 2013 servers.

SQL Server database storage for Archiving supports users who are not homed on Exchange 2013 servers, or if you do not want to use the Microsoft Exchange integration option, you must deploy Archiving storage using a SQL Server database

More details:

http://technet.microsoft.com/en-us/library/jj205059.aspx

http://technet.microsoft.com/en-us/library/jj204900.aspx

Best Regards,

Eason Huang

You can use the following Lync cmdlet to export all users where archiving storage in not Exchange to text file:Get-CsUser | Where-Object {$_.ExchangeArchivingPolicy eq "Uninitialized"} | Select-Object SipAddress > c:\LyncAchiving.txt

Also, take a look at Export-CsArchivingData cmdlet: http://technet.microsoft.com/en-us/library/gg398452.aspx

.

I guess I had to start with "To answer your second question..." As for the first, even Smarch (Lync archiving solution) uses Export-CsArchivingData to export to .eml and pump it to their database... If there was API, they would have know about it...

.

Drago