How To List Filenames, Volumes Tapes And Jobs Ids on Bacula Database View

You can create i view from this query, so you can get the filenames. create view files as SELECT CONVERT( Media.VolumeName USING utf8) as Volume , JobMedia.JobId as JobId , CONVERT( Filename.Name USING utf8) as FileName FROM ( ( bacula.JobMedia JobMedia INNER JOIN bacula.File File ON (JobMedia.JobId = File.JobId)) INNER JOIN bacula.Filename Filename ON (File.FilenameId [...]