Re: SQL query ??
1999-04-06 07:55:20
Can't you just work out how much active data there is from the filespace
entries (filespace size and utilisation), and then extract that from the total
amount of data stored for the tape pool?
Trevor
> -----Original Message-----
> From: Dick Nieuwenhuizen [SMTP:dnieuwen AT SOLAIR1.INTER.NL DOT NET]
> Sent: Tuesday, 6 April 1999 9:09 pm
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: SQL query ??
>
> Hi all,
>
> My management asked me too find out how much tapepool space is occupied
> by deleted and inactive files. I looked at the SQL Interface and tried
> some select commands, but I can't find how I can get the size of the
> files that are being backed up.
>
> Can someone help me with a SQL query that will display the size of
> deleted and inactive files, or any other solution to get this
> information.
>
> Thanks in advance
>
> Dick
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- SQL query ??, Dick Nieuwenhuizen
- Re: SQL query ??, Roger Hohmann
- Re: SQL query ??,
Trevor Foley <=
- Re: SQL query ??, Dick Nieuwenhuizen
- Re: SQL query ??, Dick Nieuwenhuizen
- Re: SQL query ??, Russell Street
- Re: SQL query ??, Dick Nieuwenhuizen
- Re: SQL query ??, Trevor Foley
- Re: SQL query ??, Russell Street
- Re: SQL query ??, Dick Nieuwenhuizen
- Re: SQL query ??, Dick Nieuwenhuizen
- SQL query ??, Dick Nieuwenhuizen [SMTP:dnieuwen
- Re: SQL query ??, Dick Nieuwenhuizen [mailto:dnieuwen
|
|
|