WITH LastRestores AS(SELECTDatabaseName = [d].[name] ,[d].[create_date] ,[d].[compatibility_level] ,[d].[collation_name] ,r.*,RowNum = ROW_NUMBER() OVER (PARTITION BY d.Name ORDER BY r.[restore_date] DESC)FROM master.sys.databases dLEFT OUTER JOIN msdb.dbo.[restorehistory] r ON r.[destination_database_name] = d.Name)SELECT *FROM [LastRestores]WHERE [RowNum] = 1