Preventing the detection of devices with a filter

This example insert defines a detection filter. Since there must only be one insert into the scope.detectionFilter table, multiple conditions for IP must be defined using a single insert. The conditions of the filter can be combined using the Boolean OQL keywords AND and OR.

insert into scope.detectionFilter
(
        m_Protocol, m_Filter
)
values
(
        1,
        "(
                ( m_UniqueAddress <> '10.10.63.234' )
                AND
                ( m_ObjectId not like '1\.3\.6\.1\.4\.1\..*' )
        )"
);

The above example filter ensures that only the following are further interrogated by the discovery:

Devices that do not have the IP address 10.10.63.234.
Devices that do not have the Object ID 1.3.6.1.4.1.*.

In the above example, the backslash (\) is used in conjunction with the not like comparison to escape the . character, which would otherwise be treated as a wildcard.