Topic Last Modified: 2012-10-03

Views cover the most common scenarios for returning data from the QoE SQL database. It is recommended views used for building custom reports instead of directly accessing the database tables; that’s because views are more likely to maintain backwards compatibility with future releases.

View Name Description

AudioStreamDetail View

Stores information about each audio stream in the database.

MediaLine View

Stores information about each media line in the database. One audio session typically contains one audio media line. One audio and video (A/V) session typically contains one audio media line and one video media line; however, the session might contain two video media lines if a conferencing device is used or if Gallery View is used.

NetworkConfigurationSettings View

Stores information about the network configuration.

Session View

Stores information about sessions that have records in the database.

UserAgent View

Stores information about the user agents that have been involved in sessions that have records in the database.

VideoStreamDetail View

Stores information about each video stream in the database.