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 in conjunction with SessionIdSeq to uniquely identify a session. See the Dialogs table in Skype for Business Server 2015 for more information.
SessionIdSeq
int
Primary
ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. See the Dialogs table in Skype for Business Server 2015 for more information.
FromNumberId
int
Foreign
PhoneId of the caller. See the Phones table for more information. If not NULL and FromGatewayId is not NULL, then the caller was a PSTN user.
ConnectedNumberId
int
Foreign
PhoneId of the call receiver. See the Phones table for more information. If not NULL and ToGatewayId is not NULL, then the call receiver was a PSTN user.
FromMediationServerId
int
Foreign
The Mediation Server the call is coming from. See the MediationServers table for more information.
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. See the Gateways table in Skype for Business Server 2015 for more information.
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.