ADSM-L

Re: select statement

2002-11-27 07:44:57
Subject: Re: select statement
From: "Cook, Dwight E" <DWIGHT.E.COOK AT SAIC DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 27 Nov 2002 04:39:36 -0800
You can do the math in the statement

tsm: TSMSRVxx>select avg  (total_mb/1024)  as "Average Total GB" from
auditocc

Average Total GB
----------------
              26   (small tsm server)

OR
tsm: TSMSRVxx>select avg  (total_mb/1024)  as "Average Total GB" from
auditocc

Average Total GB
----------------
            7106         (a bigger tsm server)

Dwight



-----Original Message-----
From: Jamshid Akhter [mailto:jamshid_akhter AT hotmail DOT com]
Sent: Saturday, November 23, 2002 5:55 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: select statement


select sum(total_mb) datamgr from auditocc
Example result  13 222 225 which is approximately 13 GB
I don't see the column GB in this table.

Hope that will help



----- Original Message -----
From: "Ruksana Siddiqui" <Ruksana.Siddiqui AT AMCOR.COM DOT AU>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Thursday, November 21, 2002 11:08 PM
Subject: select statement


> Hi there,
>
> What is the select statement I can use to grab the avg_total in GB of each
> client the TSM server is backing ..?
>
> With regards,
>
> CAUTION - This message may contain privileged and confidential information
intended only for the use of the addressee named above. If you are not the
intended recipient of this message you are hereby notified that any use,
dissemination, distribution or reproduction of this message is prohibited.
If you have received this message in error please notify AMCOR immediately.
Any views expressed in this message are those of the individual sender and
may not necessarily reflect the views of AMCOR.
>

<Prev in Thread] Current Thread [Next in Thread>