I have problem, with a special kind of userparameter. I'd like to monitoring a DB, which contains data in an XML type field and it conatins special characters (é,á,ő,ú,ó,ö...). So my userparameter is sg like this:
UserParameter=get.Parameter1, "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\sqlcmd.exe" -S sqlservername -U user -P psw -d database-h -1 -W -I -Q "SET NOCOUNT ON; SELECT COUNT(*) FROM [database].[dbo].[table] (NOLOCK) WHERE [SysCreationDate] > DATEADD(minute, -1, GetDate()) AND CAST(Output.query('Answer/Item/text()') AS VARCHAR(MAX)) = ('A megadott adatokkal nincs érvényes igazolása a nyilvántartásban.')
If I set it up, the zabbix agent doesn't starts... because the special characters (é,á,....)
But, I need this characters, because that is what I need filter...
Does anybody any idea, how can I resolve this problem?
UserParameter=get.Parameter1, "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\sqlcmd.exe" -S sqlservername -U user -P psw -d database-h -1 -W -I -Q "SET NOCOUNT ON; SELECT COUNT(*) FROM [database].[dbo].[table] (NOLOCK) WHERE [SysCreationDate] > DATEADD(minute, -1, GetDate()) AND CAST(Output.query('Answer/Item/text()') AS VARCHAR(MAX)) = ('A megadott adatokkal nincs érvényes igazolása a nyilvántartásban.')
If I set it up, the zabbix agent doesn't starts... because the special characters (é,á,....)
But, I need this characters, because that is what I need filter...
Does anybody any idea, how can I resolve this problem?
Comment