Hi there,

I'm new to this board. I hope I'm posting in the right place.

I wrote a simple script which shows you the total # of inactive files for a node.

>select count(*) as Total from backups where node_name='$1'
and state='INACTIVE_VERSION'

very simple..

But, what I'd like to do, is have another column which shows total size.. Is there a way to do this?

I also found this script online, which shows you a complete list..

> Select filespace_name as Filespace, hl_name as Directory,
ll_name as Filename, state as State from backups where
node_name='$1'

It would be great to also have a column for size.. Any ideas?

Thanks..

RPT