Kevin Kieller
Kevin Kieller is a partner with enableUC, a company that helps measure, monitor and improve UC and collaboration usage and...
Read Full Bio >>

Kevin Kieller | August 16, 2017 |


Sophisticated Skype: Detailed Usage and Adoption (Part 1)

Sophisticated Skype: Detailed Usage and Adoption (Part 1) Helping organizations get the most from their Skype for Business deployments

Helping organizations get the most from their Skype for Business deployments

I have written hundreds of articles offering advice both for organizations evaluating which UC&C solution best meets their needs and organizations seeking to succeed with a Skype for Business implementation in particular. However, a large and growing number of organizations now have adopted and implemented Skype for Business as their voice and collaboration solution.

This new "Sophisticated Skype" article series is intended to help these organizations get the most from their investments by exploring more complex solutions and opportunities available within the Skype for Business ecosystem.

For my first topic, I am going to tackle advanced reporting with Skype for Business, focusing on analyzing adoption within specific organizational groups.

Detailed Usage and Adoption
I define usage as the quantity of a service being consumed. Examples of usage statistics include number of IMs sent, the amount of bandwidth consumed, number of conference calls made, conferencing minutes, number of video calls made, etc.

Adoption represents who specifically is making use of a service. Adoption is focused on people -- i.e. how many users hosted a conference this month, how many users joined a conference, what percentage of a department made use of a service, who has stopped using a service, etc.

For both usage and adoption, trends over time are often more insightful than a simple point-in-time measurement.


A current client who is in the process of deploying Skype for Business to approximately 30,000 users was interested in detailed usage and adoption within a specific business unit. The standard reports provided by the Skype Monitoring Server role almost exclusively focus on usage and do not provide the ability to analyze usage for just one group of people.

The good news is that Skype for Business is one of the most "instrumented" products available. This means that a record of most interactions is tracked in terms of who, what, when, and quality. Unlike earlier versions of Lync, monitoring with Skype for Business Server does not require a separate server role. The monitoring service is built into each front end server, although monitoring is not enabled by default in Skype for Business Server. I would strongly recommend every on-premises Skype for Business implementation enable monitoring.

When enabled, the monitoring service stores call detail records and quality of experience information in two SQL databases: Lcs_cdr and QoE. The challenge is that the Lcs_cdr database contains 49 tables and 16 views, while the QoE database contains 54 tables, some for internal use only, and 6 views. In all, admins are faced with over a hundred places to look when trying to extract useful information -- challenging, but not impossible.

Note that both monitoring service databases keep track of only meta data on each communication session: who called who; which endpoints were used in the session; how long did the session last; what was the quality of the session; and so on. Skype for Business Server does not record and store the actual call itself. Similarly, the monitoring service does not capture instant messaging content; although Skype for Business Server records information about instant messaging sessions, it does not maintain a record of each instant message that was sent during the session. (Note: A separate optional archiving service can capture and retain instant message content.)

Reporting Usage and Adoption for a Group
To determine usage and adoption for a specific group of people, we need to do three things:

  1. Define who is in the group
  2. Extract the metrics only for the group members
  3. Format the results so that the raw data is transformed into actionable information

Step 1: Defining who is in the group

Data related to usage and adoption is almost exclusively captured in the Lcs_cdr database. However, the only information the Users table captures is the users' URI (aka SIP address). Unfortunately, this doesn't help us figure out which group (business unit or department) a specific user is in.

We need to create a new table with a list of people who are in the group we want to report on. Because we don't want to modify the production Lcs_cdr database, we chose to create a new database.I In my case, I called the database "enableUC" (my company name) and then created an SQL table that would contain members of the group as follows:


This creates a very simple table that contains a list of SIP addresses (aka email addresses) for the people in the group I want to report on.

I then populated the table by pasting in a list of SIP addresses using SQL Management Studio.

Step 2: Extract metrics for the group members

Users who have never used Skype for Business

To start, let's examine adoption of Skype for Business. Specifically, let's create a list of people in our target group who have never logged into Skype for Business. To do this, we look at the RegistrationView, which is part of the LcsCDR. The RegistrationView contains one row for each time a particular user connected to (signed into) Skype for Business. If a particular user has never used Skype for Business then there would be no rows in the RegistrationView corresponding to their SIP address. The SQL to create this list is as follows:


Users who have not used Skype within past three weeks

