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.
>>> [EMAIL PROTECTED] 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
