NetApp SnapManager – Get Latest Successful Snap from Repo Database

Just started working with NetApp SnapManager and one of the questions I had was how can I find the latest successful snap per host for each database. Well looking around the smo repository we see a table called SMO_33_OPERATIONHISTORY. Now we can write a query to get the data we need.

Looks like exactly…