Difference between revisions of "Subagent:ODBCQuery"

Latest revision as of 18:13, 13 September 2022

This Wiki is deprecated and we are are currrently migrating remaining pages into product documentation (Admin Guide, NXSL Guide)

Information moved to documentation:

@@ Line 1: / Line 1: @@
-{{DISPLAYTITLE:ODBCQuery Subagent}}
+{{deprecated}}Information moved to documentation:
-This subagent periodically executes SQL queries and returns results and error codes as DCI parameters. SQL queries are specified in the agent configuration. As the name suggests, OdbcQuery uses ODBC API to access databases and execute queries. This subagent enables NetXMS to monitor virtually any database application.
-= Provided Parameters =
+https://www.netxms.org/documentation/adminguide/application-monitoring.html#application-database-monitoring
-{| class="wikitable" style="width: 50%"
-|-
-!Parameter !! Description
-|-
-|ODBC.QueryResult(''name'') || Returns the result of the query
-|-
-|ODBC.QueryStatus(''name'') || Returns SQL query error code (Integer)
-|-
-|ODBC.QueryStatusText(''name'') || Returns textual description of the SQL error code
-|-
-|}
-''name'' is the name of the query as defined in the configuration file (see below).
-= Configuration File =
-The subagent's configuration consists of one or more lines in the section *ODBC of the following format:
- Query = ''Name'':''ODBC DSN'':''SQL Query'':''Poll interval''