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)`

Universal CMDB11.0

Use > Data Flow Management > Reconciliation > Data Reconciliation > Data-In Service - Populating UCMDB > Server-Side Data Normalization

Server-Side Data Normalization

Before populating the CMDB with new CIs, the server normalizes the incoming data as follows:

When a CI of type ip_address is reported, if one of the name or the ip_address_value attributes contains data, the other is populated automatically.
When a CI of type ip_subnet is reported, if one of the network_netmask or ip_prefix_length attributes contains data, the other is populated automatically.
When the REPLACE_VALUE_WITH_VALUE_FROM_SYSTEM_PROPERTY qualifier is defined for a particular attribute, the attribute is normalized with the specified system property value.

For example, the routing_domain attribute, by default, contains the REPLACE_VALUE_WITH_VALUE_FROM_SYSTEM_PROPERTY qualifier where:
- CONSTANT_TO_REPLACE data item is defined as ${DefaultDomain}
- SYSTEM_PROPERTY_NAME data item is defined as default.domain
This means that if a CI of type ip_address is reported with ${DefaultDomain} in the routing_domain attribute, then the routing_domain attribute is populated with the value in the default.domain setting.
If the CI attribute's Discovery Auto Truncate (DDM_AUTOTRUNCATE) qualifier is enabled, then results of type STRING are truncated according to the database encoding setting.

Note By default, the database encoding is defined as UTF-8. This encoding can be changed in the Infrastructure Settings Manager, in the Reconciliation Settings > Database Encoding setting (reconciliation.auto.truncate.db.encoding). To access the Infrastructure Settings Manager, go to Administration > Infrastructure Settings Manager. For more details, see Infrastructure Settings Manager Page.

If the CI attribute has a case qualifier that is enabled, then the case of all of the results are normalized. The case qualifiers are:

Qualifier	Display Name	Description
TO_UPPER_CASE	Upper Case	Normalizes all results to upper case
TO_LOWER_CASE	Lower Case	Normalizes all results to lower case

Note The deprecated qualifiers, DDM_AUTOUPPERCASE and DDM_AUTOLOWERCASE, can also be used to normalize results to upper case or lower case respectively, if enabled.

If the Discovery Auto Trim (DDM_AUTOTRIM) qualifier for the attribute is enabled, any leading and trailing spaces and tabs are removed from the string.

Note This qualifier must be added only for the String type attributes.

For more information about attributes, see CI Type Attributes.

Related Information

Send Help Center feedback