Skip to main content

Execution Python version

./msql_query “<sql_host>””<sql_user>” “<sql_password>” “<sql_database>” “<sql_query>” [“<delimiter_character>”]


<sql_host>
SQL ServerHost\Instance to connect.
<sql_user>
Database connection Domain\User.
<sql_password>
Database connection password.
<sql_database>
Database name.
<sql_query>
SQL query to get the value. Strings in WHERE statement must use single quotes..
<delimiter_character>
Optional. Field delimiter character of the SQL query result. By default it uses “,”

Example:

./msql_query “SQLSERVER\INSTANCE1””artica” “pandora” “pandora_database” “select * from tdata where value=’monitoring’” “|”