Y Lee
Sent: Monday, February 21, 2005 9:47 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select for Tape Storage Pool Report
Very nice
Even added the difference in counts. This select is very nice indeed.
I think you over estimated this group about 93 seconds thing..
I tried to combine two se
> group by -
> a.stgpool_name, -
> a.est_capacity_mb, -
> a.pct_utilized, -
> a.pct_logical, -
> a.recl_running, -
> a.reclaim, -
> a.maxscratch
>
> -----Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
> Behalf
.est_capacity_mb, -
a.pct_utilized, -
a.pct_logical, -
a.recl_running, -
a.reclaim, -
a.maxscratch
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Robert Ouzen
Sent: Friday, February 18, 2005 11:44 PM
To: ADSM-L@VM.MARIST.EDU
Sub
a.recl_running, -
a.reclaim, -
a.maxscratch
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Robert
Ouzen
Sent: Friday, February 18, 2005 11:44 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select for Tape Storage Pool Report
Hi Todd
T
ol_name,a.maxscratch
Regards Robert Ouzen
Haifa University
Israel
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Todd
Lundstedt
Sent: Saturday, February 19, 2005 12:00 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Select for Tape Storage Pool Report
I cre
I created this SQL select statement...
select -
cast(stgpool_name as char(22)) as "Stg Pool ", -
cast((est_capacity_mb/1024/1024) as decimal(5,2)) as "TB", -
pct_utilized as "Util", -
pct_logical as "Logi", -
cast(recl_running as char(4)) as "Run?", -
cast(reclaim as dec(3)