How to find tapes that has been set offline 1

[Spanjis]

I just ran:
upd vol * acc=Off lo='off' wherestg=tapecopy whereacc=readw,reado wherest=fill,ful

i forgot to copy the volume name, how can i find them again?

tried with something like query volume stg=tapecopy access=off location=off, but didnt work.

Any tips?

Thanks!

 

[mbourne2006]

Try "query actlog begint=hh:mm"

where hh:mm is a time slightly before you ran the update

HTH

Kind Regards,
Matthew Bourne
"Find a job you love and never do a day's work in your life.

 

[ProbablyDown]

Or search the volumes table directly - "select volume_name, chg_time from volumes where chg_time like '2006-10-13*'"

Then you only have to know the date and you can browse the time. You may have to cast the date tho i.e. ...where cast (chg_time as date)...

 

[Spanjis]

Thanks guys, worked like a charm