Recently in my organisation, i had to provide results that adding SCOM Recovery is efficient as well as working properly.
My first thought was to check Kevin Holman’s SQL query list and couldn’t find anything on it
So next was to find anything for this on the internet, however I end up with nothing.
So after some digging around SCOM OpsDB Tables & views i was able to figure out this SQL query.
If you want to get results of only those Recovery which were created through SCOM Console you can remove the comment tags from the last line
FROM [OperationsManager].[dbo].[RecoveryJobStatusView] b , [OperationsManager].[dbo].[RecoveryView] r
WHERE b.[RecoveryId] = r.Id
— and r.Name like ‘%MomUIGenaratedRecovery%’
Hope this helps you out