This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 89%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
I have been looking at the tables, views and procedures that are collecting Skype Call Quality data and I am finding values in the SessionDetails.MediaTypes columns that are NOT listed in the online documentation (https://learn.microsoft.com/en-us/skypeforbusiness/schema-reference/call-detail-recording-cdr-database-schema/sessiondetails)
The latter lists the following as possible values for this column: 1, 2, 4, 8, 16, 32 & 64
However, in our Production data I am also seeing the following values: 0, 3, 48, 136 & 168. I do not find any instances of 4, 32 or 64.
When I join the SessionDetails to the Media and MediaList tables (as some of the procedures do), I get the below combinations, where MediaType is from the Media column in MediaList and MediaTypes is the value from SessionDetails column with the same name
MediaType MediaTypes
Application Sharing 8
Application Sharing 136
Application Sharing 168
Audio 16
Audio 48
File Transfer 2
File Transfer 3
IM 1
IM 3
p2p: 0
Video 48
Video 168
Does the documentation need to be updated?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 24%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Hi!
Thanks for your feedback!
Indeed, there is no information about the special parameter "136","168" and so on.
Based on research,when we have operations include IM and App invite,without any exception or other operations in this progress, the MediaType will be the 65.However,if have some exception or other operation in this progress ,the MediaType will changed. I think this is the reason why the documents not added these value in it.
I don't suppose the docs will get updated? ;-)
In fact, we can try use the SQL to look for the media mean, so it is not necessary to update these values in docs.
select v.MediaTypes,v.Media,* from LcsCDR.dbo.MediaView v where v.MediaTypes=136 ;
select v.MediaTypes,v.Media,* from LcsCDR.dbo.MediaView v where v.MediaTypes=168 ;