Hi Geoff
have a look at the summary table, my script is :
def scr sz_summ desc='XXXX - Display information for client node sessions'
upd scr sz_summ "select entity as node_name, date(start_time) as date, -"
upd scr sz_summ "cast(activity as varchar(10)) as activity, time(start_time)
as start, -"
upd scr sz_summ "time(end_time) as end, cast(bytes/1000000 as decimal(6,0))
as megabytes, -"
upd scr sz_summ "cast(affected as decimal(7,0)) as files, successful from
summary -"
upd scr sz_summ "where date(start_time)='$1' and activity='BACKUP' order by
megabytes desc"
run sz_summ 2001-09-30
def scr cl_summ desc='XXXX - Display information for client node sessions'
upd scr cl_summ "select entity as node_name, date(start_time) as date, -"
upd scr cl_summ "cast(activity as varchar(10)) as activity, time(start_time)
as start, -"
upd scr cl_summ "time(end_time) as end, cast(bytes/1000000 as decimal(6,0))
as megabytes, -"
upd scr cl_summ "cast(affected as decimal(7,0)) as files, successful from
summary -"
upd scr cl_summ "where entity like '%$1%' and activity='BACKUP' order by
entity desc"
run cl_summ <NODE_PATTERN>
hope this helps
|