Documentation forServer Configuration Monitor

Understand database queries in SCM

You can run SQL queries in Server Configuration Monitor (SCM) to connect to relational databases such as SQL Server, PostgreSQL, Oracle, and MySQL. When adding configuration elements for monitoring, there is now an option to chooses the element type Database query. The connection string drop-down menu contains one example connection string for each pre-installed driver, and a list of all connection strings used in all elements. The following macros are available in the connection string:

  • ${NodeIP} - IP address of polled database

  • ${NodeHostname} - Hostname of polled database

  • ${Username} - assigned credential username

  • ${Password} - assigned credential password

The following is an example of a connection string:

Driver={MariaDB ODBC 3.1 Driver};Server=${NodeIP};User=${Username};Password=${Password};Option=3;Port=3306

Custom ODBC Drivers

You can poll the database with any other driver if you install it on the poller. Only 32-bit drivers are allowed because the process that it polls is a 32-bit process.