Create view of hosts not having a certain service

General
1

Hello,

I’m struggling to create a view that lists all hosts which do not have a service named ^Service xyz.*. Is this possible? Thanks for any advice.

Checkmk Enterprise Edition 2.3.0p20

2

You cannot search for things that are not there.

You can only search for all services that do not have this name with the negate checkbox.

3

Possible workaround could be, thinking out of the box:

  • make a list of all hosts that should have specific service
  • make another list of all hosts that do have specific service
  • copy both lists to, or connect to directly in Excel as lists on website
  • use either Excel vlookup or combination of index and match functions to see which host is present in the other, resulting with a leftover that isn’t
1 Like
4

Hi Eric1,

if you mean windows services, you could create an enforced service “Windows Services” and set the criticaliy for “state if no entry matches” = ok or warning, depending on what you want to achieve.
Then you have the service Summary “service not found”, or if set to warning, the status, which you then can use as a filter.

1 Like
5

The service name contains an ID which differs on each host. That’s why I cannot use enforced services as they don’t allow regex in service name.

In SQL it would be easy with a query like “where host not in (sub query)”. For a one time job I’ll go the way proposed by Yggy.

1 Like
6

As a workaround, you could create a custom local check (see Local checks) that meets your requirements. Hopefully, this helps you out.