USE MSDB;

SELECT
	 destination_database_name as DBRestored  
	,restore_date as RestoreDate
	,b.database_name as SourceDB
	,physical_name as SourceFile
	,backup_start_date as BackupDate
	,h.user_name as RestoredBy

FROM  RestoreHistory h with (nolock)
INNER JOIN BackupSet b with (nolock) on h.backup_set_id = b.backup_set_id
INNER JOIN BackupFile f with (nolock)on f.backup_set_id = b.backup_set_id

ORDER BY DBRestored ASC,RestoreDate DESC

GO