Viewing Calls

Viewing Calls

Use Call Viewer to select calls made to a speech application and view the logged event data for those calls.

To open Call Viewer

  1. Click Start, click All Programs, and then select Microsoft Speech Application SDK 1.1.

  2. Select Log Analysis Tools, and then select Call Viewer.

Connecting to a Database

A Call Viewer database must be available to connect to. See the topic Importing Log Files for more information. The database connection string is displayed in the Database field on the Call Viewer toolbar.

To connect to a Call Viewer database
  1. In Call Viewer on the toolbar, click Edit.

  2. In the Edit Database Connection dialog box, in the SQL Server drop-down list box, select or enter the server name.

  3. In the Database drop-down list box, select or enter the database name.

  4. Select either Use Windows Authentication or Use SQL Server Authentication. If the latter is selected, enter values in the Username and Password fields.

  5. Click OK.

Selecting Calls

In Call Viewer, use the Query Builder pane on the Call Filtering tab to specify which calls to view. See the following list of tips.

  • To view all calls in the database, execute a query with a blank Query Builder pane.

  • To delete a row in Query Builder, select it and press DEL.

  • Wildcards work as they would in a SQL query. When using the like field, use the percent symbol (%) as a wildcard character.

  • For date time/duration fields, enter times in the format hh:mm:ss. Milliseconds can be omitted.

To build a Call Viewer query
  1. In the Query Builder pane, select the top row, and make selections in each column to build a query. Use the Boolean operators And/Or at the end of the row and the parentheses at each end to build more complex queries. Depending on the selection in the Clause column, the options in the remaining columns vary, as shown in the following table.

    Clause

    Columns

    Where

    column from the Call Summary pane | Boolean operator | value

    Containing/Not Containing

    event | with | event property | Boolean operator | value

  2. On the Query menu, select Execute.

Example Queries

The following example query displays all calls received within a span of time.

Row number

Statement

One

Where | Answered at | greater than or equal to | 12/17/2003 14:00 | And

Two

Where | Disconnected at | less than or equal to | 12/17/2003 14:30

The following example query displays all calls containing QA controls that ended with NoReco.

Row number

Statement

One

Containing | QASummary | with | History | like | NoReco

The following example query displays all calls containing QASummary events with Message properties containing a locale ID beginning with "fr".

Row number

Statement

One

Where | Languages | like | %fr-%

Note  Selecting an event class in a Containing/Not Containing query selects not only event instances of that class, but also event instances of any of its subclasses. For example, selecting "Containing OnRecoEvent..." returns not only occurrences of the OnRecoEvent class (successful speech recognition results) but also events of its subclass type ExtendableRecognitionEvent (successful DTMF recognition results). This enables advanced querying based more directly on the event hierarchy and/or on abstract event types. See Event Logging Class Hierarchy.

Using Advanced Event Filtering to Select Calls

More complex filtering on call selection can be applied by specifying filters on the Advanced Event Filtering pane, and then checking the Hide all calls check box on the Call Filtering pane. For more information on call filters, see the topic Viewing Call Details. This has the effect of displaying only those calls which hold events whose properties match the specified filters, and displays only those events within the call.

Viewing Call Summaries

The Call Summary tab lists the calls returned by the query and displays summary call data in the columns described in the following table. The column names also represent the properties of calls that can be queried for call selection using a Where clause, as described previously.

Column name

Description

From

Calling device number.

To

Called device number.

Placed At

Time the call came in, in hh:mm:ss.

Answered At

Time the call was answered. Blank if the call was rejected or the user hung up.

Disconnected At

Time the call was disconnected, in hh:mm:ss.

Duration

Duration of the call, in hh:mm:ss:mmmmmmm.

Ended

The value of the DisconnectStatus property of the CallEndedEvent class.

Tasks

IDs of all tasks begun, in chronological order.

QASummary Count

The number of QAs completed in the call.

Languages

The languages of the Message properties of QASummary events used on pages requested during the call.

ApplicationInstance

Microsoft Speech Server session globally unique identifier.

See Also

Call Viewer