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.50

Administer > Database Administration > Data persistence > Record retrieval > Open a record using Database Manager

Open a record using Database Manager

Applies to User Roles:

System Administrator

To open a record using Database Manager:

Click Tailoring > Database Manager.
Note: Alternatively, you can open Database Manager from the command line, by typing db, and then pressing Enter or clicking Execute Command.
Select a form or file by typing the name of a form in the Form field or the name of a file in the Table field.

If one or both fields are left blank, the record list returns all records that match your criteria.
Click Search.
Enter your search criteria. For example, you can enter known information in key fields, such as names of operators, names of devices, or incident numbers.

Note: Executing a search that includes a field that is not fully keyed slows response time.
Click Search.
- If found, a record that matches your criteria opens.
- If more than one match is found, a record list opens.
  
  For multiple returns, click a record from the record list to display it.

Note: A device is also referred to as a Configuration Item (CI).