This is a module for monitoring any data from any database accessible through ODBC (tested on Linux with unixODBC and MyODBC).
It requires the tclodbc package to be installed (can be found at http://sourceforge.net/projects/tclodbc).
Note that although this module is for Linux, the SQL server to be monitored could be running on any remote machine, or ne anything accessible via ODBC.
Data is retrieved using the SELECT * FROM table query if a table name is passed as argument using the --t (--table) switch, or using the query passed as argument using the --q (--query) switch (SELECT queries work, as may others that return row/column data). Resulting data is initially displayed in 1 table.
Module options:
Examples:
$ moodss odbcquery --dsn test -t base.table $ moodss odbcquery --dsn hr --user root --password xxx --table compamy.employees $ moodss odbcquery --dsn test -q 'select * from database.table order by column' $ moodss odbcquery --dsn mysqltest --query 'show variables'