Back to Geneos FAQ

How can I extract a large number of gateway events from my database

Within the Active Console, you can right click on the event ticker and select the Import option which allows you to import historical events into the ticker for review. However performance problems may arise if the results set is large (thousands of events). An alternative is to run an SQL statement directly on the database to which the events are being logged.

There is some support for getting the required SQL statement that makes this possible. This requires doing the following steps:

  1. Put the Console into debug mode. See Startup settings.
  2. Right click on the event ticker and select import, and select the time period of choice, plus any other restrictions you want.
  3. Run the import and the SQL that it uses will now display in the output window (because the console is in debug mode).

Active Console import dialog

Active Console output window

The SQL statement is shown in blue above, you can copy this and paste it into a query window for your database to get back the full result set independently of the console.

["Geneos"] ["Geneos > Active Console"] ["FAQ"]

Was this topic helpful?