Stuff

select distinct VolumeName
from Job, JobMedia, Media
where 
  Job.Name = 'your hostname here' and 
  Job.JobId = JobMedia.JobId and 
  JobMedia.MediaId = Media.MediaId;