SHARE



ABOUT THE AUTHOR


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 >>
SHARE



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.





COMMENTS



Enterprise Connect Orlando 2018
March 12-15 | Orlando, FL

Connect with the Entire Enterprise Communications & Collaboration Ecosystem


Stay Up-to-Date: Hear industry visionaries in Keynotes and General Sessions delivering the latest insight on UC, mobility, collaboration and cloud

Grow Your Network: Connect with the largest gathering of enterprise IT and business leaders and influencers

Learn From Industry Leaders: Attend a full range of Conference Sessions, Free Programs and Special Events

Evaluate All Your Options: Engage with 190+ of the leading equipment, software and service providers

Have Fun! Mingle with sponsors, exhibitors, attendees, guest speakers and industry players during evening receptions

Register now with code NOJITTEREB to save $200 Off Advance Rates or get a FREE Expo Pass!

September 20, 2017

Customer experience can make or break your business. But how do you achieve outstanding customer service when you're dealing with outdated organizational structure, lagging technology, dated proces

August 16, 2017

Contact centers have long been at the leading edge of innovation in communications technology, given their promise of measurable ROI and the continual need to optimize customer interactions and sta

July 12, 2017

Enterprises have been migrating Unified Communications & Collaboration applications to datacenters - private clouds - for the past few years. With this move comes the opportunity to leverage da

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 BlogGeek.me 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.