SCRIPT: How to check database restore history?

 SELECT 
       [restore_date]
      ,[destination_database_name]
      ,[user_name]
      ,[backup_set_id]
      ,[restore_type]
      ,[replace]
      ,[recovery]
      ,[restart]
  FROM [msdb].[dbo].[restorehistory]
  ORDER BY [restore_date] DESC