• Article

Step 6: Deploy QoE Monitoring Server Reports (Recommended)

Microsoft Office Communications Server 2007 and Microsoft Office Communications Server 2007 R2 will reach end of support on January 9, 2018. To stay supported, you will need to upgrade. For more information, see Resources to help you upgrade your Office 2007 servers and clients.

The QoE Monitoring Server Report Pack contains a set of standard reports that are published by Microsoft SQL Server 2005 Reporting Services. The reports are made available by a Web site that is published by the Report Manager.

After you have started your services for your QoE Monitoring Server, you can deploy the QoE Monitoring Server Report Pack to an instance of the Microsoft SQL Server 2005 Reporting Services. This step is optional.

Note

To deploy the QoE Monitoring Server Report Pack, the account that you are logged on with must be assigned to the Content Manager role of the Reporting Services instance that you will deploy the report pack to. For details about assigning users to a SQL Report Services role, see Creating, Modifying, and Deleting Role Assignments at https://r.office.microsoft.com/r/rlidOCS?clid=1033&p1=SQLRoleAssign.

To deploy QoE Monitoring Server Reports

  1. In the Deployment Wizard, at Step 6: Deploy QoE Monitoring Server Reports, click Run.

  2. On the Welcome to the QoE Monitoring Server Report Pack Deployment Wizard page, click Next.

  3. On the Specify Report Pack Account page, enter the name of a new or existing service account to use for this server, and then enter the password for the account. The default account is RTCQMSReportPack. For a new account, ensure that you use a strong password that meets the Active Directory password requirements of your organization. When you are finished, click Next.

  4. On the Report Pack Configuration page, enter the URL of the reporting server. Click Next to continue.

    Warning

    If you are publishing the reports to an HTTPS Web site, you must use the FQDN of the QoE Monitoring Server within the URL. Before you deploy the report pack, ensure that Require client certificate is disabled for the Web site. After you have finished deploying the report pack, you can re-enable Require client certificate if you want.

  5. On the Authorize Group page, you can use the Domain group box to grant read-only access, or you can manually configure read-only access. To do so, click the domain, type the name of the group that is to be granted read-only access to reports, and then click Next. Alternatively, you can manually configure read-only access after you have deployed the report pack, as described following this procedure.

    Note

    If the QoE Monitoring Server report pack is deployed onto a SQL Server Reporting Server that is in a different domain in the forest, then domain local groups cannot be used to grant read-only access. In this case, only global or universal groups can be used.

    Warning

    Members of this domain group will be granted read-only access to personal identifying information, such as the URIs and phone numbers of callers and callees, in the A/V metric reports.

  6. On the Ready to Deploy Report Pack page, click Next.

  7. When the wizard has completed, select the View the log when you click Finish check box, and then click Finish.

  8. In the log file, verify that <Success> appears under the Execution Result column. Look for <Success> at the end of each task to verify that the report pack was deployed. When you are finished, close the log window.

You can now view reports by using the Reporting Services instance that you specified in the wizard. The format of the URL will be http://<fqdn>/reportserver?%2fQmsReport. For example, if the FQDN of your report server is qoe.contoso.com and you are using the HTTPS protocol, the URL will be https://qoe.contoso.com/reportserver?%2fQmsReport.

Note

Because the reporting server uses a different service account than that for the QoE Monitoring Server, you will need to ensure that you change the passwords of both the reporting server and QoE Monitoring Server accounts after they expire.
In addition to the service accounts, the data source of the QoE Monitoring Server report pack uses stored credentials to access the QoE Monitoring database. When the password is changed in this account, the stored credentials of the data source must also be updated. The data source of the report pack can be found in the QMSReport folder of the report pack. To access, open http(s)://<FQDN>/Reports.

To manually configure read-only access to reports

  1. At the URL that you specified on the Report Pack Configuration page during the previous procedure, open the SQL Reporting Services page.

  2. Click the QMSReport folder.

  3. Click the Properties tab.

  4. Click Security.

  5. Click New Role Assignment.

  6. In the New Role Assignment dialog box, type the name of the group or user to whom you want to provide read-only access in the Group or user name box.

  7. Select the QMS Browser check box, and then click OK.