Re: [ADSM-L] Request for some TSM queries to use
2009-01-08 09:10:14
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Larry Clark
Sent: Wednesday, January 07, 2009 5:57 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Request for some TSM queries to use
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>'
This electronic transmission and any documents accompanying this electronic
transmission contain confidential information belonging to the sender. This
information may be legally privileged. The information is intended only for
the use of the individual or entity named above. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution,
or the taking of any action in reliance on or regarding the contents of this
electronically transmitted information is strictly prohibited.
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] Antwort: [ADSM-L] Greetings & request for help, (continued)
- [ADSM-L] Antwort: [ADSM-L] Greetings & request for help, Ullrich Mänz
- Re: [ADSM-L] Greetings & request for help, Yudi Darmadi
- [ADSM-L] AW: [ADSM-L] Greetings & request for help, Bethke, Ralph
- Re: [ADSM-L] AW: [ADSM-L] Greetings & request for help, Yudi Darmadi
- [ADSM-L] AW: [ADSM-L] AW: [ADSM-L] Greetings & request for help, Bethke, Ralph
- Re: [ADSM-L] AW: [ADSM-L] AW: [ADSM-L] Greetings & request for help, Andrew Raibeck
- Re: [ADSM-L] AW: [ADSM-L] AW: [ADSM-L] Greetings & request for help, Yudi Darmadi
- [ADSM-L] Request for some TSM queries to use, Larry Clark
- Re: [ADSM-L] Request for some TSM queries to use, Huebner,Andy,FORT WORTH,IT
- Re: [ADSM-L] Request for some TSM queries to use, Larry Clark
- Re: [ADSM-L] Request for some TSM queries to use,
Bob Levad <=
- Re: [ADSM-L] Request for some TSM queries to use, Bob Levad
- [ADSM-L] TDP for Oracle - multi channel restore, Richard Rhodes
- Re: [ADSM-L] TDP for Oracle - multi channel restore, goc
- Re: [ADSM-L] TDP for Oracle - multi channel restore, Richard Rhodes
- Re: [ADSM-L] TDP for Oracle - multi channel restore, Mark Scott
- [ADSM-L] TSM 6 announcement date?, Remco Post
- Re: [ADSM-L] TDP for Oracle - multi channel restore, Richard Sims
- Re: [ADSM-L] TDP for Oracle - multi channel restore, Oscar Kolsteren
- Re: [ADSM-L] TDP for Oracle - multi channel restore, goc
- Re: [ADSM-L] TDP for Oracle - multi channel restore, Richard Rhodes
|
|
|