I must be missing something. What's interesting number? even whole #? Sung
"ADSM: Dist Stor Manager" <[email protected]> wrote on 09/19/2006 08:54:51 AM: > ACTIVITY Date Objects ExaminedUp/Hr > ------------------ ---------- --------------------------------- > EXPIRATION 2006-09-19 360000 > <----------------------- > > LOL > > if anyone interested the query looks like this : > > tsm: TSM01>q scr exp_perf f=lines > > Name Line Command > Number > ---------- ------ > ------------------------------------------------------------ > EXP_PERF 1 > 5 select activity, cast ((end_time) as date) as > "Date", > (examined/cast((end_time-start_time) seconds as > decimal > (18,13)) *3600) "Objects ExaminedUp/Hr" from > summary where > activity='EXPIRATION' and days (end_time) -days > (start_time)=0
