select * from volumes where stgpool_name='BACKUPPOOL'

Note that stgpool names are case sensitive.  Issue "run q_columns
volumes" to see all the field names in the voume tape that you could
list individually or use in the where clause.

>>> Timothy.Hughes AT OIT.STATE.NJ DOT US 6/15/2006 11:33 AM >>>
Hello all,

I have a script/query question the query below
lists all the devclass=disk. How would I modify this in
a script to display the Backuppool disk's only using a
script? Right now I am just running the Query command
via the Admin Schedule.

Thanks in advance!

query volume devclass=disk


/dev/rstg024r             BACKUPPOOL   DISK         21,056.0    0.0
On-Line
/dev/rstg025r             BACKUPPOOL   DISK         21,056.0    0.0
On-Line
/dev/rstg026r             BACKUPPOOL   DISK         21,056.0    0.0
On-Line
/dev/rstg027r             BACKUPPOOL   DISK         21,056.0    0.0
On-Line
/mig0/mig0.dsm         SPACEMGPOOL  DISK       13,000.0   53.9
On-Line
/mig1/mig1.dsm         SPACEMGPOOL  DISK       13,000.0   52.1
On-Line
/stg3/stg30.dsm         ARCHIVEPOOL  DISK          6,800.0    0.0
On-Line
/stg3/stg31.dsm         ARCHIVEPOOL  DISK          6,800.0    0.0
On-Line
/stg3/stg32.dsm         ARCHIVEPOOL  DISK          6,800.0    0.0
On-Line

TSM 5.3.3
AIX 5.3