ODBC query service

The ODBC query service, formerly called Generic ODBC Service, monitors the results of an ODBC query sent to a SQL database.

The data returned by the ODBC query is then evaluated against the regular expressions specified in the service.

When setting up the connection, the username and password must be an SQL user account. A Windows account will not connect.

Service TypeODBC
Instances on a Device50
Supported Systems/ApplicationsODBC-compliant SQL servers
Device ClassServer - Generic and Server - Windows
Monitored ByAgent (Windows and Red Hat Linux), Windows probe
Scan Interval5 minutes
ODBC Driver NameThe name of the ODBC driver that allows the Generic ODBC service to query the specified database.
Database PortThe port on which the database accepts incoming queries.
Database NameThe name of the database to be queried.
Database UsernameThe SQL username that is used to access the database. This cannot be a Windows account user name.
Database PasswordThe SQL password that is used to access the database. This cannot be a Windows user account password.
Database QueryThe SQL query statement that is submitted to the database.
Column 1 Name

The name of the database values that are being queried for the value.

Column 2 Name
Column 3 Name
Column 1 Regular ExpressionThe values that N-able N-central should look for in the results of the ODBC query.
Column 2 Regular Expression
Column 3 Regular Expression

ODBC Driver Support

Agent/ProbeODBC Driver and Version
MDAC ODBC Driver 2.8Unix ODBC Driver 2.2.10Postgres SQL ODBC Driver 8.01
Windows agent


Red Hat agent xx
Suse agent xx
Windows probex  

Status details

Status DetailDescription
Transaction time in millisecondsThe total transaction time to connect, authenticate, send a query, retrieve results, and disconnect.
Rows returned by the queryThe number of rows returned by a query.
Rows returned by the query that matched all column regular expressionsThe number of rows that matched all of the column regular expressions.