Hello
I want to create SQL query that will show backups that are completed but before it was missed or failed even once in for example 5 days backward.
I have created something like this to list missed backups but i don't know how to change this to work with above condition.
select node_name,completed,status from events where (status='Missed' and (scheduled_start>=current_timestamp - 5 days))
I want to create SQL query that will show backups that are completed but before it was missed or failed even once in for example 5 days backward.
I have created something like this to list missed backups but i don't know how to change this to work with above condition.
select node_name,completed,status from events where (status='Missed' and (scheduled_start>=current_timestamp - 5 days))