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 <ma(a)mathias-kettner.de>
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
}