With a slight modification, we can also list users in our group who have not logged in within the past three weeks. Perhaps these users are on extended leave or maybe they have abandoned using Skype for Business:


Step 3: Format the results

The two queries above both return a list of users. The first list includes those who have never used Skype for Business and the second a list of users who have not used Skype for Business within the past three weeks. Follow-up should be directed at users on both lists. Perhaps additional communications or training is required. Maybe additional configuration is required to meet the needs of the users who have "abandoned" using Skype.

However, often a visual depiction is better than a list. In this case, I choose to compare active users (those on neither list), with infrequent users (users on list two), with non-users (users on list one). To do this, I used Excel and pasted in the results from both queries along with the complete list of users in my business unit being studied (i.e. use EnableUC; Select * from UserGroups). I used the Excel COUNTA() function to tally the number of users in each list and then created a pie chart based on the results. Mine looked like this:


This becomes especially interesting when compared to results from another department group:


Comparing adoption across different groups within your organization will surely bring up questions around why certain groups have higher adoption than others. This should lead to asking more detailed questions such as:

  • Was the communication, training, and change management plan the same across both groups?
  • Did training attendance differ between the groups?
  • Was leadership support different? Did the leaders demonstrate adoption of Skype by example? (for instance, by calling people via Skype and by using Skype for all conferences)
  • Are there business process differences that make Skype a better match for one group over another?

Exploring the answers to questions such as the above can provide actionable insights that help you improve your Skype for Business deployment.

In part two, we will look at determining top conference organizers, top conference participants, and top AV users, as well as analyzing usage trends for our focus group.

I spend my time helping organizations and IT teams succeed implementing communication and collaboration systems, most often Skype for Business, and I am committed to helping you succeed. Quantified metrics through advanced reporting can be a valuable tool to help track adoption and usage. If you have specific questions please comment below, send me a tweet @kkieller, or message me on LinkedIn.

Follow Kevin Kieller on Twitter and Google+!
Kevin Kieller on Google+


October 24, 2018

With disparate workplaces and ever-expanding volumes of information to manage, the challenges for collaborating effectively are only intensifying. Many critical applications are not integrated, and

October 10, 2018

Businesses are growing across international borders quicker than ever, but scaling operations to follow suit can be a harder, longer process.

This webinar focuses on scaling your next-generat

September 26, 2018

Join Kevin Kieller, Microsoft UC&C expert, along with Ribbon Communications and Polycom, for an update on Microsoft Ignite, and a focus on critical things you need to know about your voice deployme

