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 > Modeling > Modeling > Modeling Studio > Use OOTB Database Views for Reporting

Use OOTB Database Views for Reporting

The out-of-the-box (OOTB) or factory database views can be used for reporting as long as you perform read-only operation.

The views names are stored in the CLASS_MODEL_ENCODING table. You can find names of database views for each CIT by executing the following select statement:

select CLASS_NAME, VIEW_BY_CLASS from CLASS_MODEL_ENCODING

There is no clear rule for determining the view name based on the class name. Usually if the table name is CDM_<CLASS_NAME>_<CUSTOMER_ID>, the view name is something similar to <CLASS_NAME>_<CUSTOMER_ID>. But for some classes where the name length is greater than 32 characters (Oracle limitation), the table name and view name might contain number sequences. Therefore the best solution to find a view name is to run the above select statement.

Note

Database views will change when the Data Models are updated.
Running more than 10 reports with large amount of data may lower the UCMDB performance.
Run the DB views reports only when no discovery, enrichments, integration, aging, or purging runs.
Only database views should be used for reporting, not tables.

For details about how to define report setting, see How to Define Report Settings.

Related Information

Send Help Center feedback