Populate Item with result from SQL Server Query

[WernerCD]

I'm trying to track a process that locks up regularly. It's a funky program that we have no control over. I'm trying to find a good way to track when the program stops responding.

I have a query which has a result... It comes back with 2 numbers: an integer and a time. The integer is "Items in Queue" and the time is "Time last item was processed".

What I'm trying to find out... is what is the best way to get these result into the Zabbix Database? How can I query SQLServer\DatabaseX either once to populate two items... or twice to seperately fill these two Items? Can I use Zabbix to run a Stored Procedure (which can be set to return whatever) and return that info via Agent?

IF I can get the result of a stored procedure... can I update two Items with one result or would i have to have two queries?

[fdcsantos]

Hello WernerCD,

Glad to see your post here in Zabbix forum. I saw it in Server Fault site. As a matter of fact, I´m with the sabe problem as you and really want to know if you had success in your script. Your last news was about a bash script that uses Zabbix_Sender to read MS SQL data and based on results, Zabbix alert or not.

So, did you got it? It worked?