VoipDetails table in Lync Server 2013
Topic Last Modified: 2012-09-28
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 Lync Server 2013 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 Lync Server 2013 for more information. |
FromNumberId |
int |
Foreign |
PhoneId of the caller. See the Phones table in Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013 for more information. |
ToMediationServerId |
int |
Foreign |
The Mediation Server called is going to. See the MediationServers table in Lync Server 2013 for more information. |
FromGatewayId |
int |
Foreign |
Gateway the call is coming from. See the Gateways table in Lync Server 2013 for more information. |
ToGatewayId |
int |
Foreign |
Gateway the call is going to. See the Gateways table in Lync Server 2013 for more information. |
DisconnectedbyURIId |
int |
Foreign |
URI of the user who disconnected the call, if the user has a URI. See the Users table in Lync Server 2013 for more information. |
DisconnectedbyPhoneId |
int |
Foreign |
ID of the phone that disconnected the call was disconnected from a phone. See the Phones table in Lync Server 2013 for more information. |