sp_help_log_shipping_secondary_database 'db'

secondary_id primary_server ...

when I run

select * from msdb..log_shipping_monitor_secondary

I see that the [last_restored_file] field is null.

running

sp_help_log_shipping_secondary_database 'server'

sp_help_log_shipping_secondary_primary 'server, 'db'

seems to bring back the right results.....