Eric,

You need to specify the storage pool and what type of data you want.  This
will get rid of the "duplicate" lines you are seeing.

For example, I used this query on a client named STRAT, to see its backup
data in a pool called TAPEPOOL:

select node_name,filespace_name,physical_mb,stgpool_name from occupancy
where node_name='STRAT' and stgpool_name='TAPEPOOL' and type='Bkup'

John Sorensen
Storage Solutions Specialists, Inc.
719-548-1832
sorensen AT storsol DOT com
http://www.storsol.com