Chat now with support
Chat with Support

MessageStats 7.8.1 - Report Pack for Lync & Skype for Business User Guide

About This Guide Installing the Report Pack Configuring MessageStats for Lync Managing your Database Using the Lync and Skype for Business Reports Appendix A: Configuring RPC through a Firewall

Software requirements

You install the report pack components on servers on which the core MessageStats components are already installed. You must meet the software requirements for MessageStats. See the MessageStats Release Notes for the software requirements for the different MessageStats components.

The following table contains any additional requirements for the report pack:

 
Table 2. Minimum software requirements.
Type
Minimum requirement

Reports

IIS 8.0 or later is required. Also certain IIS roles services must be enabled. See the MessageStats Quick Start Guide for more information.

.NET

Microsoft .NET Framework 4.7.2

Additional Software
•
For the report pack installation, MessageStats 7.8.1 is required.

On the server that hosts the MessageStats task processors (Task Execution Server):

•
To gather from Microsoft Lync server or Skype for Business server, you must install PowerShell 2.0.

Lync and Skype for Business Environment

The Archiving and Monitoring (CDR) server roles or services must be enabled on your Skype for Business or Lync Server.

For information about installing and enabling Monitoring and Archiving, see the appropriate section:

•
Configuring Lync Server 2010
•
Configuring Lync Server 2013, Skype for Business 2015/2019
Report pack component correlation to core MessageStats components

The following table lists the additional software requirements for the report pack components. If you intend to install two components on one server, that server must meet the requirements for both components.

 
Table 3. Mapping report pack components to core MessageStats.
Component
Minimum requirement

Report Pack Database

MessageStats database 7.8.1

Report Pack Reports

MessageStats reports 7.8.1

Report Pack Task Processor

MessageStats task processors 7.8.1

MessageStats scheduler service 7.8.1

Report Pack Client Console

MessageStats MMC client console 7.8.1

Required Rights and Permissions

This section lists the rights and permissions that are required to install either the report pack or the stand-alone product. Operational rights are required to gather information and to render the reports.

Installation Rights

The following rights are required to install the report pack and the stand-along product:

•
Be a member of the Administrators local group on the computer on which the report pack is to be installed.
•
Be a member of the MessageStats Admin local group on the server that hosts the MessageStats database.
Operational Rights

Operational rights are grouped by function in this section. However, you can assign more than one group of rights to a single account, such as the MessageStats service account.

The following rights are required to connect to the Lync or Skype for Business server databases and to gather information from the databases.

Required by account that runs the MessageStats Console

The account that is running the MessageStats console must:

•
Have the sysadmin role on the SQL server that hosts the MessageStats database. The sysadmin role is needed to add the Lync or Skype for Business Server Archiving and CDR database servers as linked database servers to the MessageStats database.
•
In the MessageStats console, when you set up the initial connection to the Lync or Skype for Business Server Archiving and CDR SQL Server databases, you must also specify a SQL Authentication account and password.
The SQL account must have the following database role memberships in the Skype for Business and Lync CDR and Archiving databases:
•
db_datareader
•
public
For more information see To set SQL database roles for a user account .
Required by account that runs the gathering tasks

The account that is used to run the gathering tasks must meet the following requirements:

•
Be a member of the MessageStats Admin local group on the SQL server that hosts the MessageStats database.
•
Be able to use Windows Authentication to connect to the MessageStats database.
•
Have local Administrator rights on the MessageStats task execution server
•
For Lync Server, the account used to run the gathering tasks must be assigned the CsViewOnlyAdministrator role (be a member of the CS View-Only Administrators group in Active Directory).
•
Optional: Have local Administrators rights on all Lync or Skype for Business servers and on the Lync or Skype for Business Backend SQL Server.
The local Administrators rights are needed to populate the following three fields in the Server Inventory report: IP Address, Lync or Skype for Business Server version, and Server OS. If local Administrator rights are not assigned, the fields will display as Not Available in the report.
For the Database Management Functions

To use the Database Management features in a distributed installation, one of the following accounts must have the sysadmin fixed server role on the SQL server that hosts the MessageStats database:

•
the MessageStats service account
- OR -
•
the account currently logged into the MessageStats console
Required by account used to view reports

An account that is used to render the reports must be a member of the MessageStats Web administrative group on the server that hosts the MessageStats database.

Configuring Lync Server 2010

Microsoft Lync Server gathers statistical data through the Monitoring and Archiving roles and from Active Directory. To view data from Lync server in the MessageStats reports, you must install and enable the Monitoring and Archiving server roles on your Lync server.

The procedures are divided into the following parts:

1. Adding the SQL Store for Monitoring
2. Installing the Monitoring and Archiving Roles
3. Enabling Call Detail Recording (CDR)
4. Enabling and Configuring Archiving (Optional)
5. Starting the Monitoring and Archiving Services

1. Adding the SQL Store for Monitoring

As a prerequisite, you must have created a SQL instance which will be used to store the monitoring and archiving records. Then you can add your instance to the SQL store in Topology Builder.

To add the SQL store used for monitoring and archiving
1
In the Lync Topology Builder, select SQL Store | New SQL Store.
2
Enter the FQDN for the SQL Server and the SQL instance name (if you are not using the default instance).
3
Verify that the new store appears under the SQL stores folder.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating