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 28, 2017 |


Sophisticated Skype: Detailed Usage and Adoption (Part 2)

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

Helping organizations get the most from their Skype for Business deployments

In my previous post, "Sophisticated Skype: Detailed Usage and Adoption (Part 1)," I kicked off this new series by defining usage versus adoption and detailing how the Skype for Business monitoring service captures meta data related to every communication session in two databases: Lcs_cdr and QoE. I then explored queries that focused on adoption within a specific business unit.

As a reminder, I created a new UserGroups SQL table that maintains a list of SIP URIs (email addresses) for all the users I want to report on:

In this second part of the article, I'll continue to explore adoption metrics and then shift to examine usage trends related to our focus group.

Top Adopters
Understanding which users in a group are the top adopters of a new service can be helpful, as you can often cultivate these top adopters to champion the benefits of the new service.

Here's how we can identify the top Skype for Business conference participants in our target group:

Secret sauce (highlighted phrases): I exclude specific client types because they represent automated conferencing services and not actual users. COLLATE Latin1_General_BIN forces both databases to use the same collation sequence -- a fancy way to say we want both databases to sort uppercase, lowercase, and accented characters in the same way. Without this clause, your SQL statement may return an error.

The output from the above query is a list of users. I choose to format this using Excel into a report similar to...

Perhaps more interesting than top conference participants is the list of top conference organizers. Here's how we generate that list:

Secret sauce (highlighted phrases): As per above, I exclude specific client types because they represent automated conferencing services and not actual users. I then CONVERT() the duration of the specific conference to hour:minutes:seconds format. COLLATE Latin1_General_BIN forces both databases to use the same collation sequence; we want both databases to sort uppercase, lowercase, and accented characters in the same way. Without the COLLATE clause, the SQL statement may return an error.

Again, the output from this query is a list of users that I format using Excel:

Based on this data, we see most users in our target group have not organized a Skype conference. Does this indicate a need for further training or does this meet our expectations? Working with administrative assistants is almost always key to Skype for Business usage and adoption. Winning over executive admins is often key to influencing the leadership's perception of Skype.

We can identify the top audio or video callers in our focus group, with the following query:

Secret sauce (highlighted phrases): MediaType 16 is an audio call, 32 is a video call, and 48 (16 logical or 32) is an audio and video call. I then CONVERT() the duration of the specific conference to hour:minutes:seconds format. COLLATE Latin1_General_BIN forces both databases to use the same collation sequence; we want both databases to sort uppercase, lowercase, and accented characters in the same way. Without the COLLATE clause, the SQL statement may return an error.

This query generates a list of users who had the most number of minutes on a call and tallies the number of calls for each user in our focus group. For any of the "top" queries, you can add in the top x (see green highlight above) clause as part of the main SELECT statement in order to limit the list.

Usage Trends
So far we have analyzed point-in-time adoption metrics. However, adoption and usage trends over time is often a better indicator of whether we're moving in the right direction.

We can capture adoption trends by running the aforementioned queries on a weekly or monthly basis.

For usage trends, we can count the number of peer-to-peer sessions per week for our target group using the SessionDetails table, as follows:

Secret sauce (highlighted phrases): Most people believe SQL Server only locks database rows when rows are being INSERTed or UPDATEd. However, in order to ensure read consistency, SELECT statements can also try to lock database rows and indexes. Normally this is not a problem; however, in an active Skype environment where new rows are being inserted frequently without the WITH (NOLOCK) phrase, as highlighted in yellow above, the query may generate an error. MediaTypes is a bit- level field as per the comments; hence we use the logical and &.COLLATE Latin1_General_BIN to force both databases to use the same collation sequence.

The query above generates a weekly usage summary for IM sessions (Mediatypes 1), something like this:

I then paste these results into Excel and create a line graph:

I also add a trend line (the dotted line in the Excel graph above) to show if overall usage for the specific modality is increasing, decreasing, or remaining constant.

Quantifying Opinions
Before, during, and after a Skype for Business deployment you'll hear many opinions related to what should be done, what was done, and how successful the project was.

Customized queries exploring detailed usage and adoption across multiple groups in your organization can help move from debatable opinion to quantifiable fact. Quantified results allow you to identify real problems, take correct action, and measure the effectiveness of any of the undertaken actions.

If you have deployed Skye for Business, you should be producing detailed usage and adoption metrics.

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.


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.