List of CDR views in Lync Server 2013
Topic Last Modified: 2012-10-01
Views provide an easy way to access information about the most common scenarios used for returning data from the CDR database. It is recommended that you use views for building custom reports instead of using the actual CDR database tables ; that’s because the database views are more likely to maintain backwards compatibility with future releases of Lync Server.
| View Name | Description |
|---|---|
Returns information about the client software/devices used in a communication session. |
|
Returns information about the number of messages sent by users in a conference. |
|
Returns conference information, including start time, end time, and conference organizer. |
|
Returns session details for all conferencing sessions, including start and end time, user IDs, response codes, and diagnostic IDs. |
|
Returns information about conference URIs used in a conference |
|
Returns information about errors that occurred during a session. |
|
Returns information about file transfer sessions, including the file name and whether the transfer was accepted, rejected, or cancelled. |
|
Returns information about conference join and leave activities. |
|
Returns combined information about conference join and leave activities (each conference join is paired with the corresponding conference leave). |
|
Returns information about Conferencing servers. |
|
Returns information about the types of media used in peer-to-peer communication sessions. |
|
Returns information about completed sessions. |
|
Returns information about registrations with Lync Server. |
|
Returns information about peer-to-peer sessions, including VoIP-VoIP phone calls, two-party IM sessions, or other peer-to-peer communication sessions. |
|
Returns information about the users who have participated in communication sessions. |
|
Returns information for peer-to-peer sessions involving at least one VoIP (Voice over IO) user. |