SQL Transaction log details through Rest API

[skjaerhus]

Hi,

Is it possible to query details about the SQL log shipping jobs through the Rest API?
I cant seem to find anything relating to the log shipping jobs in the API's.

I would basically like to list all SQL instances part of the logshipping jobs, and the restore points per database within them.
The problem being that there's no reports covering that in the products we have today, Please correct me if im wrong. : B&R Enterprise, Enterprise Manager, Licensed SCOM Management Pack.

When doing a restore of a SQL database in Enterprise manager that's covered by a log shipping job I can see that enterprise manager has the up to date information about the last log shipping task when looking at "point in time" restore time available.

[oleg.feoktistov]

Hi,

As of now, log shipping jobs are not exposed neither through EM nor VBR REST API.
You can still get them through Powershell, but it's a question for different subforum.

Thanks,
Oleg