Custom SQL Query Report to Display Last Backup of Each File

Has anyone had any luck displaying backup details for individual files?  For instance, I'd like to display the last successful backup date for each file within a given policy's filelist.

I'm new to OpsCenter's custom reporting so any help is greatly appreciated.

Thanks.