Recovery Job report


I would like to produce a report detailing Restore jobs and the related backup job to determine how excessive the retention period of backup images is.

The Custom report i currently have is returning rows for some, but not all recovery jobs. I believe this is related to the table "backupJobImage" not having entries for all of the restore jobs.

Has anybody else looked into this type of report previously ?