MediaList table
The MediaList table is a static table that stores the list of various media types.
| Column | Data Type | Key/Index | Details |
|---|---|---|---|
| MediaId |
tinyint |
Primary |
Values: 1-7 |
| Media |
nvarchar(256) |
Static mapping of MediaID and Media values: 1 -- IM 2 - File Transfer 3 - Remote Assistance 4 - Application Sharing 5 -- Audio 6 -- Video 7 - App Invite |
If you are trying to determine the modality type for the values in LcsCDR.SessionDetailsView.MediaTypes, then you need to use the following Join snippet:
LEFT JOIN on Media.MediaId = MediaList.MediaId