Re: Help me convincing IBM please!!!!
2005-04-07 10:00:35
On Thu, 07 Apr 2005, Loon, E.J. van - SPLXM might have said:
> Hi *SM-ers!
> Please help me with this and take the time to read this request!!!!
tsm: ADSM>select activity, cast ((end_time) as date) as "Date"
,(examined/cast((end_time-s tart_time) seconds as decimal(18,13))
*3600) "Objects Examined Up/Hr" from summa ry where
activity='EXPIRATION' and days (end_time)-days(start_time)=0
ACTIVITY Date Objects Examined Up/Hr
------------------ ---------- ---------------------------------
EXPIRATION 2005-03-08 1069200
EXPIRATION 2005-03-09 1101600
EXPIRATION 2005-03-10 842400
EXPIRATION 2005-03-11 889200
EXPIRATION 2005-03-12 770400
EXPIRATION 2005-03-13 781200
EXPIRATION 2005-03-14 828000
EXPIRATION 2005-03-15 1065600
EXPIRATION 2005-03-16 1130400
EXPIRATION 2005-03-17 842400
EXPIRATION 2005-03-18 633600
EXPIRATION 2005-03-20 558000
EXPIRATION 2005-03-21 702000
EXPIRATION 2005-03-22 1080000
EXPIRATION 2005-03-23 918000
EXPIRATION 2005-03-24 849600
EXPIRATION 2005-03-25 918000
EXPIRATION 2005-03-26 748800
EXPIRATION 2005-03-27 864000
EXPIRATION 2005-03-28 795600
EXPIRATION 2005-03-29 1108800
EXPIRATION 2005-03-30 1134000
EXPIRATION 2005-03-31 831600
EXPIRATION 2005-04-01 896400
EXPIRATION 2005-04-02 770400
EXPIRATION 2005-04-03 788400
EXPIRATION 2005-04-04 777600
EXPIRATION 2005-04-05 1249200
EXPIRATION 2005-04-06 1000800
When you get your results compiled, please send the results back to the list.
Mike
|
|
|