ADSM-L

Re: [ADSM-L] Request for some TSM queries to use

2009-01-07 18:57:56
Subject: Re: [ADSM-L] Request for some TSM queries to use
From: Larry Clark <lclark01 AT NYCAP.RR DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 7 Jan 2009 18:56:52 -0500
How About this? Would it provide a list of volumes used by each node is a
storage pool?:

     select distinct volume_name,node_name,stgpool_name from volumeusage
where not stgpool_name='<my_store_pool_name>'