> I am not sure you will be able to do what you want even when you get > the selection criteria sorted out. The events table on our 5.1.7.2 server > does not have a column for completion time. If the same is true on your > server you will probably have to use 'query event' output to compute > durations.
I believe that information can be found in the summary table (but then theres no problem with the criterias). SELECT ENTITY AS NODE_NAME,(END_TIME-START_TIME) AS DURATION FROM SUMMARY WHERE UPPER(ACTIVITY)='BACKUP' AND CURRENT_TIMESTAMP-START_TIME<'2 00:00:00' regards, Anders Pontusson
