[checkmk-commits] 4822 FIX mk_tsm: Made query for storagepools more robust

Module: check_mk Branch: master Commit: 6a42ac4df3b88c80fde38efce8d721685b10804a URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=6a42ac4df3b88c… Author: Marcel Arentz &lt;ma(a)mathias-kettner.de&gt; Date: Wed Jun 14 14:26:25 2017 +0200 4822 FIX mk_tsm: Made query for storagepools more robust A migrated Pool vanished in the output and produced in consequence an UNKNOWN. Thanks to Thorsten Hintemann this has been fixed know. Change-Id: I2b47afe5fffe31d5aec9715266d2afd62913fcb1 --- .werks/4822 | 11 +++++++++++ agents/plugins/mk_tsm | 2 +- 2 files changed, 12 insertions(+), 1 deletion(-) diff --git a/.werks/4822 b/.werks/4822 new file mode 100644 index 0000000..9a77ba3 --- /dev/null +++ b/.werks/4822 @@ -0,0 +1,11 @@ +Title: mk_tsm: Made query for storagepools more robust +Level: 1 +Component: checks +Compatible: compat +Edition: cre +Version: 1.5.0i1 +Date: 1497442952 +Class: fix + +A migrated Pool vanished in the output and produced in consequence an +UNKNOWN. Thanks to Thorsten Hintemann this has been fixed know. diff --git a/agents/plugins/mk_tsm b/agents/plugins/mk_tsm index b4faa16..d09de95 100755 --- a/agents/plugins/mk_tsm +++ b/agents/plugins/mk_tsm @@ -65,7 +65,7 @@ EOF # Occupancy echo '<<<tsm_storagepools:sep(9)>>>' $dsmcmd <<EOF | sed -n "/^FOO/s//$INST/p" -SELECT 'FOO', type, stgpool_name, sum(logical_mb) from occupancy group by type, stgpool_name +SELECT 'FOO' as foo,COALESCE(type,'Unknown') as type,stgpools.stgpool_name, sum(coalesce(logical_mb,0)) as SUM_LOGICAL_MB from occupancy full outer join stgpools on occupancy.stgpool_name=stgpools.stgpool_name group by stgpools.stgpool_name,type EOF }