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 ----- Original Message ----- From: "Gill, Geoffrey L." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 02, 2001 5:23 PM Subject: select statement > Hello all, > > Can anyone help with this question? I'm wondering if it's possible to get > this from a select statement or other query. I want to find out how much > data all nodes backed up the previous night, how much time it took and maybe > the transfer rate. Put it in order by what took the longest. > > Thanks for the help. > > Geoff Gill > TSM Administrator > NT Systems Support Engineer > SAIC > E-Mail: [EMAIL PROTECTED] > Phone: (858) 826-4062 > Pager: (888) 997-9614 >
