Microsoft SQL: Query Last Time Transaction Log was Truncated

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