PDA

View Full Version : Help with trigger on a MSSQL instance


Ismael Medina
28-06-2007, 20:56
As you know, a MSSQL instance can be declared SERVER\INSTANCE, each instance of this type has two services, one engine and one agent.

The services names follows this pattern

MSSQL$INSTANCE
SQLAGENT$INSTANCE

Then a Zabbix Item should be service_state[MSSQL$INSTANCE], an the trigger on service not runnig should be {host:service_state[MSSQL$INSTANCE].last(0)}>0

but when i try to save this i get an error about this key doesn't exists.

I think the problem is the "$" character, how can I save this trigger???.

Thanks in advance.

Alexei
28-06-2007, 21:11
I believe this will work in 1.4.1 which we plan to release tomorrow.