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

Use > Service Manager Reports > Report administration > Configure Report settings > Enable Replicated Database

Enable Replicated Database

Generating the reports from the server will consume additional system resources (memory and CPU). Service Manager provides the database replication to preserve Production Database performance.

Before you enable Replicated Database for Service Manager Reports, prepare a database with the same database type and version as the Production Database. For example, if your Service Manager uses an SQL database, the replicated database should be an SQL database of the same version. Perform database synchronization periodically by using the standard database synchronization mechanism.

To enable Replicated Database, follow these steps:

Open the sm.ini file. By default, the file is located on the Service Manager server in the C:\Program Files (x86)\HP\HP Service Manager 9.40\Server\RUN folder.
Add the Replicated Database parameter and value to the file. For example:
```
[your database type_replicate]
```
```
sqldb:sm940db
```
```
sqllogin:username/password
```
```
dashboardonreplicatedb
```
Note The three parameter lines of Replicated Database should be in one block in the sm.ini file.
Save the sm.ini file.

Send Help Center feedback