Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.41

Administer > Database Administration > Data persistence > Queries > Stored queries > Run a stored query

Run a stored query

Applies to User Roles:

System Administrator

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.

Open the query window.
- To open the query window from a HPE Service Manager 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.
Click Select to display the list of stored queries for the associated file.
Double-click a query to select it. For this example, select status.resolved. The Stored Query record opens.
Click Select.

Service Manager returns you to the Query window.
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.

Send Help Center feedback