Restore history Details for sql databases.....

How do we find restore history details for all databases in the server?

Or single database?

—-for all databases

USE MSDB

GO

SELECT TOP 1 *

FROM RESTOREHISTORY WITH (nolock)

--for individual database include below commands

WHERE (DESTINATION_DATABASE_NAME = ‘dbname’)

ORDER BY RESTORE_DATE DESC

Let me know any other ways?