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 Management2017.11

Administer > Database administration > Data persistence > Purging and archiving records > Unload files

Unload files

The native ITSMA Service Management export format is the unload file. An unload file stores the database dictionary of Service Management tables in addition to records. The database dictionary embedded in an unload file determines where Service Management loads records during import. The unload file also specifies whether Service Management should update or ignore duplicate records when loading records. Service Management can export unload files in the following file formats:

Binary — The binary unload file format archives Service Management tables. You can load binary unload files only from the Database Manager.
Text — The text unload file format is human readable but only intended to be loaded from the Database Manager.
Formatted text — The formatted text unload file format is intended to be compatible with external applications, although the actual format of the file is determined by the form you select as a template. You can create export forms to create formatted text unload files compatible with specific applications.

You can export records into an unload file from the following Service Management utilities:

Database Manager
Unload Script Utility
Directly from some record lists

After you load a .unl file to import data into Service Management, you must stop and then restart the Service Management server. This ensures that the table changes are initialized.

Note: Service Management encodes unload files in the UTF-8 format. Service Management can import unload files from previous versions of ServiceCenter, but earlier versions cannot import unload files created by Service Management.

Send Help Center feedback