SQL Query - item & trigger

[NaPeK]

Hej i got sql query that returns 1 or 0, how to create item and trigger for this query ? where point database ?

THX in advance

[batchen_regev]

what i would do is to redirect the 0 or 1 to some log ( in a script)
and make zabbix only reading the log file like this :

item:
system.run[cat /var/log/somelog]

and the trigger should be like :
.last(0)}<>1 - if last value is not 0 fire trigger
last(0)}=1 if it does equal 0 fire trigger

[NaPeK]

Powershell:

$sql = Invoke-Sqlcmd -Query " ...... " $containsWord = $file | %{$_ -match "0"} if ($containsWord -contains $true) { Return 0 } else { Return 1 }

Item:

system.run[powershell.exe -command C:\Zabbix\Powershell_Script.ps1]

Trigger:

{sql:system.run[powershell.exe -command C:\Zabbix\Powershell_Script.ps1].last()}=1