Execution Perl version
./msql_query -Q “"<sql_query>”" -U “"<sql_user>”" -P “"<sql_password>”" -H “"<sql_host>”"
<sql_query>
SQL query to get the value.
<sql_user>
Database connection user.
<sql_password>
Database connection password.
<sql_host>
SQL ServerHost\Instance to connect.
Example:
./msql_query -Q “"select * from tdata where value=’monitoring’”" -U “artica”"artica" -P “pandora”"pandora" -H “"SQLSERVER\INSTANCE1”INSTANCE1"