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

Unload script utility

The unload script utility enables system administrators to create ITSMA Service Management unload files automatically. The unload script utility enhances the standard unload creation process in many ways. With unload scripts, you can:

Save records from multiple tables into a single unload file.
Specify a query for each source table that filters the records added to the unload file.
Purge records during the unload process.
Specify which formats to protect during a purge process.
Add related records from the data map file to the unload file.

The unload script utility is available in Tailoring. By default, Service Management includes a collection of unload scripts that you can use for common unload tasks. You can also use the default unload scripts as templates to create your own customized unload scripts.

To create and use unload scripts effectively, you must be familiar with the Service Management Database Manager. You can create a query on any field in the file, but querying keyed fields improves system performance and response time. You can create record queries using Structured Query Language (SQL) syntax.

You can use the Purge/Archive utility to unload and purge records from one file; if you use datamaps, you can use Purge/Archive to unload and purge related records as well.

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