"Fossies" - the Fresh Open Source Software Archive

Member "bareos-Release-20.0.2/core/src/cats/dml/0041_uar_file" (10 Jun 2021, 440 Bytes) of package /linux/misc/bareos-Release-20.0.2.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 # List Jobs where a particular file is saved
    2 SELECT Job.JobId AS JobId,
    3        Path.Path||File.Name AS Name,
    4        StartTime,
    5        TYPE AS JobType,
    6        JobStatus,
    7        JobFiles,
    8        JobBytes
    9 FROM Client,
   10      Job,
   11      File,
   12      Path
   13 WHERE Client.Name='%s'
   14   AND Client.ClientId=Job.ClientId
   15   AND Job.JobId=File.JobId
   16   AND File.FileIndex > 0
   17   AND Path.PathId=File.PathId
   18   AND File.Name='%s'
   19 ORDER BY StartTime DESC
   20 LIMIT 20