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

ClientVersions View

Returns information about the client software/devices used in a communication session.

ConferenceMessageCount View

Returns information about the number of messages sent by users in a conference.

Conferences View

Returns conference information, including start time, end time, and conference organizer.

ConferenceSessionDetails View

Returns session details for all conferencing sessions, including start and end time, user IDs, response codes, and diagnostic IDs.

ConferenceUris View

Returns information about conference URIs used in a conference

ErrorReport View

Returns information about errors that occurred during a session.

FileTransfers View

Returns information about file transfer sessions, including the file name and whether the transfer was accepted, rejected, or cancelled.

FocusJoinsAndLeaves View

Returns information about conference join and leave activities.

McuJoinsAndLeaves View

Returns combined information about conference join and leave activities (each conference join is paired with the corresponding conference leave).

Mcus View

Returns information about Conferencing servers.

Media View

Returns information about the types of media used in peer-to-peer communication sessions.

ProgressReport View

Returns information about completed sessions.

Registration View

Returns information about registrations with Lync Server.

SessionDetails View

Returns information about peer-to-peer sessions, including VoIP-VoIP phone calls, two-party IM sessions, or other peer-to-peer communication sessions.

User View

Returns information about the users who have participated in communication sessions.

VoIPDetails View

Returns information for peer-to-peer sessions involving at least one VoIP (Voice over IO) user.