ADSM-L

Re: Looking for query for usage per filespace

1999-12-23 13:58:19
Subject: Re: Looking for query for usage per filespace
From: "John M. Sorensen" <sorensen AT STORSOL DOT COM>
Date: Thu, 23 Dec 1999 11:58:19 -0700
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

<Prev in Thread] Current Thread [Next in Thread>