manu.manohar033 - Friday, December 15, 2017 1:07 AM
Welcome to SSC Manu,
Please take a look at MSDB tables, primarily backupset, and the other logshipping tables, that will give you the information you need.
If you get stuck please post back with the query you have generated along with what is not working for you specifically.