Hello,
I want to monitor the service state of MSSQLSERVICE in a Windows box but I encountered the following problem adding a trigger:
1) Installed ZabbixW32 agent to port 10006 to avoid conflict with SQL
2) I added item service_state[MSSQLSERVER]
3) it was returning always 0 so I changed to service_state["MSSQLSERVER"] with quotes
4) this time it works returning 1 (why with quotes?)
5) I can see in the item configuration that inside the database it was stored as service_state[\"MSSQLSERVER\"] with the backslash before the quote
5) I want to link a trigger to this item but I either I specify the item with/without the quotes in the expression:
{host:service_state[\"MSSQLSERVER\"].last(0)}=0
i receive always
"Expression [{host:service_state[\\\"MSSQLSERVER\\\"].last(0)}] does not match to [server:key.func(param)]"
Note the triple backslash!
How can I manage? Ideas?
I want to monitor the service state of MSSQLSERVICE in a Windows box but I encountered the following problem adding a trigger:
1) Installed ZabbixW32 agent to port 10006 to avoid conflict with SQL
2) I added item service_state[MSSQLSERVER]
3) it was returning always 0 so I changed to service_state["MSSQLSERVER"] with quotes
4) this time it works returning 1 (why with quotes?)
5) I can see in the item configuration that inside the database it was stored as service_state[\"MSSQLSERVER\"] with the backslash before the quote
5) I want to link a trigger to this item but I either I specify the item with/without the quotes in the expression:
{host:service_state[\"MSSQLSERVER\"].last(0)}=0
i receive always
"Expression [{host:service_state[\\\"MSSQLSERVER\\\"].last(0)}] does not match to [server:key.func(param)]"
Note the triple backslash!
How can I manage? Ideas?