Get last snapshot of each path

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 latestassociated with group-by with no success.

Thanks

latest or --latest? I think restic snapshots --group-by path --latest 1 might be what you’re looking for.

1 Like

That was that, so simple…
Thanks a lot