Drop the "not" and it will work fine. You might want to order by node_name.
Bob
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Larry Clark
Sent: Wednesday, January 07, 2009 5:57 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Request for som
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=''
Larry,
Your query works fine if you switch the double quotes to single quotes.
This query will tell you where every node resides.
select distinct vu.stgpool_name, -
vu.node_name, -
vu.volume_name, -
v.pct_utilized -
from volumeusage vu, -
volumes v -
where
You need to change the " to '
Other than that it works fine.
Andy Huebner
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Larry
Clark
Sent: Wednesday, January 07, 2009 3:16 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Request for some TSM que
