SQL Querier Tool

• Introduction
• Prerrequisites
• Execution Perl version
• Execution Python version

Introduction

Plugin for monitoring SQL Server databases through custom SQL queries.
Obtains the result of the launched SQL query as a value for the modules that use it.

Type: Server plugin

Prerrequisites

This plugin requires:
● Connection between the Pandora server and the SQL Server database.
● Login username and password.
● The package "perl DBI SQL server odbc" installed on the Pandora server (only for the perl version of the plugin).

● The ODBC Driver 18 is required for the Python version.

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" -P "pandora" -H "SQLSERVER\INSTANCE1"

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" "pandora" "pandora_database" "select * from tdata where value=’monitoring’" "|"