This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Creating top 50 backup failure for databases

I am trying to create a custom view for top 50 backup failure for all the databases in my instances. Can anyone guide me on where I should be looking for such information? Should I be using a custom query or is the information stored in foglight already?

The 4 columns I am trying to get are

Instance name

DB name

Time since last successful backup

Error received

Thanks!

0 sriram_sivakumar over 9 years ago

The Data what you are looking for is already available in Foglight,

1) Write a query to get the list of Databases using the Topology Type "DBSS_Databases"

2) Create a row oriented table to get the Data what you are looking.
0 RaySee over 9 years ago

Thanks! I manage to find the items for the column but I still cannot find any information regarding failed back up. under DBSS_database
+1 sriram_sivakumar over 9 years ago

Hello RaySee,

You will find the data about the Failed jobs under the Type DBSS_Agent_Job_List, Where this will be a collection of Jobs for the instance and their details like Last run, status etc.