SELECT  r.destination_database_name ,
   r.restore_Date,
        r.user_name ,
        b.database_creation_date ,
        b.backup_start_date ,
        b.backup_finish_date ,
        b.compatibility_level ,
        b.database_name ,
        b.server_name ,
        b.machine_name ,
        b.recovery_model,
		r.destination_database_name
FROM    [msdb].[dbo].[restorehistory] r
        JOIN [msdb].[dbo].backupset b ON r.backup_set_id = b.backup_set_id
ORDER BY r.restore_date DESC