Hello Zabbix Forum,
I have issues with low level discovery. As far as I understand there is no template for Exchange Database Information like size and whitespace. That's what I want to monitor. I have a small powershell script set up and get this data as an item to one of my exchange hosts in zabbix. Details changed for obvious reasons. I would like to post screenshots. But I am new so i guess I am not allowed to yet.
[{"MOUNTEDON":"exchange01.test.local","WHITESPAC EGB ":0.12,"SIZEGB":0.38,"DBNAME":"DB01"},
{"MOUNTEDON":"exchange01.test.local","WHITESPAC EGB ":0.03,"SIZEGB":1.62,"DBNAME":"DB02"},
{"MOUNTEDON":"exchange02.test.local","WHITESPAC EGB ":0.08,"SIZEGB":0.24,"DBNAME":"DB03"},
{"MOUNTEDON":"exchange02.test.local","WHITESPAC EGB ":0.16,"SIZEGB":3.25,"DBNAME":"DB04"}]
I build an discovery rule that points to the item with the data. And I created a LLD macro?!
LLD macro -> JSONPath
{#DBNAME} -> $.DBNAME
From here I try to get the values for whitespace, size and mountedon for each database. What I try is to create item prototype's for each value.
I create each as an dependent item pointing to the discovery rules object i created. Let's take the size as an example:
Name: Database Size: {#DBNAME}
Type: Dependent item
Key: sizegb.[{DBNAME}]
Master Item: discovery rules object
From here I use the Preprocessing of the Item prototype:
My data is json so I guess JSONPath:
JSONPATH -> $.SIZEGB
But here I get this error: Cannot extract value from json by path "$.SIZEGB": invalid object format, expected opening character '{' or '[' at: ''
I don't understand how/what I do wrong? Any help would be appreciated.
Kind regards
badger77
I have issues with low level discovery. As far as I understand there is no template for Exchange Database Information like size and whitespace. That's what I want to monitor. I have a small powershell script set up and get this data as an item to one of my exchange hosts in zabbix. Details changed for obvious reasons. I would like to post screenshots. But I am new so i guess I am not allowed to yet.
[{"MOUNTEDON":"exchange01.test.local","WHITESPAC EGB ":0.12,"SIZEGB":0.38,"DBNAME":"DB01"},
{"MOUNTEDON":"exchange01.test.local","WHITESPAC EGB ":0.03,"SIZEGB":1.62,"DBNAME":"DB02"},
{"MOUNTEDON":"exchange02.test.local","WHITESPAC EGB ":0.08,"SIZEGB":0.24,"DBNAME":"DB03"},
{"MOUNTEDON":"exchange02.test.local","WHITESPAC EGB ":0.16,"SIZEGB":3.25,"DBNAME":"DB04"}]
I build an discovery rule that points to the item with the data. And I created a LLD macro?!
LLD macro -> JSONPath
{#DBNAME} -> $.DBNAME
From here I try to get the values for whitespace, size and mountedon for each database. What I try is to create item prototype's for each value.
I create each as an dependent item pointing to the discovery rules object i created. Let's take the size as an example:
Name: Database Size: {#DBNAME}
Type: Dependent item
Key: sizegb.[{DBNAME}]
Master Item: discovery rules object
From here I use the Preprocessing of the Item prototype:
My data is json so I guess JSONPath:
JSONPATH -> $.SIZEGB
But here I get this error: Cannot extract value from json by path "$.SIZEGB": invalid object format, expected opening character '{' or '[' at: ''
I don't understand how/what I do wrong? Any help would be appreciated.
Kind regards
badger77