Re: [ADSM-L] Total Data Stored by TSM?

Thanks for that.

Now, I'm assuming that includes active and inactive copies of files?

If so, is there a way to get a figure for just active?

The reason I ask is that I am being asked how much data would need to be backed 
up if we had to completely backup all of our servers again. Now, I guess I 
could go to every single machine and extract that data (slow), or run the q 
occup command and then add up all the Occupied (MB) entries, but there must be 
an easier way... I hope :-)

Thanks again

Farren




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
goc
Sent: 11 June 2008 10:36
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Total Data Stored by TSM?

select sum(PHYSICAL_MB) MB from occupancy

On Wed, Jun 11, 2008 at 11:08 AM, Minns, Farren - Chichester
<fminns AT wiley DOT com> wrote:
> Hi all
>
> What is the command to run (if there is one) to find out the total amount of 
> data currently stored by a TSM server, or can it only be done via an SQL 
> script?
>
> Thanks in advance
>
> Farren Minns
>
> ------------------------------------------------------------------------------------------------------------
> This email (and any attachment) is confidential, may be legally privileged 
> and is intended solely for the
> use of the individual or entity to whom it is addressed. If you are not the 
> intended recipient please do
> not disclose, copy or take any action in reliance on it. If you have received 
> this message in error please
> tell us by reply and delete all copies on your system.
>
> Although this email has been scanned for viruses you should rely on your own 
> virus check as the sender
> accepts no liability for any damage arising out of any bug or virus 
> infection. Please note that email
> traffic data may be monitored and that emails may be viewed for security 
> reasons.
>
> John Wiley & Sons Limited is a private limited company registered in England 
> with registered number 641132.
>
> Registered office address: The Atrium, Southern Gate, Chichester, West 
> Sussex, PO19 8SQ.
> ------------------------------------------------------------------------------------------------------------
>
------------------------------------------------------------------------------------------------------------
This email (and any attachment) is confidential, may be legally privileged and 
is intended solely for the 
use of the individual or entity to whom it is addressed. If you are not the 
intended recipient please do 
not disclose, copy or take any action in reliance on it. If you have received 
this message in error please 
tell us by reply and delete all copies on your system.
 
Although this email has been scanned for viruses you should rely on your own 
virus check as the sender 
accepts no liability for any damage arising out of any bug or virus infection. 
Please note that email 
traffic data may be monitored and that emails may be viewed for security 
reasons.

John Wiley & Sons Limited is a private limited company registered in England 
with registered number 641132.

Registered office address: The Atrium, Southern Gate, Chichester, West Sussex, 
PO19 8SQ.
------------------------------------------------------------------------------------------------------------