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 > Database > Deploying the Microsoft SQL Server Database > Overview of Microsoft SQL Server Deployment > Checklist for Support and Certification

Checklist for Support and Certification

Information is provided in this section for both supported and certified Microsoft SQL Server options.

The certified options are recommended for working with Universal CMDB. Certified options are rigorously tested by quality assurance personnel. Supported options are those options for which quality assurance personnel have successfully performed basic tests.

Subject	Microsoft SQL Server
Subject	Supported	Recommended
Instances	Default, Single
Authentication Mode	Mixed, Windows
Collation	Case-insensitive. Universal CMDB does not support binary sort order and case sensitivity. Only case-insensitive order with a combination of accent, kana, or width settings is supported .	Use the Collation Settings dialog box to select the collation. Do not select the binary check box. Accent, kana, and width sensitivity should be selected according to the relevant data language requirements. The selected language must be the same as the OS Windows regional settings language.
Network Libraries	Server: TCP/IP and Named Pipes Client: TCP/IP and Named Pipes	Server: TCP/IP Client: TCP/IP
Server Configuration Options	Defaults, unless instructed otherwise
Data File Properties	Manual file growth, or FILEGROWTH less than or equal to 100 MB	FILEGROWTH: ~30-100 MB
Collation Database Property	Server default
Database Options	Defaults, unless instructed otherwise
Recovery Model	Any	Full

Note

For Turkish, the recommended collation is Turkish_100_CI_AS.
In case replication is enabled on Microsoft SQL database server, there can be issues when Content Pack is upgraded or JMX methods that change UCMDB DB tables are run.

An example of error message from UCMDB logs is "Cannot drop the view 'view_name' because it is being used for replication."

Every DB object (view/table) which is replicated cannot be changed/deleted. The solution is to temporarily disable the replication until the required DB changes are applied. The changes must be done by a Database Administrator.

Send Help Center feedback