How to retrieve Field Values from the Database Monitor?

Created 2004-06-25 by Rainer Gerhards.

You probably have received the link to this page while looking at data generated by the database monitor.

If so, this is because you are looking at the "msg" part of a database monitor created message. The database monitor does NOT include values of the queried fields by default. Instead, it contains a link to this page, which tells you what you need to configure.

Database monitor field values are contained in the event properties. In order to obtain them, you must configure the output module (e.g. "Send Syslog" or "Write to File" action) to handle these properties. In general, they can be obtained by selecting XML output format or a custom string, which specifically queries the database attributes. To do so, please see the documentation of the output module your are using.

Alternatively, you can also instruct the database monitor to provide a CSV (or custom) representation inside the message text itself. To do so, please see the database monitor documentation (and there the "Advanced Options" tab).

If you experience problems configuring the database monitor according to your needs, please simply contact our support team at support@adiscon.com.