question

BruceScarborough-1625 avatar image
0 Votes"
BruceScarborough-1625 asked JimmyYang-MSFT commented

Skype SessionDetails has MediaTypes values NOT listed in Documentation

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://docs.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?

office-skype-business-server-administrationoffice-skype-business-online-itprooffice-skype-business-server-itpro-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JimmyYang-MSFT avatar image
0 Votes"
JimmyYang-MSFT answered JimmyYang-MSFT commented

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I don't suppose the docs will get updated? ;-)

0 Votes 0 ·

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 ;

0 Votes 0 ·