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 > Unload script utility > Run an unload script

Run an unload script

Applies to User Roles:

System Administrator

To run an unload script:

Click Tailoring > Unload Script Utility.
Fill in optional search criteria.
Click Search.
Select the unload script to run.
Click Proceed.

Fill in the following fields.

Field	Description
External File Name	Type the name of the unload file to create. This name can include the path information but must use characters that are valid for the target operating system. By default, ITSMA Service Management saves the unload file in RUN folder of the server. If users have enabled client-side unloading, then the Service Management saves the unload file on their Windows desktop.
Append to File?	Select this option to add records to an existing unload file.
When loading records into an existing database dictionary — Use existing database dictionary	Select this option to use the table and field definitions stored in the database dictionary of the target system.
When loading records into an existing database dictionary — Use database dictionary of loaded record	Select this option to use the table and field definitions stored in the unload file. This option will overwrite the existing database dictionary, if any, for the loaded file and records.
When loading records — Add new records and update existing records	Select this option to update existing records in the target system with records from the unload file. The new records will be inserted into the table and the existing records will be updated regardless of case-sensitivity.
When loading records — Add new records only	Select this option to ignore existing records and add only new records from the unload file. The new records will be inserted into the table regardless of case-sensitivity.

Click Proceed.
Service Management unloads the tables and records you selected in the unload script.

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: The unload script utility unloads tables using the binary unload file format.

Send Help Center feedback