Hi,
I try to get the date of the last snapshot date of each unique path in order to check their freshness.
Example:
Lets says, restic snapshots
return this:
bd23bb4f 2023-07-29 01:00:06 speyburn /home/ubackup/backups_sql
83d35ad7 2023-07-29 01:30:01 speyburn /var/www/my-project/prod/public_html/shared
868db2b2 2023-07-30 01:00:06 speyburn /home/ubackup/backups_sql
9cacceab 2023-07-30 01:30:01 speyburn /var/www/my-project/prod/public_html/shared
afc74b52 2023-07-31 01:00:06 speyburn /home/ubackup/backups_sql
d96d0439 2023-07-31 01:30:01 speyburn /var/www/my-project/prod/public_html/shared
24e6fb2d 2023-08-01 01:00:06 speyburn /home/ubackup/backups_sql
a033edd0 2023-08-01 01:30:01 speyburn /var/www/my-project/prod/public_html/shared
I want to get only to 2 last lines in this case.
But if one of those 2 backup went wrong (backups_sql
), output will be:
bd23bb4f 2023-07-29 01:00:06 speyburn /home/ubackup/backups_sql
83d35ad7 2023-07-29 01:30:01 speyburn /var/www/my-project/prod/public_html/shared
868db2b2 2023-07-30 01:00:06 speyburn /home/ubackup/backups_sql
9cacceab 2023-07-30 01:30:01 speyburn /var/www/my-project/prod/public_html/shared
d96d0439 2023-07-31 01:30:01 speyburn /var/www/my-project/prod/public_html/shared
a033edd0 2023-08-01 01:30:01 speyburn /var/www/my-project/prod/public_html/shared
And I want to have:
868db2b2 2023-07-30 01:00:06 speyburn /home/ubackup/backups_sql
a033edd0 2023-08-01 01:30:01 speyburn /var/www/my-project/prod/public_html/shared
I tried to use latest
associated with group-by
with no success.
Thanks