there was a similar query the other day regarding which jobs are using specific media.

https://www-secure.symantec.com/connect/forums/which-job-using-media

You could use similar methodology to determine tape drives.

e.g.

bpdbjobs -all_columns|grep drive_name|cut -d "," -f1,5,6,7   (where fields 1,5,6 & 7 are JobID, Policy, Schedule & Client respectively)

would result in:

982850,Policy_1,Schedule_1,Client_1
982843,Policy_2,Schedule_2,Client_2

You can do it this way:

for i in `bpdbjobs -noheader|grep -i backup|grep -i active|awk '{print $1}'`; do echo "$i --  `bpdbjobs  -jobid $i  -all_columns |awk -F, '{print $49}'|awk '{print $6}'`" ; done

It will give you this output:  Jobid -- MediaID
It works _ONLY_ for active jobs.

 Just go to Actions in BAR, and Select the Option Preview Media. That's you will be able to get the media details for restore with out active drives.

Mark my Comment as Solution If you are satisfied.

Your question is:
How to find out what active backup jobs are using a tape drive needed for restore.

I think this solution will   be better.
If you know your drive name you simply can do  this:

for i in `bpdbjobs -noheader|grep -i backup| grep -i active |awk '{print $1}'`; do bpdbjobs  -jobid $i  -all_columns  |nawk -F, '/HP.ULTRIUM3-SCSI.000/ {print $1}' ; done

Put your Drive name instead of HP.ULTRIUM3-SCSI.000

As a result you'll have a list of jobs and you can use it to cancell them from bpdbjobs.

Thank you very much for all the solutions.

I'm sure they will be helpful for me.

Hi, this is a simple one

Follow the steps:
1) From restore window get the tape ID which are required for restore

2) on media server go to location /usr/openv/netbackup/bin/admincmd

3) type command ./nbrbutil -dump | grep -i <tape id>

4) from the output of the command search for "jobid=2629906".

5) you got the job id wich is using the given tape.

Cheers....