Use the following Query:

It will output the following (where the backup_finish_date column is the last time the logs have been truncated):

Source