Run a stored query

Depending on your permissions, you can add, edit, or run stored queries from the Query window, which is accessible from the form in Database Manager or from the Application search form. Data entered into the from is automatically entered into the Query window to form the query. Depending on your permissions, you can edit and run that query, or select a query from a list of stored queries.

Example: Selecting and running a stored query.

In this example, a stored query for Incident Management (the probsummary file) is selected and run.

1. Open the query window.
   • To open the query window from a ITSMA Service Management application:
     1. Open the application Search form. For this example, click Incident Management > Search Incidents.
     2. Open the More Actions menu.
     3. Select Expert Search.
   • To open the query window from a Database Manager search form:
     1. Open the form in Database Manager. For this example, type =probsummary in the Form field, and then press Enter.
     2. Open the More Actions menu.
     3. Select Expert Search.

   The Query window opens.

2. Click Select to display the list of stored queries for the associated file.
3. Double-click a query to select it. For this example, select status.resolved. The Stored Query record opens.

4. Click Select.

   Service Management returns you to the Query window.

5. Click Execute Search to run the stored query.

   Records matching the query display in a record list.

   • If only one record matches your search criteria, that record opens.
   • If no records match, the server displays the following message: No records found.