Difference between revisions of "OdbcQuery Monitoring Subagent"

Revision as of 10:28, 28 June 2012

Redirect to:

@@ Line 1: / Line 1: @@
-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.
+#REDIRECT [[Subagent:ODBCQuery]]
-= Provided Parameters =
-{| 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''