VoipDetails table
Each record represents one two-party call in which at least one user is a VoIP user.
| Column | Data Type | Key/Index | Details |
|---|---|---|---|
| SessionIdTime |
datetime |
Primary |
Time of session request. Used with SessionIdSeq to uniquely identify a session. For more information, see the Dialogs table in Skype for Business Server 2015 for more. |
| SessionIdSeq |
int |
Primary |
ID number to identify the session. Used with SessionIdTime to uniquely identify a session. For more information, see the Dialogs table in Skype for Business Server 2015. |
| FromNumberId |
int |
Foreign |
PhoneId of the caller. For more information, see the Phones table. If not NULL and FromGatewayId isn't NULL, then the caller was a PSTN user. |
| ConnectedNumberId |
int |
Foreign |
PhoneId of the call receiver. For more information, see the Phones table. If not NULL and ToGatewayId isn't NULL, then the call receiver was a PSTN user. |
| FromMediationServerId |
int |
Foreign |
The Mediation Server the call is coming from. For more information, see the MediationServers table. |
| ToMediationServerId |
int |
Foreign |
The Mediation Server called is going to. See the MediationServers table for more information. |
| FromGatewayId |
int |
Foreign |
Gateway the call is coming from. For more information, see the Gateways table in Skype for Business Server 2015. |
| ToGatewayId |
int |
Foreign |
Gateway the call is going to. See the Gateways table in Skype for Business Server 2015 for more information. |
| DisconnectedbyURIId |
int |
Foreign |
URI of the user who disconnected the call, if the user has a URI. See the Users table for more information. |
| DisconnectedbyPhoneId |
int |
Foreign |
ID of the phone that disconnected the call was disconnected from a phone. See the Phones table for more information. |
| LastModifiedTime |
Datetime |
For internal use by the Monitoring service. This field was introduced in Skype for Business Server 2015. |