Give it a try with following macro. I use it to have an overview of the amount of data is backed up last night or archived.
Greetings, Michel Engels Software Consultant Devoteam Belgium DEFINE SCRIPT Q_OBJ DESC="Gives number of objects BU, AR, REST or RETR previous day(s)" UPDATE SCRIPT Q_OBJ "/************************************************/" UPDATE SCRIPT Q_OBJ "/* Script that reports all the objects that are */" UPDATE SCRIPT Q_OBJ "/* backed up, archived, restored or retrieved */" UPDATE SCRIPT Q_OBJ "/* at day-X */" UPDATE SCRIPT Q_OBJ "/* The X is the parameter that has to be given */" UPDATE SCRIPT Q_OBJ "/* mostly this will be 1 */" UPDATE SCRIPT Q_OBJ "/* Run as: run q_obj backup 1 */" UPDATE SCRIPT Q_OBJ "/* Run as: run q_obj archive 1 */" UPDATE SCRIPT Q_OBJ "/************************************************/" UPDATE SCRIPT Q_OBJ "set sqlmathmode round" UPDATE SCRIPT Q_OBJ "set sqldatetimeformat eur" UPDATE SCRIPT Q_OBJ "select entity as nodename, -" UPDATE SCRIPT Q_OBJ " date(start_time) as ""Date (D/M/Y)"", -" UPDATE SCRIPT Q_OBJ " time(start_time) as time, -" UPDATE SCRIPT Q_OBJ " substr(cast(end_time-start_time as varchar(17)),3,8) as elapsed, -" UPDATE SCRIPT Q_OBJ " cast(sum(affected) as varchar(10)) as ""Num Obj"", -" UPDATE SCRIPT Q_OBJ " case -" UPDATE SCRIPT Q_OBJ " when sum(bytes)>1073741824 then cast(sum(bytes)/1073741824 as varchar(10)) || ' Gb' -" UPDATE SCRIPT Q_OBJ " when sum(bytes)>1048576 then cast(sum(bytes)/1048576 as varchar(10)) || ' Mb' -" UPDATE SCRIPT Q_OBJ " when sum(bytes)>1024 then cast(sum(bytes)/1024 as varchar(10)) || ' Kb' -" UPDATE SCRIPT Q_OBJ " else cast(sum(bytes) as varchar(10)) -" UPDATE SCRIPT Q_OBJ " end as ""Bytes"" -" UPDATE SCRIPT Q_OBJ " from summary - " UPDATE SCRIPT Q_OBJ " where activity=upper('$1') and -" UPDATE SCRIPT Q_OBJ " start_time>=timestamp(current_date-$2 day,'18:00:00') and -" UPDATE SCRIPT Q_OBJ " start_time<=timestamp(current_date,'09:00:00') and -" UPDATE SCRIPT Q_OBJ " successful='YES' -" UPDATE SCRIPT Q_OBJ " group by entity,start_time,end_time"