Use SQL individual MY Metrics

General
1

As far as I know, I is possible to use “My Metrics” in checkMK.
I build these SQL Statements:
SELECT INPUT_TYPE, STATUS,
to_char(max(START_TIME),‘DD.MM.YYYY HH24:MI:SS’) AS RMAN_START,
to_char(max(END_TIME),‘DD.MM.YYYY HH24:MI:SS’) AS RMAN_ENDE
FROM V$RMAN_BACKUP_JOB_DETAILS
where INPUT_TYPE = ‘DB FULL’ and STATUS LIKE ‘COMPLETED%’
group by INPUT_TYPE, STATUS
ORDER BY INPUT_TYPE, STATUS DESC;

SELECT INPUT_TYPE, STATUS,
to_char(max(START_TIME),‘DD.MM.YYYY HH24:MI:SS’) AS RMAN_START,
to_char(max(END_TIME),‘DD.MM.YYYY HH24:MI:SS’) AS RMAN_ENDE
FROM V$RMAN_BACKUP_JOB_DETAILS
where INPUT_TYPE = ‘ARCHIVELOG’ and STATUS LIKE ‘COMPLETED%’
group by INPUT_TYPE, STATUS
ORDER BY INPUT_TYPE, STATUS DESC;

In YML we put:

  • RMAN Last DB Full successfull:
    sql: |
    SELECT ‘details:INPUT_TYPE=’ || INPUT_TYPE || ‘, STATUS=’ || STATUS || ‘, RMAN_START=’ || to_char(max(START_TIME),‘DD.MM.YYYY HH24:MI:SS’) || ’ , RMAN_END=’ || to_char(max(END_TIME),‘DD.MM.YYYY HH24:MI:SS’)
    FROM V$RMAN_BACKUP_JOB_DETAILS
    WHERE INPUT_TYPE = ‘DB FULL’ AND STATUS LIKE ‘COMPLETED%’
    GROUP BY INPUT_TYPE, STATUS
    ORDER BY INPUT_TYPE, STATUS DESC

The Metrics come up in the Web like this:

INPUT_TYPE=ARCHIVELOG, STATUS=COMPLETED, RMAN_START=02.09.2026 09:56:29, RMAN_END=02.09.2026 09:56:34, INPUT_TYPE=ARCHIVELOG, STATUS=COMPLETED, RMAN_START=02.09.2026 09:56:29, RMAN_END=02.09.2026 09:56:34
INPUT_TYPE=DB FULL, STATUS=COMPLETED, RMAN_START=02.09.2026 09:21:05, RMAN_END=02.09.2026 09:21:58, INPUT_TYPE=DB FULL, STATUS=COMPLETED, RMAN_START=02.09.2026 09:21:05, RMAN_END=02.09.2026 09:21:58
Note that all vbalues come up twice.

Even the example about free memory looks the same.
The value comes up twice:

ORA ONLY4CHECKS SQL MY SERVICE FreeMemory:120.63 MB, FreeMemory:120.73 MB

Any Idea?

2

Is there a reason not to use the custom SQL capability in the Oracle plugin to run these statements?

3

I just tried to do this by placing this

  • RMAN Last DB Full successfull:
    sql: |
    SELECT ‘details:INPUT_TYPE=’ || INPUT_TYPE || ‘, STATUS=’ || STATUS || ‘, RMAN_START=’ || to_char(max(START_TIME),‘DD.MM.YYYY HH24:MI:SS’) || ’ , RMAN_END=’ || to_char(max(END_TIME),‘DD.MM.YYYY HH24:MI:SS’)
    FROM V$RMAN_BACKUP_JOB_DETAILS
    WHERE INPUT_TYPE = ‘DB FULL’ AND STATUS LIKE ‘COMPLETED%’
    GROUP BY INPUT_TYPE, STATUS
    ORDER BY INPUT_TYPE, STATUS DESC
    Under “custom_metrics:”
    However, the GUI does not show something like this
    "ARCHIVELOG COMPLETED 02.09.2026 09:56:29 02.09.2026 09:56:34
    "