Accessing Lync Online Archiving and Monitoring Data
Topic Last Modified: 2013-06-26
When your organization subscribes to the Lync Online archiving and monitoring feature you can request the ability to connect directly to the daily snapshots of your archiving and monitoring data on Microsoft SQL Server. These snapshots enable your organization to do its own custom reporting against the data.
The snapshots display the prior 60 days of data and are read-only copies of the production databases that are recreated daily. You have the ability to give permissions to specific users in your organization for access to this data. Connectivity to the databases is secured using SSL. Standard SQL connectivity tools such as the Open Database Connectivity specification (ODBC), SQL Management Studio, and Microsoft Office and can be used for data access.
The intended audience for the information in this topic is SQL Administrators or database administrators who are comfortable with querying data from SQL databases. For additional guidance, see Database Schemas and Additional Resources.
Daily snapshots of the following databases are available for read-only access:
Archiving (LcsLog). This database contains archives of peer-to-peer and multiparty instant messages.
Monitoring Server (QoEMetrics and LcsCDR). The Lync Monitoring Server role collects data about the quality of your network media on your network endpoints and about usage information related to audio/video sessions, instant messages (IM), meetings, application sharing, and file transfers. This information can help you provide the best possible media experience for your users. The monitoring server also collects call error records (CERs), which you can use to troubleshoot failed calls. Additionally, it collects usage information in the form of call detail records (CDRs) about various Lync Server features so that you can calculate return on investment of your deployment and plan the future growth of your deployment.
Microsoft already provides several reports for reviewing monitoring data. Access is provided to these monitoring server databases to enable you to get deeper insight as needed.
For additional information about Lync Online archiving and monitoring data access, see the following resources.
Microsoft Lync Server 2010 Resource Kit: See Chapter_02_Archiving_and_Monitoring_R1.doc.
Note: The Lync 2010 archiving database schema is not published publicly. The Communications Server 2007 R2 schema is very similar to what Lync offers with a few variations in column names