Monitoring reports in Lync/Skype for Business Server provide insights to the user activity, user logon details, call diagnostic information and media quality statistics. It uses SQL Server Reporting Services (SRSS) to provide all these information and query the Quality of Experience (QoE) and Call Detail Recording (CDR) databases to fetch the information. You can use web url ” http://serverfqdn:80/ReportServer_ServerNetBIOS ” to access the monitoring reports via web browser. It provides many different format options (such as XML, EXCEL, PDF, CSV, WORD etc.) to save/export the reports based on your requirement.
Prerequisite: You should have Front End Pool deployed with Monitoring Server components.
To deploy monitoring reports, go to the Deployment Wizard and run “Deploy Monitoring Reports”
Select Monitoring database and specify SRSS instance.
Specify the credentials to access the monitoring database, I’m using service account which was used to deploy the sql server.
Specify the user group who need read only access to these reports. You can use RTCUniversalReadOnlyAdmin group to assign the access.
All the reports will be deployed in a sequence and you can see the task status as “Completed”. Click on Finish and now you can use the web url to access the reports.
Note: You have deployed monitoring reports successfully if you are using either standard edition server or Enterprise edition pool with SQL failover cluster. Otherwise you need to run the same process one more time if you are using SQL mirror, follow the same process but make sure when deploying reports on mirror server on that time you have to initiate a failover so that the mirror server can become principal otherwise you will get error.