This UNIX shell script offers a front-end to the wtdumper command that ships with IBM Tivoli Enterprise Console. It allows for complex SQL queries of the event repository database without having knowledge of the internal details of the database.
IBM Tivoli Enterprise Console Event Repository Query Tool
This tool is a command line utility which runs under UNIX and the BASH shell under Windows. It takes the command line arguments, validates them, builds an SQL query, runs the "wtdumper -w" command with the query, and formats the output based on command-line switches.
The command line arguments consist of sets of event attribute names, and the value to search for in the database. A display parameter is also required.
For example, the following command will search the event repository for all TEC_Notice events with a hostname of host1, and will display all matches:
./query_er.sh -class TEC_Notice -hostname host1 -da
Disclosed by International Business Machines Corporation
1