Thanks for your contribution during your rest!
George H.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Steven Harris
Sent: Wednesday, July 29, 2009 8:36 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Summarizing Tape Utilization
Hi George
a
>
> Huebschman, George J. wrote:
> >No, just the command line
> >
> >-Original Message-
> >From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
> >Lindsay Morris
> >Sent: Wednesday, July 29, 2009 4:40 PM
> >To: ADSM-L@VM.MARI
4:40 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Summarizing Tape Utilization
George, aren't you a Servergraph user? Doesn't it give you what you
need? I don't know what you're trying to accomplish here, but
Servergraph handles the usual culprits...
--
No, just the command line
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Lindsay Morris
Sent: Wednesday, July 29, 2009 4:40 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Summarizing Tape Utilization
George, aren't you a Servergraph
:ads...@vm.marist.edu] On
Behalf Of
Huebschman, George J.
Sent: Wednesday, July 29, 2009 10:59 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Summarizing Tape Utilization
Greetings everyone,
I have a/an SQL Select question.
Most of my TSM Servers are at 5.5.1.0, one is at 5.5.2.0
I am trying to count
This is not really possible without using subqueries which TSM does not
support. Just pipe it through perl, something like this:
#!/usr/bin/perl
use POSIX qw(floor);
my %tapes;
while ()
{
chomp;
(my $pct, my $pool) = split /\s+/, $_;
$tapes{$pool}{floor (($pct - .01) / 10)}++;
}
for my $po
schman, George J.
Sent: Wednesday, July 29, 2009 10:59 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Summarizing Tape Utilization
Greetings everyone,
I have a/an SQL Select question.
Most of my TSM Servers are at 5.5.1.0, one is at 5.5.2.0
I am trying to count the number of tapes with a percentage
Greetings everyone,
I have a/an SQL Select question.
Most of my TSM Servers are at 5.5.1.0, one is at 5.5.2.0
I am trying to count the number of tapes with a percentage utilization
in brackets of 10 percent. In other words, how many tapes with
utilization between 100 and 90, 90 and 80, and so fo
