Execution Python version

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

<sql_host>
SQL ServerHost\Instance to connect.
<sql_port>
Sql port
<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”INSTANCE1" “pandora”"artica" “pandora_database”"pandora" “"pandora_database" "select * from tdata where value=’monitoring’”" “"|”"