Here's what I use. It's more for showing me the date, duration, and backup size than backup status, but it can be modified to show all statuses:
SELECT jobid, name, s.jobstatuslong as status, to_char(endtime::date, 'YYYY-MM-DD') as last_successful, to_char(date_part('epoch', endtime - starttime) * interval '1 second', 'HH24:MI:SS') as duration, jobfiles, jobbytes::bigint as size FROM job JOIN status s USING (jobstatus) WHERE level = 'F' AND jobstatus IN ('T', 'W') ORDER BY last_successful desc; In the WHERE clause: level = 'F' - only show full backups jobstatus IN ('T', 'W') - only show me successful and warning jobs. Take this out to see all statuses Hope that helps On Friday, September 1, 2023 at 11:14:49 AM UTC Tihomir Vlahovski wrote: > I was planning the same and my idea was to use the API - > https://docs.bareos.org/DeveloperGuide/api.html# > Still on my TODO list though > > Cheers, > -Tiho > > On Tuesday, August 22, 2023 at 11:58:57 AM UTC+3 Bruno Friedmann wrote: > >> I'm not sure to have 100% understood what you're looking for, if it is >> about finished jobs (then search in the database is fine) or actually >> running, planned and so on, which are only known by the director and are >> lost if there's a crash. >> >> >> On Monday, August 21, 2023 at 11:10:06 AM UTC+2 Guy Van Sanden wrote: >> >>> Can I get the status of jobs from the database directly? >>> I'm rebuilding my Zabbix template to monitor bareos jobs, but that part >>> is missing. >>> >>> I have this currently >>> >>> jobquery = "select distinct name from job where type = 'B' and clientid >>> in (select clientid from client where jobretention <> 0);" >>> -> gets the jobs >>> >>> for job in jobs: >>> statusquery = ("select * from job where name = '%s' order by endtime >>> desc" %(job['name'])) >>> >>> -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/c5c26210-dff8-408e-8073-70176103233fn%40googlegroups.com.