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

Upgrade > Upgrade the applications from a version earlier than 9.50 > Appendix B: Data migration > Out-of-box data migration settings > Configuration Item data migration

Configuration Item data migration

Considering that Configuration Item does not need to copy data from two different tables, and that it typically has a large volume of data, we recommend that you run the migration by using the batch update mode.

The out-of-box example data migration is based on the following key field:

current.phase

Note You can add additional fields if needed, but do not remove these two fields.

Default settings:

Source Table	device
Target Table	device
Filter Condition	null(current.phase)

Field Mapping:

Target Field	Source Field
current.phase

Value Mapping:

Target Value Mapping Field	Mapping Type	Condition	Target Value
current.phase	fixedValue	istatus=null or (istatus~="Missing" and istatus~="Retired/Consumed" and istatus~="Return for Maintenance" and istatus~="Return to Supplier")	Active
current.phase	fixedValue	istatus="Missing" or istatus="Retired/Consumed" or istatus="Return for Maintenance" or istatus="Return to Supplier"	Inactive

Send Help Center feedback