Hello all, I would like to have a script / select that shows me only the processes currently running that are using tapes. It should display - process number, process name, drive name, volume name. I'm using the processes table and the status column to pull out the volume - LIKE '%500___L4% . All our tapes are 500---L4 . And I'm using the drives table to get the drive and volume name. So I need to compare the processes table LIKE results to the drives table volume name and display when they match. This is the closest I can come but it lists all the processes with each volume in use. As in: if there are 3 processes running using 3 different tapes I get 9 lines displayed.
select processes.process_num, processes.process, processes.status, drives.drive_name, drives.volume_name from processes, drives where processes.status like '%500___L4%' and drives.volume_name like '%500___L4%'
Any help is greatly appreciated! Thank you !!!
select processes.process_num, processes.process, processes.status, drives.drive_name, drives.volume_name from processes, drives where processes.status like '%500___L4%' and drives.volume_name like '%500___L4%'
Any help is greatly appreciated! Thank you !!!