xyzulu Not sure if this will work for v12 as we are still on v11 but this is how I check for failed backups each day
Access the postgres container
sudo docker exec -it orchd-postgres psql -U enhance
And then run
select website_id,started_at from (select website_id, started_at,finished_at, snapshot_dir_name, row_number() over(partition by website_id order by finished_at desc) as p from backups) as foo where p=1 and snapshot_dir_name is null;
This gives me the website id for any website that did not backup when it last ran. I am "guessing" for v12 you might need to use something like this to access postgres
orchd-postgres psql -U enhance
