Microsoft’s Call Quality Dashboard (CQD) is an reporting tool for the quality of calls made using Microsoft Teams and Skype for Business services. It’s available by for Skype for Business Online and Microsoft Teams, and can be deployed separately for Skype for Business Server.
Call Quality Dashboard (CQD) is designed to help Skype for Business admins and network engineers optimize a network. CQD shifts focus from specific users and instead looks at aggregate information for an entire Skype for Business organization.
This blog will focus primarily on the Online version, which is available at the short URL of tom.qa/CQD. To enable it for the first time follow this blog post.
Data is taken from Skype for Business Online and Microsoft Teams and put into a SAAS Cube (SQL Server Analysis Services). Reports are accessed from a web portal.
In Microsoft SQL Server Analysis Services, dimensions and measures are a fundamental component of cubes.
- Dimensions organize data with relation to an area of interest, such as customers, stores, or employees, to users.
- Measures represents a column that contains quantifiable data, usually numeric, that can be aggregated. Measures represent some aspect of organizational activity, expressed in monetary terms (such as revenue, margins, or costs) or as counts (inventory levels, number of employees, customers, or orders), or as a more complex calculation that incorporates business logic.
Dimensions
The following table lists the dimensions currently available in CQD. The First and Second classification is separate from which endpoint is the caller or callee. The First Is Caller dimension which can be used to help identify which endpoint was the caller or callee.
- First Network
- First Network Name
- First Network Range
- First Building Name
- First Ownership Type
- First Building Type
- First Building Office Type
- First City
- First Zip Code
- First Country
- First State
- First Region
- First Express Route
- Second Network
- Second Network Name
- Second Network Range
- Second Building Name
- Second Ownership Type
- Second Building Type
- Second Building Office Type
- Second City
- Second Zip Code
- Second Country
- Second State
- Second Region
- Second Express Route
- First Inside Corp
- Second Inside Corp
- First Tenant Id
- Second Tenant Id
- First Pool
- Second Pool
- Is Federated
- QoE Record Available
- CDR Record Available
- Media Line Label
- Media Type
- First Is Server
- Second Is Server
- First Is Caller – True if the first endpoint was the caller (initiated the session establishment)
- First Network Connection Detail
- Second Network Connection Detail
- Stream Direction
- Payload Description
- Audio and Video Call
- Duration 5 seconds or less
- Duration 60 seconds or more
- Duration (Seconds)
- Duration (Minutes)
- EndTime
- Year
- Month
- Day
- Hour
- Minute
- Second
- Day Of Year
- Day Of Week
- Day Number Of Week
- Month Year
- Full Month
- First Domain
- Second Domain
- First User Agent Category
- Second User Agent Category
- First User Agent
- Second User Agent
- Conference Type
- Conference Id
- First Client App Version
- Second Client App Version
- Transport
- First Connectivity Ice
- Second Connectivity Ice
- First IP Address
- Second IP Address
- First Link Speed
- Second Link Speed
- First Port
- Second Port
- First Reflexive Local IP
- Second Reflexive Local IP
- First Relay IP
- Second Relay IP
- First Relay Port
- Second Relay Port
- First Subnet
- Second Subnet
- First VPN
- Second VPN
- Applied Bandwidth Source
- Bandwidth Est
- Mediation Server Bypass Flag
- First Cdr Connectivity Type
- Second Cdr Connectivity Type
- First Capture Dev
- Second Capture Dev
- First Capture Dev Driver
- Second Capture Dev Driver
- First Render Dev
- Second Render Dev
- First Render Dev Driver
- Second Render Dev Driver
- First CPU Name
- Second CPU Name
- First CPU Number Of Cores
- Second CPU Number Of Cores
- First CPU Processor Speed
- Second CPU Processor Speed
- First Endpoint
- Second Endpoint
- First OS
- Second OS
- First OS Filtered
- Second OS Filtered
- First OS Architecture
- Second OS Architecture
- First Virtualization Flag
- Second Virtualization Flag
- First Wifi Microsoft Driver
- Second Wifi Microsoft Driver
- First Wifi Vendor Driver
- Second Wifi Vendor Driver
- First Wifi Microsoft Driver Version
- Second Wifi Microsoft Driver Version
- First Wifi Vendor Driver Version
- Second Wifi Vendor Driver Version
- First Wifi Channel
- Second Wifi Channel
- First Wifi Radio Type
- Second Wifi Radio Type
- First DNS Suffix
- Second DNS Suffix
- First Wifi Band
- Second Wifi Band
- First Wifi Signal Strength
- Second Wifi Signal Strength
- First Wifi Battery Charge
- Second Wifi Battery Charge
- Audio Degradation Avg
- Jitter
- Jitter Max
- Packet Loss Rate
- Packet Loss Rate Max
- Overall Avg Network MOS
- Ratio Concealed Samples Avg
- Ratio Stretched Samples Avg
- Round Trip
- Round Trip Max
- Network Jitter Avg
- Video Post FECPLR
- Video Local Frame Loss Percentage Avg
- Recv Frame Rate Average
- Low Frame Rate Call Percent
- Low Resolution Call Percent
- Video Packet Loss Rate
- Video Frame Rate Avg
- Dynamic Capability Percent
- Spoiled Tile Percent Total
- AppSharing Relative OneWay Average
- AppSharing RDP Tile Processing Latency Average
- Audio FEC Used
- ClassifiedPoorCall
- Video Poor Due To VideoPostFecplr
- Video Poor Due To Video Local Frame Loss Percentage Avg
- Video Poor Due To Recv Frame Rate Average
- Video Poor Due To Low Frame Rate Call Percent
- Video Poor Due To Low Resolution Call Percent
- Video Poor Due To Video Packet Loss Rate
- Video Poor Due To Video Frame Rate Avg
- Video Poor Due To Dynamic Capability Percent
- VBSS Poor Due To Video Post Fec plr
- VBSS Poor Due To Video Local Frame Loss Percentage Avg
- VBSS Poor Due To Recv Frame Rate Average
- VBSS Poor Due To Low Frame Rate Call Percent
- VBSS Poor Due To LowResolutionCallPercent
- AppSharing Poor Due To Spoiled Tile Percent Total
- AppSharing Poor Due To Relative OneWay Average
- AppSharing Poor Due To RDP Tile Processing Latency Average
- Audio Poor Due To Jitter
- Audio Poor Due To RoundTrip
- Audio Poor Due To Packet Loss
- Audio Poor Due To Degradation
- Audio Poor Due To Concealed Ratio
- Unclassified
- OnePercent PacketLoss
- Poor Reason
- Poor
- Good
- First Feedback Rating
- Second Feedback Rating
- First Feedback Tokens
- Second Feedback Tokens
- First Feedback Has Audio Issue
- Second Feedback Has Audio Issue
- First Feedback Has Video Issue
- Second Feedback Has Video Issue
- First Echo Event Causes
- Second Echo Event Causes
- First Echo Percent Mic In
- Second Echo Percent Mic In
- First Echo Percent Send
- Second Echo Percent Send
- First Send Signal Level
- Second Send Signal Level
- First Recv Signal Level
- Second Recv Signal Level
- First Send Noise Level
- Second Send Noise Level
- First Recv Noise Level
- Second Recv Noise Level
- First Network Send Quality Event Ratio
- Second Network Send Quality Event Ratio
- First Network Receive Quality Event Ratio
- Second Network Receive Quality Event Ratio
- First Network Delay Event Ratio
- Second Network Delay Event Ratio
- First Network Bandwidth Low Event Ratio
- Second Network Bandwidth Low Event Ratio
- First CPU Insufficient Event Ratio
- Second CPU Insufficient Event Ratio
- First Device Half Duplex AEC Event Ratio
- Second Device Half Duplex AEC Event Ratio
- First Device Render Not Functioning Event Ratio
- Second Device Render Not Functioning Event Ratio
- First Device Capture Not Functioning Event Ratio
- Second Device Capture Not Functioning Event Ratio
- First Device Glitches Event Ratio
- Second Device Glitches Event Ratio
- First Device Low SNR Event Ratio
- Second Device Low SNR Event Ratio
- First Device Low Speech Level Event Ratio
- Second Device Low Speech Level Event Ratio
- First Device Clipping Event Ratio
- Second Device Clipping Event Ratio
- First Device Echo Event Ratio
- Second Device Echo Event Ratio
- First Device Near End To Echo Ratio Event Ratio
- Second Device Near End To Echo Ratio Event Ratio
- First Device Render Zero Volume Event Ratio
- Second Device Render Zero Volume Event Ratio
- First Device Render Mute Event Ratio
- Second Device Render Mute Event Ratio
- First Device Multiple Endpoints Event Count
- Second Device Multiple Endpoints Event Count
- First Device Howling Event Count
- Second Device Howling Event Count
- Error Report Sender
- Is Media Error
- Media Failure Type
- Rtp Rtcp Mux
- Stun Version
- Media Relay
- Call Setup Failure Reason
- Is Anonymous Join Session
- Has Media Diag Blob
- Used Dns Resolve Cache
- Network Connection Detail Pair
- User Agent Category Pair
- Is Server Pair
- Connectivity Ice Pair
- OS Pair
- Tenant Id Pair
- Building Name Pair
- Inside Corp Pair
- Scenario Pair
- IsTeams
Measures:
- Total Stream Count
- Audio Stream Count
- AppSharing Stream Count
- Video Stream Count
- VBSS Stream Count
- Audio Poor Stream Count
- Audio Good Stream Count
- Audio Unclassified Stream Count
- Audio Poor Percentage
- Audio OnePercent PacketLoss Count
- Audio OnePercent PacketLoss Percentage
- Audio Poor Due To Jitter Count
- Audio Poor Due To PacketLoss Count
- Audio Poor Due To Degradation Count
- Audio Poor Due To RoundTrip Count
- Audio Poor Due To ConcealedRatio Count
- AppSharing Poor Due To SpoiledTilePercentTotal Count
- AppSharing Poor Due To RelativeOneWayAverage Count
- AppSharing Poor Due To RDPTileProcessingLatencyAverage Count
- Video Poor Due To VideoPostFecplr Count
- Video Poor Due To VideoLocalFrameLossPercentageAvg Count
- Video Poor Due To RecvFrameRateAverage Count
- Video Poor Due To LowFrameRateCallPercent Count
- Video Poor Due To LowResolutionCallPercent Count
- Video Poor Due To VideoPacketLossRate Count
- Video Poor Due To VideoFrameRateAvg Count
- Video Poor Due To DynamicCapabilityPercent Count
- VBSS Poor Due To VideoPostFecplr Count
- VBSS Poor Due To VideoLocalFrameLossPercentageAvg Count
- VBSS Poor Due To RecvFrameRateAverage Count
- VBSS Poor Due To LowFrameRateCallPercent Count
- VBSS Poor Due To LowResolutionCallPercent Count
- Video Poor Stream Count
- Video Good Stream Count
- Video Unclassified Stream Count
- Video Poor Percentage
- AppSharing Poor Stream Count
- AppSharing Good Stream Count
- AppSharing Unclassified Stream Count
- AppSharing Poor Percentage
- VBSS Poor Stream Count
- VBSS Good Stream Count
- VBSS Unclassified Stream Count
- VBSS Poor Percentage
- Avg Call Duration
- First Feedback Rating Avg
- Second Feedback Rating Avg
- First Feedback Rating Count
- Second Feedback Rating Count
- First Feedback Rating Poor Count
- Second Feedback Rating Poor Count
- First Feedback Rating Poor Percentage
- Second Feedback Rating Poor Percentage
- First Feedback Token Audio Issue Count
- Second Feedback Token Audio Issue Count
- First Feedback Token Video Issue Count
- Second Feedback Token Video Issue Count
- Audio SLA Good Call Count
- Audio SLA Poor Call Count
- Audio SLA Call Count
- Audio SLA Good Call Percentage
- Audio Good Call Stream Count
- Audio Poor Call Stream Count
- Audio Unclassified Call Stream Count
- Audio Poor Call Percentage
- Avg First Echo Percent Mic In
- Avg Second Echo Percent Mic In
- Avg First Echo Percent Send
- Avg Second Echo Percent Send
- Avg First Audio Send Signal Level
- Avg Second Audio Send Signal Level
- Avg First Audio Recv Signal Level
- Avg Second Audio Recv Signal Level
- Avg First Audio Send Noise Level
- Avg Second Audio Send Noise Level
- Avg First Audio Recv Noise Level
- Avg Second Audio Recv Noise Level
- First Audio Echo BAD_TIMESTAMP Count
- First Audio Echo POSTAEC_ECHO Count
- First Audio Echo EVENT_ANLP Count
- First Audio Echo EVENT_DNLP Count
- First Audio Echo MIC_CLIPPING Count
- First Audio Echo BAD_STATE Count
- Second Audio Echo BAD_TIMESTAMP Count
- Second Audio Echo POSTAEC_ECHO Count
- Second Audio Echo EVENT_ANLP Count
- Second Audio Echo EVENT_DNLP Count
- Second Audio Echo MIC_CLIPPING Count
- Second Audio Echo BAD_STATE Count
- Total Call Setup Failed Stream Count
- Total Call Dropped Stream Count
- Total Media Failed Stream Count
- Total Media Succeeded Stream Count
- Total Call Setup Succeeded Stream Count
- Total Call Setup Failure Percentage
- Total Call Dropped Failure Percentage
- Total Answer Seizure Ratio
- Total Short Call Percentage
- Total Media Failure Percentage
- Avg Audio Degradation
- Avg Jitter
- Avg Jitter Max
- Avg Packet Loss Rate
- Avg Packet Loss Rate Max
- Avg Overall Avg Network MOS
- Avg Ratio Concealed Samples
- Avg Ratio Stretched Samples
- Avg Round Trip
- Avg Round Trip Max
- Avg Network Jitter
- Avg Video Post FECPLR
- Avg Video Local Frame Loss Percentage
- Avg Video Recv Frame Rate Average
- Avg Video Low Frame Rate Call Percent
- Avg Video Low Resolution Call Percent
- Avg Video Packet Loss Rate
- Avg Video Frame Rate
- Avg Video Dynamic Capability Percent
- Avg AppSharing Spoiled Tile Percent Total
- Avg AppSharing Relative OneWay
- Avg AppSharing RDP Tile Processing Latency
- Media Failed Due To Firewall IP Blocked Stream Count
- Firewall IP Blocked Media Failure Percentage
- Media Failed Due To Firewall DPI Stream Count
- Firewall DPI Media Failure Percentage
References:
Hello Tom,
Thanks for the article. I have been looking at these reports but I have got following issues.
1) Reports only provide First and second user. but what if there were 10 people in a session.
2) Some of dimensions provided don’t tell us which party this dimension was for example Avg Jitter and Avg packet Loss. The session may not be P2P. In the case of MCU all the clients on the session will have different value for Jitter, Packet Loss etc.