The 'select * from contents' command only gives you a list of the data that
resides on a tape volume.

node_name
type
filespace_name
file_name
aggregated
file_size
segment
cached

Maybe in conjuction with the 'select * from backups', but this command
doesn't tell the filesize

Does anybody know how to get de filesize using this select

Regards
Dick
bv
Roger Hohmann wrote:

> You can use the contents table (select * from contents), but: slooooow.
> And, I never hat a successful join.
> Maybe anyone has a better idea?
>
> -----Original Message-----
> From:   Dick Nieuwenhuizen [SMTP:dnieuwen AT SOLAIR1.INTER.NL DOT NET]
> Sent:   Tuesday, April 06, 1999 1: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