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

Use > Service Manager Reports > Report administration > 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 Server database, the replicated database should be an SQL Server 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, located in the <Service Manager installation path>\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 Change "your database type" to one of the following values: oracle, sqlserver, and db2universal. Additionally, 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