SELECT secondary_database,
last_restored_file,
last_restored_date
FROM msdb.dbo.log_shipping_secondary_databases 

SELECT  primary_database ,
        last_copied_file ,
        last_copied_date ,
        last_copied_date_utc ,
        last_restored_file ,
        last_restored_date ,
        last_restored_date_utc ,
        last_restored_latency 
FROM msdb.dbo.log_shipping_monitor_secondary