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 > Exporting records > Export descriptor records

Export descriptor records

You can create an export descriptor record to define the rules for exporting data from HPE Service Manager tables to external files. Each export descriptor record describes the following information:

The Service Manager source table to be exported
The fields from the table to export
Formatting information about each field
- Field start position
- Field width
- Number of entries to extract from array fields
- Date and time format
The related Format Control record to use, if any, to validate and format data prior to export

Note: You cannot export database dictionary field definitions using an export description record. To export database dictionary field definitions, use the native Service Manager unload format.

When you create an export descriptor record, Service Manager validates the table selected for exporting against the database dictionary. If the validation is unsuccessful, Service Manager displays the following message: Validation failed

You can click on the warning message to see the reasons why the data validation failed. Although Service Manager lets you save an invalid export description record, you cannot use this record to export data. You need to correct any validation errors before exporting data. After Service Manager validates the table, it exports each record as a single line entry in the resulting external file.

Send Help Center feedback