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’” “|”