ac3ab911_or_Log_Shipping__Transact_SQL___Run_this_procedure_on
[Stored procedure] sp_help_log_shipping_secondary_primary (Transact-SQL) [Description] This stored procedure retrieves the settings for a given primary database on the secondary server. [Run this procedure on] 
Secondary server
Monitor Log Shipping (Transact-SQL)