We use cookies to ensure that we give you the best experience on our website.  Visit our Privacy Policy to learn more. If you continue to use this site, we will assume that you are okay with it.

Your choices regarding cookies on this site.
Your preferences have been updated.
In order for the changes to take effect completely please clear your browser cookies and cache. Then reload the page.

Werk #10671: mk_oracle: Support for Custom SQL with Remote Monitoring

ComponentChecks & Agents
Titlemk_oracle: Support for Custom SQL with Remote Monitoring
Date2020-01-08 13:30:26
Checkmk EditionCheckmk Raw Edition (CRE)
Checkmk Version2.0.0i1
LevelTrivial Change
ClassNew Feature
CompatibilityCompatible - no manual interaction needed

The new feauture Custom SQL could be used with Remote Monitoring as well. Be aware that the configuration of Custom SQL and Remote Monitoring is not easy...

The SQLS_ITEM_SID is mandatory in this configuration. Otherwise the value from SQLS_SIDS is used in the service name during Discovery.

The following example shows only the needed parameter for a configuration. This is not complete for a whole mk_oracle.cfg!

Example mk_oracle.cfg:

REMOTE_INSTANCE_1_db1=c##cmk:cmkpass::dbhost:1524:piggybackhost:db191:19

SQLS_SECTIONS="invalid_objects"
SQLS_DIR=/etc/check_mk
SQLS_MAX_CACHE_AGE=10

invalid_objects () {
SQLS_SIDS=REMOTE_INSTANCE_1_db1
SQLS_ITEM_SID=db191
SQLS_SQL=invalid_objects.sql
}