TEC Event Group Filters

[blx]

Hope someone can help !
I want to create some Event Group filters using an SQL Constraint rather than use the GUI.
However, what I don't know is, after an event arrives in the reception log, and is processed, what Database table is it put into.
I'm looking to do something like:
Select * from ?????
Where etc etc

Thanks in Advance

 

[bppbme]

After an event is processed, it goes to the event repository. The main table is called tec_t_evt_rep. The schema is described in the TEC 3.6 Release Notes, and the 3.7 Reference Manual.

I am a little confused as to exactly what you want to do though. You say you want to Select * from <table> where <whatever>. If you mean you want to do something like:

wconsole -addegflt .... -S &quot;<sql statement>&quot;

You do not specify the table. The free form sql is the WHERE clause.