Define variable in Userparameter configuration file

[JakobHannibal]

I want to read data from SQL databases via the "userparameter configuration file".

In this file I have multiple lines like this:

#UserParameter=get.MY_SQL1[*], "C:\zabbix\SQLCMD\sqlcmd.exe" -S "database server" -d "databasename" -U "user" -P "password" -h -1 -W -Q "SET NOCOUNT ON; SQL_STATEMENT1"

#UserParameter=get.MY_SQL2[*], "C:\zabbix\SQLCMD\sqlcmd.exe" -S "database server" -d "databasename" -U "user" -P "password" -h -1 -W -Q "SET NOCOUNT ON; SQL_STATEMENT2"

#UserParameter=get.MY_SQL3[*], "C:\zabbix\SQLCMD\sqlcmd.exe" -S "database server" -d "databasename" -U "user" -P "password" -h -1 -W -Q "SET NOCOUNT ON; SQL_STATEMENT3"

I would like to define/declare "database server", "database name", "user" and "password" one time, and not for every line. Is there a way to do this and what is the syntax?

Any feedback is greatly appreciated.

[niveastn]

Hey there,

You can create an script (python, shell...) that calls for theses parameters, and set the script as a userparameter

[splitek]

here are examples: https://www.zabbix.com/documentation...ters#example_1