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"