Step 1 - Set up a Service Account for Skype for Business (SfB)
Note: Requires (at least) version 4.3.x. of the Vyopta Data Collector.
The service account for this component will be added to three (3) SfB SQL Server databases, with read-only privileges. You must determine where the SfB SQL Server databases are located within your environment. Check with your SfB administrator or SQL DBA for more information. The steps for creating these service accounts may be carried out separately by that admin.
Note: For setup instructions using Windows Authentication for Skype for Business, please contact Vyopta support at firstname.lastname@example.org.
Once you have identified where the SQL Server is located, you must verify that the server has Microsoft SQL Server Management Studio or download that software application to your local computer. To create a service account on the SfB SQL Server, perform the following:
- Using SQL Server Management Studio, connect to the database used by SfB.
- Log in with a SQL Server Administrator account or Local Administrator account.
Note: The administrator account must have write privileges to create a service account.
- Navigate to the Security > Logins folder.
- Right click on the Logins folder and choose New Login, which should display the following:
Figure 10-1: SQL User Creation Screen
- Create a local database user account with the following information:
- Fill in the Login Name. We recommend using a descriptive name like vyopta_svc, as has been done in this example.
- Select SQL Server Authentication.
- Assign a Password and confirm the password.
- Uncheck Enforce Password Policy.
- Select User Mapping in the left-hand column.
- Select the LcsCDR database to provide the account access to the database.
- Once the database has been selected, you must identify the role membership. Select the db_datareader and public
- Repeat steps 12 and 13 for the QoEMetrics & xds databases in the database List.
- Click OK to create the user.
Figure 10-2: SQL User Role Mapping Screen
- You will need to identify the Instance Name of the SQL Server hosting the Skype for Business database that will be the target of the Vyopta Data Collector. Your database administrator may be able to provide this information directly, or you can perform the following:
a. Open the Microsoft SQL Server Configuration Manager application and select the SQL Server Services tab as displayed below:
Figure 10-3: SQL Server Configuration Manager
b. Identify the Instance Name of the SQL Server hosting the SfB Database. In the example above the SQL Server Instance Name is RTC.
c. Document this information to use in adding the SfB Connector.
You have now created a new database read-only user account on the SfB database. This account is configured to be a service account for use when setting up data collection to SfB in the Vyopta Admin Portal.
Step 2 - Setup Microsoft Skype for Business Realtime (only required for CPM monitoring)
This step is not required for analytics and reporting of Skype meetings and participants and can be added later if live monitoring of Skype meetings is desired. Skip to Step 3 if you are not adding a Microsoft Skype for Business SDN Interface at this time.
Note: Skype for Business CPM Monitoring requires at least version 4.3.x of the Vyopta Data Collector and version 2.4.1 of Microsoft Skype for Business SDN. For more information about SDN see the Deploying Skype for Business SDN Interface documentation published by Microsoft.
If your organization meets these requirements above, please contact email@example.com or your dedicated Sales Account Manager for more information.
Microsoft Skype for Business SDN Interface Online Resources
- Deploying Skype for Business SDN Interface
- Installing Skype for Business SDN Interface
- Configuring Skype for Business SDN Interface
To add a Microsoft Skype for Business CPM Monitoring requires the following:
- Microsoft Skype for Business SDN Interface must be installed, configured and deployed you’re your existing production SfB environment.
- If SDN is operational, please ensure that QoS is operational by running the following command on the Skype for Business server:
PS C:> Get-CsMediaConfiguration
… which should return a set of values where it can be verified that:
EnableInCallQoS : True
- After verifying the QoS, please ensure that QoE is operational by running the following command on the Skype for Business server:
PS C:> Get-CsQoEConfiguration
… which should return a set of values where it can be verified that:
EnableQoE : True
- If either of these values are ‘false’ then set to ‘true’ by running the following:
Set-CsMediaConfiguration –EnableQoS $true –EnableInCallQoS $True
- Log into the SDN Manager and run the following commands from command line:
a. Set ‘hidepii’ to False:
SDNManager.exe /p m hidepii=False
b. Configure the SDN manager to send SDN logs to Vyopta Subscriber:
SDNManager.exe /p s Vyopta submituri=http://<datacollector_ip_or_fqdn>:22280/adr/skype
c. Add additional SDN manager commands for Vyopta Subscriber:
SDNManager.exe /p s Vyopta signaling=True
SDNManager.exe /p s Vyopta sendrawsdp=True
- Additionally, verify that the XDS database has the same permissions as the QoE and LcsCDR databases as noted in steps 1-14 of section 10.1.
Step 3 - Add a Microsoft Skype for Business Connector
Note: For setup instructions using Windows Authentication for Skype for Business, please contact Vyopta support at firstname.lastname@example.org. This requires (at least) version 4.3.x of the Vyopta Data Collector.
To add a Microsoft Skype for Business Server Connector requires the following:
- Access to the FQDN/IP address of the Server hosting the Skype for Business SQL Databases from the Vyopta Data Collector
- Credentials for the Microsoft SQL Server service account created in the previous section
- Knowledge of the SQL port type (static or dynamic) and if dynamic, the port value defined within Microsoft SQL Configuration Manager
- TCP/IP Connectivity enabled for the SQL Server within SQL Configuration Manager
Please follow the instructions below to add Microsoft Skype for Business:
- Login to the Vyopta Admin Portal as Administrator and continue to the Infrastructure screen
- Scroll to the bottom of your infrastructure list and select New Infrastructure
- Select +Skype
- Enter the Skype Host Details including the name of the system as you would like to see it displayed in Vyopta CPM.
- Enter the description. This can include the device type, location, and other unique identifiers.
- Enter the SQL Server Database Server hostname (or IP address).
Note: We recommend using hostname rather than IP as IP addresses are subject to change. It is also helpful to name the infrastructure in a 'friendly' or easily understood way.
- Leave the Port Number of the SQL Server blank (unless changed from the default value of 1433).
- Add the SQL database
- Add the LcsCDR SQL Server Instance Name and Database Name.
- Select whether the service account is set up as native to the databases or requires Windows authentication (if Windows authentication is required, contact Vyopta support).
- Enter the username and password of the Microsoft SQL Server service account created previously.
- If the Skype SQL database is using a different time zone from the Vyopta data collector server, enter the time zone. Otherwise, leave blank.
- Save the settings
- Click Validate to ensure that the Vyopta Data Collector application can connect to the LcsCDR
- If the connection to the LcsCDR database succeeds, expand the next section, QOE Database Settings
- Repeat the above steps for the QoEMetrics database (Note: the QoE Metrics database may reside on a separate SQL server instance. Check with your SfB Admin or SQL DBA as needed.)
- If the connection to the QoEMetrics database succeeds, expand the next section, XDS Database Settings
- Repeat the previous steps for the XDS database connection.
Microsoft Skype for Business Reference Table
Skype for Business
Version 2015 or above
Server IP/FQDN of S4B/Skype for Business database server/cluster responsible for reporting
Local read-only database account that has access to the ‘LcsCDR’, ‘QoEMetrics’ and ‘xds’ databases.
(required for CPM Monitoring support only)
Microsoft Skype for Business SDN 2.4.1
* Vyopta Data Collector to SQL database server/cluster
* Port can vary depending on customer environment; Exact port to be provided by Customer Skype for Business DBA team
Inbound from SDN Manager to TCP 22280 on the Vyopta Data Collector server which listens for incoming SfB real-time data