SQL query to know AX database restore history

SELECT [rs].[destination_database_name] ,

[rs].[restore_date] ,

[bs].[backup_start_date] ,

[bs].[backup_finish_date] ,

[bs].[database_name] AS [source_database_name] ,

[bmf].[physical_device_name] AS [backup_file_used_for_restore]

FROM msdb..restorehistory rs

INNER JOIN msdb..backupset bs ON [rs].[backup_set_id] = [bs].[backup_set_id]

INNER JOIN msdb..backupmediafamily bmf ON [bs].[media_set_id] = [bmf].[media_set_id]

ORDER BY [rs].[restore_date] DESC