Re: Request for some TSM queries to use

2009-01-08 Thread Bob Levad
equest 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='' This electronic transmission and any documents accompan

Re: Request for some TSM queries to use

2009-01-07 Thread Larry Clark
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=''

Re: Request for some TSM queries to use

2009-01-07 Thread Bob Levad
...@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 queries to use Hi, My TSM query usage is a bit rusty. These days it's VIO builds but I need to participate in a customer DR exercise and wi

Re: Request for some TSM queries to use

2009-01-07 Thread Huebner,Andy,FORT WORTH,IT
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 fo

Request for some TSM queries to use

2009-01-07 Thread Larry Clark
Hi, My TSM query usage is a bit rusty. These days it's VIO builds but I need to participate in a customer DR exercise and will be restoring files to AIX servers by fs (mount point). To avoid resource conflicts I'd like to be able to determine what filespaces are on what volumes by node. Would this