Weekly report of the events (situations being triggered)

You might want to implement the following procedure:
1) On your TEPS change the $CANDLEHOME/CNPS/kfwenv (direct editing or
from MTMS edit) contents for
KFW_PRUNE_START = hh:mm (in 24 hours format, ex. 03:00) default 00:00
KFW_PRUNE_END = hh:mm (ex 05:00) default 04:00
KFW_EVENT_RETENTION = d (where d is number of days to keep) default 1
2) Create a new query with the formula
Open Query Editor
Clic Create New button
Select a category (ex. Warehouse Proxy)
Select ODBC TEPS
Enter name, description and formula: SELECT * FROM KFWTSIT
3) Create a new view in a workspace (or change an existing one) with the
query created in step 2. You might want to modify the filters to reduce
the number of attributes displayed.

You must recycle the TEPS to activate the changes in kfwenv. Naturally it will take some time (value d in step 1) to have the full period. In the view created in step 3 you can export in a csv file. You can save the workplace to a new one.

Taken from: http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14341125&tstart=0#14341125