Building Queries

You can securely perform detailed queries against session servers using the Host Integrator logging component.

The Log view toolbar

This button Does this
Runs the query
Cancels a running query. If you want to interrupt a query while it is running, click this toolbar button.
Brings up the Build Query dialog box where you can create a query.
Clears the messages from the viewer and from the server.

To create a query

  1. From the Host Integrator drop down list, open the Logging perspective.

  2. From the list of session servers, select the ones you want to run the query against.

    You can run a query against multiple session servers.

  3. The drop down list displays the default query string and the most recently used queries. You can run a query using this filter or build your own query. The default query, select * from messages, displays all messages.

    You can type a query directly into the text box, however, you must be careful to use the correct syntax.

  4. If you decide to build your own query, click Build Query on the toolbar.

    The Build Query dialog box displays.

  5. Set the parameters for your query.

    As you build the query it displays in the Query box.

  6. Check Execute Query to activate the query automatically when you close the dialog box.

To set query parameters

You set query parameters using the Build Query dialog box. To use multiple values for Message ID, Session ID, Request ID, and so forth, separate them using commas.

Viewing Query Results

Logging results display in the Log view of the Administrative Console and are selectable using the right-click context menu. You can select multiple rows from the query table and save them to a clipboard in a comma-separated format.

Log messages are shown in reverse order, that is from most recent at the top of the log to the oldest messages at the bottom.

The results of the query are scrollable. The statement describing the query will determine the order and number of columns displayed.

Related Topics
Bullet Setting Log Properties
Bullet Exporting Log Files
Bullet Understanding the SQL Dialect of the Logging System
Bullet Working with Session Server Logging