Il faut passer par une requête sql , il faut utiliser le mode sql par la commande sqlquery :
| select Job.JobId, Job.Name, Job.StartTime, Job.Type, Job.Level, Job.JobFiles, Job.JobBytes, Job.JobStatus from Job join JobMedia on Job.JobId = JobMedia.JobId join Media on JobMedia.MediaId = Media.MediaId join Pool on Media.PoolId = Pool.PoolId where Pool.Name = '<nom_du_pool>' group by Job.JobId order by Job.JobId desc; |
Même requête indiquant la durée de rétention en jours :
| select Job.JobId, Job.Name, Job.StartTime, Job.Type, Job.Level, Job.JobFiles, Job.JobBytes, Job.JobStatus, Media.VolRetention, Media.LastWritten, (Media.VolRetention - extract(epoch from (now() - Media.LastWritten))) / 86400 as Days_To_Expire from Job join JobMedia on Job.JobId = JobMedia.JobId join Media on JobMedia.MediaId = Media.MediaId join Pool on Media.PoolId = Pool.PoolId where Pool.Name = '<nom_du_pool>' group by Job.JobId, Media.MediaId order by Job.JobId desc; |