> Source: [sk181454](https://support.checkpoint.com/results/sk/sk181454)

# sk181454 - Search in SmartConsole 'Security Policies' view highlights only some instances of the object

| Property | Value |
|----------|-------|
| Solution ID | sk181454 |
| Date Created | 2023-09-07 |
| Last Modified | 2025-01-20 |
| Technical Level | General |
| Products | Security Management Server, SmartConsole, Multi-Domain Security Management Server |
| Versions | R82, R81.20, R81.10 (EOS), R81 (EOS), R82, R81.20, R81.10 (EOS), R81 (EOS), R81 (EOS), R81.10 (EOS), R81.20, R82 |
| OS | Gaia |

## Symptoms

- * Search in the SmartConsole 'Security Policies' view returns partial results - does not highlight the search string in all rules that contain the relevant object.

* Different searches for the same object name show different results - the object name is highlighted in different rules.

* The search results remain the same if the object name is in the start, middle, or end of the search expression.

  For example, when searching for object name "ABC" using this search query:

  `ABC_myhost_1.2.3.4 OR myhost_ABC_1.2.3.4 OR myhost_1.2.3.4_ABC`

## Cause

More than 5,000 objects that contain the search string are defined.

The query infrastructure that fetches the objects from the Postgres database sets a limit of 5,000 to the query.

## Solution

This problem was fixed. The fix is included starting from:

* [Check Point Quantum R82](https://support.checkpoint.com/results/sk/sk181127)
* [Jumbo Hotfix Accumulator for R81.20](https://sc1.checkpoint.com/documents/Jumbo_HFA/R81.20/Default.htm) starting from Take 70
* [Jumbo Hotfix Accumulator for R81.10](https://sc1.checkpoint.com/documents/Jumbo_HFA/R81.10/Default.htm) starting from Take 152
* [Jumbo Hotfix Accumulator for R81](https://sc1.checkpoint.com/documents/Jumbo_HFA/R81/Default.htm) starting from Take 106

Check Point recommends to always upgrade to the most recent version.

### Best Practices

1. Group separate similar objects into Group objects.

2. Decrease the number of configured rules - where possible, replace multiple specific rules with more generic rules (for example, instead of configuring several rules for specific hosts on the same subnet, configure one rule using a Network object).

<br />

### Instructions to configure a greater limit

**Important Note** - If you increase this limit, the search action in SmartConsole can consume more CPU and memory resources on the Management Server.
> 1. Connect to the command line on the Management Server.
>
> 2. Log in to the Expert mode.
>
> 3. On a Multi-Domain Security Management Server, go to the context of the applicable Domain Management Server:
>
>    `mdsenv <IP Address or Name of Domain Management Server>`
> 4. Run this command:
>
>    `$MDS_TEMPLATE/scripts/reload_env_vars.sh -e "SC_SEARCH_QUERY_LIMIT=<NEW_VALUE>"`
>
>    Example for 7000:
>
>    `$MDS_TEMPLATE/scripts/reload_env_vars.sh -e "SC_SEARCH_QUERY_LIMIT=7000"`
>
> **Important Note** - This change does not survive a reboot. To make this change during each boot, add the required command in the "*/etc/rc.d/rc.local*" script:
> > 1. Back up the current script:
> >
> >    `cp -v /etc/rc.d/rc.local{,_BKP}`
> > 2. Edit the current script:
> >
> >    `vi /etc/rc.d/rc.local`
> > 3. Add these lines at the bottom of the script:
> >
> >    **Note** - Enter you required value. After the last line, you must press the Enter key to create a new line.
> >
> >    `# Changes based on sk181454`
> >
> >    `$MDS_TEMPLATE/scripts/reload_env_vars.sh -e "SC_SEARCH_QUERY_LIMIT=<NEW_VALUE>"`
> > 4. Save the changes in the file and exit Vi editor.

<br />

### Instructions to restore the default limit of 5000

> 1. Connect to the command line on the Management Server.
>
> 2. Log in to the Expert mode.
>
> 3. On a Multi-Domain Security Management Server, go to the context of the applicable Domain Management Server:
>
>    `mdsenv <IP Address or Name of Domain Management Server>`
> 4. Run this command:
>
>    `$MDS_TEMPLATE/scripts/reload_env_vars.sh -e "SC_SEARCH_QUERY_LIMIT=5000"`
>
> **Important Note** - If you added the required command in the "*/etc/rc.d/rc.local* " script, then edit the script file and comment out the command - add the # character in the beginning of the command (#`$MDS_TEMPLATE/scripts/reload_env_vars.sh -e ...`).

---

# Agent Instructions

This content is from the Check Point Support Center (https://support.checkpoint.com), the official knowledge base for Check Point cybersecurity products.

## Navigating This Knowledge Base

- **Complete index**: [llms.txt](https://support.checkpoint.com/llms.txt)
- **All SK articles**: [SecureKnowledge Sitemap](https://support.checkpoint.com/sitemaps/secureknowledge-sitemap-index.xml)
- **SK article URL pattern**: `https://support.checkpoint.com/results/sk/{skId}`
- **Markdown responses**: AI bot User-Agents automatically receive `text/markdown` content