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

Pretty sure there is no way to do this by API. You would have to write a SQL query/view or report server report to display the information you are after.

This may be helpful - http://blogs.technet.com/b/dodeitte/archive/2013/06/02/sample-lync-server-archiving-report-available.aspx

"You can use both Microsoft Exchange integration and Lync Server 2013 Archiving databases if you want to use Microsoft Exchange integration for some but not all users in your deployment." - http://technet.microsoft.com/en-us/library/jj205225.aspx

You can refer to OCS schema as per http://social.technet.microsoft.com/Forums/lync/en-US/040fe255-79b3-4446-be62-9e11e981affa/ms-lync-archiving-schema

Hope that helps.

Pretty sure there is no way to do this by API. You would have to write a SQL query/view or report server report to display the information you are after.

This may be helpful - http://blogs.technet.com/b/dodeitte/archive/2013/06/02/sample-lync-server-archiving-report-available.aspx

"You can use both Microsoft Exchange integration and Lync Server 2013 Archiving databases if you want to use Microsoft Exchange integration for some but not all users in your deployment." - http://technet.microsoft.com/en-us/library/jj205225.aspx

You can refer to OCS schema as per http://social.technet.microsoft.com/Forums/lync/en-US/040fe255-79b3-4446-be62-9e11e981affa/ms-lync-archiving-schema

Hope that helps.