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

Configuring MessageStats for Lync

•
Setting Up the Report Pack
•
Connecting to a Pool
•
Setting Properties for Voice Calls
•
Mapping Voice Routes to Call Types
•
Establishing Costs for Call Types
•
Configuring Call Routing
•
Identifying Federated Domains
•
Excluding Specific Users from Reports
•
Specifying Chargeback Costs for Sessions and Conferences
•
Creating an Lync or Skype for Business Server Gathering Task

Setting Up the Report Pack

Setting Up the Report Pack

The report pack collects information from an Skype for Business or Lync server through gathering tasks. Before you create a gathering task to collect the data, you must set up a connection to each Skype for Business or Lync CDR (Call Detail Recording) database instance from which you want to gather information. There should be only one database connection defined per Skype for Business or Lync pool.

After you have created a connection to the CDR database and, optionally, the Archiving database, you can create gathering tasks to collect information from the databases.

Connecting to a Pool

Connecting to a Pool

You must enter the Fully Qualified Domain Name (FQDN) of the Lync or Skype for Business pool, or the standard edition server, and set up a connection to the Archiving and CDR SQL database instances from which you want to retrieve data. You can also connect to a pool using one of its fully-qualified DNS aliases.

For Lync Server 2010, Microsoft has introduced different kinds of pools: front-end pools, A/V conferencing pools, mediation pools, and edge pools. When you are connecting to a Lync Server pool, the pool name refers to the name of the front-end pool.

Prerequisite

When you set up the initial connection to the Archiving and CDR SQL Server databases, you must specify a SQL authentication account and password. The SQL account is required to perform gatherings from the CDR and Archiving databases and must have the following database role memberships in the CDR and Archiving databases:

•
db_datareader
•
public
To set SQL database roles for a user account
1
Using the SQL Server Management Studio, select Security | Logins.
2
Select a user account.
3
Right-click and select Properties.
4
Select User Mapping and select the Lync or Skype for Business database to be mapped (LcsCDR or LcsLog).
5
In the database role memberships list, select db_datareader and public.
Once you have specified the appropriate rights for the SQL user account, you can open the MessageStats console and create the connection to your Lync or Skype for Business Server CDR or Archiving database.To connect to the pool and the CDR SQL database
1
Open the MessageStats Console.
2
Expand the console treeview and select the Lync & Skype for Business Server node.
3
Right-click and select Connect to Pool.
4
Enter the Skype for Business or Lync Pool Name.
Enter either the Fully Qualified Domain Name (FQDN) or a fully-qualified DNS alias for the pool. Ensure that you specify the front-end pool.
a
If you have configured a separate archiving database, select the Use Archive Database check box.
5
In the CDR Database Connection Details section, select the server from the Server Name list.
- OR -
Enter the server name for your Archiving and/or CDR SQL server.
If the database is on an SQL instance other than the default instance such as for standard edition servers, you must specify the server name as server name/instance name.
6
Enter the SQL account name and password to be used to access the CDR database.
SQL Authentication must be enabled on the server on which the report pack is installed and also on the Microsoft Skype for Business or Lync SQL server to which you are connecting.
7
Select the SQL database name for the CDR database from the list.
•
You can also select a custom database that you set up when you enabled the Archiving and CDR Server Role.
8
If you have a separate archiving database, enter the appropriate server, database, and credential information in the Archive Database Connection Details section.
a
To use the same server and credentials as for the CDR database connection, select Use CDR Database Connection Details.
9
Click Apply.
10
Click OK.
The pools to which you are connected are displayed in the treeview in the MessageStats console.
To disconnect from a pool
1
Right-click the Skype for Business or Lync pool name in the treeview from which you want to disconnect.
2
Click Disconnect.
3
Click Yes in the Are you sure you want to disconnect dialog box.

Modifying Connection Pool Properties

If you want to change the connection information for an Skype for Business or Lync pool, you can access the information through the pool properties.

To modify connection information for a pool
1
Right-click the Skype for Business or Lync Server pool name in the treeview and select Properties.
2
On the Pool Properties tab, make the changes that you want. For information about entering information for a pool connection, see Connecting to a Pool .
3
Click Apply.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating