Microsoft Lync Server 2010 Guide: Using Monitoring Server Reports
Microsoft Lync Server 2010
Published: July 2011
This document is provided “as-is”. Information and views expressed in this document, including URL and other Internet Web site references, may change without notice.
Some examples depicted herein are provided for illustration only and are fictitious. No real association or connection is intended or should be inferred.
This document does not provide you with any legal rights to any intellectual property in any Microsoft product. You may copy and use this document for your internal, reference purposes.
Copyright © 2011 Microsoft Corporation. All rights reserved.
Microsoft, Active Directory, ActiveSync, ActiveX, DirectX, Excel, Forefront, Groove, Hyper-V, Internet Explorer, Lync, MSDN, MSN, OneNote, Outlook, PowerPoint, RoundTable, SharePoint, Silverlight, SQL Server, Visio, Visual C++, Visual Studio, Windows, Windows Live, Windows Media, Windows PowerShell, Windows Server, and Windows Vista, are trademarks of the Microsoft group of companies. All other trademarks are property of their respective owners.
Contents
Using Monitoring Server Reports
System Usage Reports
User Registration Report
Peer-to-Peer Activity Summary Report
Peer-to-Peer IM Report
Peer-to-Peer Voice and Video Report
Conference Summary Report
Conference Activity Report
PSTN Conference Summary Report
Response Group Usage Report
Response Group Call List Report
IP Phone Inventory Report
Call Admission Control Report
Peer-to-Peer Session Detail Report
Call Diagnostic Reports (per user)
User Activity Report
Call Diagnostic Reports
Call Diagnostic Summary Report
Peer-to-Peer Activity Diagnostic Report
Conference Diagnostic Report
Top Failures Report
Failure Distribution Report
Failure List Report
Diagnostic Report
Media Quality Diagnostic Reports
Media Quality Summary Report
Server Performance Report
Location Report
Device Report
Call List Report
Call Detail Report
Microsoft Lync Server 2010 Guide: Using Monitoring Server Reports
Using Monitoring Server Reports
Monitoring Server contains a set of standard reports that are published by Microsoft SQL Server Reporting Service. These reports, which are accessible by using a web browser, provide usage, call diagnostic information, and media quality information, all based on call detail recording (CDR) and Quality of Experience (QoE) records stored in the CDR and QoE databases.
Note that, in order to use these reports, you must install Monitoring Server reports on a computer that is running an instance of the SQL Server. For details, see Deploying Monitoring Server Reports.
In This Section
System Usage ReportsThe System Usage Reports provide system usage information based on CDR data collected by the Monitoring Server.
Call Diagnostic Reports (per user)The Call Diagnostic Reports provide per-user information about failed peer-to-peer and conferencing sessions.
Call Diagnostic ReportsThe Call Diagnostic Reports provide summary information and diagnostic data for failed peer-to-peer and conferencing sessions.
Media Quality Diagnostic ReportsThe Media Quality Diagnostic Reports provide information about call quality as well as diagnostic and troubleshooting information for failed calls.
Locating Records
Monitoring Server Reports only show a limited number of records on the screen at any one time. The actual number of records displayed on a screen varies depending on the report. To view the records that are not currently shown on the screen you can use the standard forward and backward control (found on each report’s toolbar) that enable you to page through the data. You can also quickly jump to the first page or the last page of the dataset.
In addition to using the forward and backward controls, you can also jump to any page in the dataset simply by typing the page number in the Current Page box and then pressing ENTER.
In addition to providing the ability to page through the data, each report also includes the limited ability to find records. To find records based on a given value, type that value into the Find box and then click Find. The report begins searching through the data and stops on the first instance of the value that you entered in the Find box. To find the next record that meets the search criteria, click Next.
As noted, the Monitoring Server Reports provide only the most basic search functions. For example, you cannot specify which field the value should be found in. The search mechanism will automatically hunt for matching values in every field in every record. You cannot use wildcards in your searches, and all searches will look for partial values. That means that if you search for 111 the search will find not only the value 111 but also the values 11100, 811, 3112, 611A5B, and any other fields that include the value 111 anywhere within that field.
Each report is configured to show a default set of records. For example, by default the User Registration Report shows user registration activities for the past week. In some cases, this might result in a report that returns no records. In this case, it means that no user registrations have taken place in the past week. If you see the message “No results match the report filters,” try changing the filter values (for example, change the time period to the past month rather than the past week) and rerun the query. For details, see the "Filtering Data" section later in this topic.
Filtering Data
There will likely be times when you want to look at only a subset of records. For example, only peer-to-peer sessions as opposed to both peer-to-peer sessions and conference sessions. Likewise, there will be times when you need to reduce the number of records that are returned. By default, a report can only display the first 1,000 records in a data set. To address these issues, most reports include a number of filtering options. For example, if you want to view only records for the time period January 1, 2011 through January 15, 2011 most reports allow you to enter January 1, 2011 in the From box and January 15, 2011 in the To box. If you then click View Report, the returned data will be limited to activities that took place between January 1, 2011 and January 15, 2011.
The filters available to you vary depending on the report that you are viewing. For details about a specific report, see the help topic for that report.
Exporting Data
The Monitoring Server Reports provide at least two different ways to export the data included in a report. For one, you can use the Export option in the toolbar that appears at the top of each report. To use this option, first select the desired export format from the Select a format drop-down list. The following formats are available to you:
XML file with report data
CSV (comma delimited)
Acrobat (PDF) file
MHTML (web archive)
Excel
TIFF file
Word
After selecting a format, click Export. When the File Download dialog box appears, click Save. In the Save As dialog box, select a destination folder, enter a file name, and then click Save.
If you have Microsoft OneNote installed, you can also copy the report data to OneNote. To do this, right-click the View Report button on the toolbar. In the Select Location in OneNote dialog box select the section in OneNote where you want to copy the data, and then click OK.
System Usage Reports
The System Usage Reports provide system usage information based on call detail recording (CDR) data collected by the Monitoring Server.
In This Section
User Registration ReportThe User Registration Report provides a summary of user connectivity to the Microsoft Lync Server 2010 deployment based on registration events such as user logons. The report provides a way to view both internal and external logons, and to compare the number of users who logged on to Lync Server 2010 with the number of users who actually used the service while they were logged on.
Peer-to-Peer Activity Summary ReportThe Peer-to-Peer Activity Summary Report provides a summary of peer-to-peer IM, audio, video, file transfer, and application sharing sessions. Peer-to-peer sessions are sessions involving just two users.
Conference Summary ReportThe Conference Summary Report provides a summary of all conference activities. Conferences are sessions involving three or more people.
PSTN Conference Summary ReportThe PSTN Conference Summary Report provides a summary of all PSTN conferences; these are conferences in which at least one user dials in using the public switched telephone network (PSTN). In Lync Server, this is also referred to as dial-in conferencing.
Response Group Usage ReportThe Response Group Usage Report provides a summary of Response Group usage. The Response Group application provides a way for you to automatically route phone calls to entities such as a help desk or customer support line.
IP Phone Inventory ReportThe IP Phone Inventory Report provides information about the IP phones currently in use in the organization. Note that the report is based on phone registrations and logons; it should not be considered a complete inventory. For example, you might have gotten rid of phones that are still listed in the report (because they logged on at least once). Likewise, you might also have newly-purchased phones that will not show up in the report simply because they have not yet been used to log on to Lync Server.
Call Admission Control ReportThe Call Admission Control Report provides a list of peer-to-peer and conference activities that use call admission control. Call admission control (CAC) is a way of determining whether you should allow real-time communications sessions, such as voice or video calls, based on bandwidth constraints.
User Registration Report
The User Registration Report provides a summary of user connectivity to the Microsoft Lync Server 2010 deployment based on registration events such as user logons. The report provides a way to view both internal and external logons, and to compare the number of users who logged on to Lync Server 2010 with the number of users who actually used Lync Server 2010 while they were logged on.
Filters
Filters provide a way for you to return a more finely-targeted set of data or to view the returned data in different ways. For example, the User Registration Report enables you to view data for all your Registrar pool and Edge Servers or to view data for an individual pool. You can also choose how data should be grouped. In this case, registrations grouped by hour, day, week, or month.
The following table lists the filters that you can use with the User Registration Report.
User Registration Report Filters
Name / DescriptionFrom / Start date/time for the time range. To view data by hours, enter both the start date and time as follows:
1/1/2011 1:00 PM
If you do not enter a start time, the report automatically begins at 12:00 AM on the specified day. To view data by day, enter just the date:
1/1/2011
To view by week or by month, enter a date that falls anywhere within the week or month that you want to view (you do not have to enter the first day of the week or month):
1/3/2011
Weeks always run from Sunday through Saturday.
To / End date/time for the time range. To view data by hours, enter both the end date and time as follows:
1/1/2011 1:00 PM
If you do not enter an end time, the report automatically ends at 12:00 AM on the specified day. To view data by day, enter just the date:
1/1/2011
To view by week or by month, enter a date that falls anywhere within the week or month that you want to view (you do not have to enter the first day of the week or month):
1/3/2011
Weeks always run from Sunday through Saturday.
Interval / Time interval. Select one of the following:
Hourly (a maximum of 25 hours can be displayed)
Daily (a maximum of 31 days can be displayed)
Weekly (a maximum of 12 weeks can be displayed)
Monthly (a maximum of 12 months can be displayed)
If the start and end dates exceed the maximum number of values allowed for the selected interval, only the maximum number of values (starting from the start date) are displayed. For example, if you select the Daily interval with a start date of 1/1/2011 and an end date of 2/28/2011, data is displayed for the days 8/1/2011 12:00 AM to 9/1/2011 12:00 AM (that is, a total of 31 days' worth of data).
Pool / Fully qualified domain name (FQDN) of the Registrar pool or Edge Server; you can either select an individual pool or choose [All] to view data for all the pools. This drop-down list is automatically populated for you based on the records in the database.
Metrics
The following table lists the information provided in the User Registration Report.
User Registration Report Metrics
Name / Can you sort on this item? / DescriptionHourly
Daily
Weekly
Monthly / No / Indicates the time interval that you selected on the filter toolbar. Where applicable, you can click a given time interval to view detailed information for that interval. For example, if you are using the Daily interval and you click 1/1/2011, you see an hourly breakdown of user registration activity for that date.
Total logons / No / Total number of successful logon sessions.
Internal logons / No / Total number of logons within the internal network.
External logons / No / Total number of logons from outside the internal network, using the Edge Server.
Unique logon users / No / Total number of users who had at least one logon session. A user who had multiple logon sessions counts as one user, the same as a person who had just a single logon session.
Unique active users / No / Total number of users who were involved in a peer-to-peer or conferencing session. A user who had multiple sessions counts as one user, the same as a person who had just a single session.
Peer-to-Peer Activity Summary Report
This Peer-to-Peer Activity Summary Report provides a summary of peer-to-peer IM, audio, video, file transfer, and application sharing sessions. Peer-to-peer sessions are sessions involving just two users.
Filters
Filters provide a way for you to return a more finely-targeted set of data or to view the returned data in different ways. For example, the Peer-to-Peer Activity Summary Report enables you to choose how data should be grouped. In this case, activity grouped by hour, day, week, or month.
The following table lists the filters that you can use with the Peer-to-Peer Activity Summary Report.
Peer-to-Peer Activity Summary Report Filters
Name / DescriptionFrom / Start date/time for the time range. To view data by hours, enter both the start date and time as follows:
1/1/2011 1:00 PM
If you do not enter a start time, the report automatically begins at 12:00 AM on the specified day. To view data by day, enter just the date:
1/1/2011
To view by week or by month, enter a date that falls anywhere within the week or month that you want to view (you do not have to enter the first day of the week or month):
1/3/2011
Weeks always run from Sunday through Saturday.
To / End date/time for the time range. To view data by hours, enter both the end date and time as follows:
1/1/2011 1:00 PM
If you do not enter an end time, the report automatically ends at 12:00 AM on the specified day. To view data by day, enter just the date:
1/1/2011
To view by week or by month, enter a date that falls anywhere within the week or month that you want to view (you do not have to enter the first day of the week or month):
1/3/2011
Weeks always run from Sunday through Saturday.
Interval / Time interval. Select one of the following:
Hourly (a maximum of 25 hours can be displayed)
Daily (a maximum of 31 days can be displayed)
Weekly (a maximum of 12 weeks can be displayed)
Monthly (a maximum of 12 months can be displayed)
If the start and end dates exceed the maximum number of values allowed for the selected interval, only the maximum number of values (starting from the start date) is displayed. For example, if you select the Daily interval with a start date of 1/1/2011 and an end date of 2/28/2011, data is displayed for the days 8/1/2011 12:00 AM to 9/1/2011 12:00 AM (that is, a total of 31 days' worth of data).
Metrics
The following table lists the information provided in the Peer-to-Peer Activity Summary Report.
Peer-to-Peer Activity Summary Report Metrics
Name / Can you sort on this item? / DescriptionHourly
Daily
Weekly
Monthly / No / Indicates the time interval that you selected on the filter toolbar. Where applicable, you can click a given time interval to view detailed information for that interval. For example, if you are using the Daily interval and you click 1/1/2011, you see an hourly breakdown of user registration activity for that date.
Total peer-to-peer sessions / No / Total number of peer-to-peer sessions conducted, regardless of session type.
Total peer-to-peer IM sessions / No / Total number of peer-to-peer instant messaging sessions. When you click this item, the report shows you the Peer-to-Peer IM Report for the selected time period.
Total peer-to-peer IM messages / No / Total number of instant messages sent in peer-to-peer sessions. When you click this item, the report shows you the Peer-to-Peer IM Report for the selected time period.
Total peer-to-peer audio sessions / No / Total number of peer-to-peer audio calls. When you click this field, the report shows you the Peer-to-Peer Voice and Video Report for the selected time period.
Total peer-to-peer audio session minutes / No / Total amount of time spent in peer-to-peer audio sessions. When you click this item, the report shows you the Peer-to-Peer Voice and Video Report for the selected time period.
Average peer-to-peer audio session minutes / No / Average amount of time spent in peer-to-peer audio sessions. Calculated by dividing the total audio session time by the total number of audio sessions.
Total peer-to-peer video sessions / No / Total number of peer-to-peer video calls. Note that video sessions are also counted as audio sessions: each video session is counted as one video session and one audio session. When you click this item, the report shows you the Peer-to-Peer Voice and Video Report for the selected time period.
Total peer-to-peer video session minutes / No / Total amount of time spent in peer-to-peer video sessions. When you click this item, the report shows you the Peer-to-Peer Voice and Video Report for the selected time period.
Average peer-to-peer video session minutes / No / Average amount of time spent in peer-to-peer video sessions. Calculated by dividing the total video session time by the total number of video sessions.
Total peer-to-peer file transfer sessions / No / Total number of peer-to-peer sessions that included file transfers.
Total peer-to-peer application sharing sessions / No / Total number of peer-to-peer sessions that included application sharing.
Peer-to-Peer IM Report