March 12, 2018
An effective E-911 implementation doesn't just happen; it takes a solid strategy. Tune in for tips from IT expert Irwin Lazar, of Nemertes Research.
March 9, 2018
IT consultant Steve Leaden lays out the whys and how-tos of getting the green light for your convergence strategy.
March 7, 2018
In advance of his speech tech tutorial at EC18, communications analyst Jon Arnold explores what voice means in a post-PBX world.
February 28, 2018
Voice engagement isn't about a simple phone call any longer, but rather a conversational experience that crosses from one channel to the next, as Daniel Hong, a VP and research director with Forrester....
February 16, 2018
What trends and technologies should you be up on for your contact center? Sheila McGee-Smith, Contact Center & Customer Experience track chair for Enterprise Connect 2018, gives us the lowdown.
February 9, 2018
Melanie Turek, VP of connected work research at Frost & Sullivan, walks us through key components -- and sticking points -- of customer-oriented digital transformation projects.
February 2, 2018
UC consultant Marty Parker has crunched lots of numbers evaluating UC options; tune in for what he's learned and tips for your own analysis.
January 26, 2018
Don't miss out on the fun! Organizer Alan Quayle shares details of his pre-Enterprise Connect hackathon, TADHack-mini '18, showcasing programmable communications.
December 20, 2017
Kevin Kieller, partner with enableUC, provides advice on how to move forward with your Skype for Business and Teams deployments.
December 20, 2017
Zeus Kerravala, principal analyst with ZK Research, shares his perspective on artificial intelligence and the future of team collaboration.
December 20, 2017
Delanda Coleman, Microsoft senior marketing manager, explains the Teams vision and shares use case examples.
November 30, 2017
With a ruling on the FCC's proposed order to dismantle the Open Internet Order expected this month, communications technology attorney Martha Buyer walks us through what's at stake.
October 23, 2017
Wondering which Office 365 collaboration tool to use when? Get quick pointers from CBT Nuggets instructor Simona Millham.
September 22, 2017
In this podcast, we explore the future of work with Robert Brown, AVP of the Cognizant Center for the Future of Work, who helps us answer the question, "What do we do when machines do everything?"
September 8, 2017
Greg Collins, a technology analyst and strategist with Exact Ventures, delivers a status report on 5G implementation plans and tells enterprises why they shouldn't wait to move ahead on potential use ....
August 25, 2017
Find out what business considerations are driving the SIP trunking market today, and learn a bit about how satisfied enterprises are with their providers. We talk with John Malone, president of The Ea....
August 16, 2017
World Vision U.S. is finding lots of goodness in RingCentral's cloud communications service, but as Randy Boyd, infrastructure architect at the global humanitarian nonprofit, tells us, he and his team....
August 11, 2017
Alicia Gee, director of unified communications at Sutter Physician Services, oversees the technical team supporting a 1,000-agent contact center running on Genesys PureConnect. She catches us up on th....
August 4, 2017
Andrew Prokop, communications evangelist with Arrow Systems Integration, has lately been working on integrating enterprise communications into Internet of Things ecosystems. He shares examples and off....
July 27, 2017
Industry watcher Elka Popova, a Frost & Sullivan program director, shares her perspective on this acquisition, discussing Mitel's market positioning, why the move makes sense, and more.
July 14, 2017
Lantre Barr, founder and CEO of Blacc Spot Media, urges any enterprise that's been on the fence about integrating real-time communications into business workflows to jump off and get started. Tune and....
June 28, 2017
Communications expert Tsahi Levent-Levi, author of the popular blog, keeps a running tally and comprehensive overview of communications platform-as-a-service offerings in his "Choosing a W....
June 9, 2017
If you think telecom expense management applies to nothing more than business phone lines, think again. Hyoun Park, founder and principal investigator with technology advisory Amalgam Insights, tells ....
June 2, 2017
Enterprises strategizing on mobility today, including for internal collaboration, don't have the luxury of learning as they go. Tony Rizzo, enterprise mobility specialist with Blue Hill Research, expl....
May 24, 2017
Mark Winther, head of IDC's global telecom consulting practice, gives us his take on how CPaaS providers evolve beyond the basic building blocks and address maturing enterprise needs.
May 18, 2017
Diane Myers, senior research director at IHS Markit, walks us through her 2017 UC-as-a-service report... and shares what might be to come in 2018.
April 28, 2017
Change isn't easy, but it is necessary. Tune in for advice and perspective from Zeus Kerravala, co-author of a "Digital Transformation for Dummies" special edition.
April 20, 2017
Robin Gareiss, president of Nemertes Research, shares insight gleaned from the firm's 12th annual UCC Total Cost of Operations study.
March 23, 2017
Tim Banting, of Current Analysis, gives us a peek into what the next three years will bring in advance of his Enterprise Connect session exploring the question: Will there be a new model for enterpris....
March 15, 2017
Andrew Prokop, communications evangelist with Arrow Systems Integration, discusses the evolving role of the all-important session border controller.
March 9, 2017
Organizer Alan Quayle gives us the lowdown on programmable communications and all you need to know about participating in this pre-Enterprise Connect hackathon.
March 3, 2017
From protecting against new vulnerabilities to keeping security assessments up to date, security consultant Mark Collier shares tips on how best to protect your UC systems.
February 24, 2017
UC analyst Blair Pleasant sorts through the myriad cloud architectural models underlying UCaaS and CCaaS offerings, and explains why knowing the differences matter.
February 17, 2017
From the most basics of basics to the hidden gotchas, UC consultant Melissa Swartz helps demystify the complex world of SIP trunking.
February 7, 2017
UC&C consultant Kevin Kieller, a partner at enableUC, shares pointers for making the right architectural choices for your Skype for Business deployment.
February 1, 2017
Elka Popova, a Frost & Sullivan program director, shares a status report on the UCaaS market today and offers her perspective on what large enterprises need before committing to UC in the cloud.
January 26, 2017
Andrew Davis, co-founder of Wainhouse Research and chair of the Video track at Enterprise Connect 2017, sorts through the myriad cloud video service options and shares how to tell if your choice is en....
January 23, 2017
Sheila McGee-Smith, Contact Center/Customer Experience track chair for Enterprise Connect 2017, tells us what we need to know about the role cloud software is playing in contact centers today.