> 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