I know that I have +/- as much inactive as active data (about 155Gb). Your 
solution doesn't tell the difference between inactive and deleted files, and 
that's what I also want to know.

Thanks anyway
Dick

Trevor Foley wrote:

> 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