Standard reports included in Lync Server 2013 cover information on system usage, peer-to-peer sessions, conferencing sessions, and call quality. We will talk about some of them in the following paragraphs. However, in addition to the previously mentioned reports, we can also create custom reports based on the reporting data we are already gathering. Customizing reports is an important step to obtain information that fits better with our needs. We will see how to create a custom report that contains information on the time when users joined and left a conference.
Note that we could receive a request to download the report builder.
Reports_Content
folder to access the available Lync data. The selected data source screen is displayed in the following screenshot:A good starting point to write custom reports is the TechNet documentation that outlines the call detail recording (CDR) database schema (http://technet.microsoft.com/en-us/library/gg398570.aspx) and Quality of Experience (QoE) database schema in Lync Server 2013 (http://technet.microsoft.com/en-us/library/gg398687.aspx). Some of the most important views of the CDR database (suggested in the Lync Conference presentation that is already mentioned) are Conferences, ConferenceSessionDetails, Registration, SessionDetails, and VoIPDetails, while for the QoE database, we have AudioStreamDetail, MediaLine, QoEReportsCallDetail, Session, and VideoStreamDetail.
Wesley Backelant has published a post in which he explores the use of PowerPivot as a tool to expand Lync monitoring. His work, Extending your Lync monitoring data using PowerPivot and Power View, is published at http://blogs.msdn.com/b/wesleyb/archive/2012/03/09/extending-your-lync-monitoring-data-using-powerpivot-and-power-view.aspx.
Iain Smith, in his blog, has dedicated an interesting post to custom reports in Lync Server 2013 (Lync 2013 – Creating Custom Lync Reports within Monitoring at http://northernlync.wordpress.com/2014/03/10/lync-2013-creating-custom-lync-reports-within-monitoring/).
Doug Deitterick made available a sample report dedicated to archiving (Sample Lync Server Archiving Report Available at http://blogs.technet.com/b/dodeitte/archive/2013/06/02/sample-lync-server-archiving-report-available.aspx).
18.218.3.204