Q Vol question

[ukmarkh]

Guys,

How can I run a query that shows how many tapes in the library are showing as =Full

We have hundreds of tapes and I just need to quickly display on screen which ones are full?

Is this possible? I don't want to see all the other tapes that show filling and other... would really make things easier for me.

 

[ChrisRees]

Hi
Just use q vol * status=full

or Use this SQL

select volume_name from volumes where status='FULL'

Out of interest, why does this info make your life easier ? I never worry about which volumes are Full

Cheers