Want a command to find out all the nodes that have been failing or missing backups

[rohitrohitgeorge]

Want a command to find out all the nodes that have been failing or missing backups that have been failing or missing backups CONTINUOSULY for past 7 days.

Not all nodes failed or missed. but nodees that have been CONTINUOSULY missing and failing for past 7 days.

Thanks in Advance
Rohit

 

[Trident]

Hi,

This a sample, you can add a date statement too. Make sure your events table has data retention for 7 days.

select NODE_NAME,count(STATUS) from events where status<>'Completed' group by node_name having count(STATUS)>5

 

[gimlet]

Here's a query I use to see if any nodes have not backed up anything in the previous 24 hours:

select nodes.node_name as "NO BACKUP" from nodes where not exists (select distinct entity from summary where (end_time
between current_timestamp - 24 hours and current_timestamp) and (entity=nodes.node_name))