• State Verified Answer
  • Locked Locked
  • Replies 3 replies
  • Subscribers 60 subscribers
  • Views 4387 views
  • Users 0 members are here
Options
Related
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

RaySee
over 7 years ago

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!

Parents
  • 0 over 7 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.

Reply
  • 0 over 7 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.

Children
No Data