Geneos - 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.  To do this:

1. Put the Console into debug mode
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)

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.