Re: Looking for query for usage per filespace
2015-10-04 17:35:05
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
|
|
|