SQL Query last good backup

[Lion13]

Hello there, 

I'm not very good at script. 

Is it possible via OpsCenter have a SQL query that will give me every day for the entire work day, date and time of the last good backup. 

environment:

netbackup 7.5.0.6

OS Windows 2008R2 

OPScenter 

thank you

[RamNagalla · Accepted solution]

yes, it is possible through Symatec Opscenter.

go to OpsCenter WEB interface---> reports--> report templetes

you can also schedule these reports to deliver to your mail id as per your requirement.

other than that they are lot of reports avaliable

have a look into the below guide

http://www.symantec.com/business/support/index?page=content&id=DOC5044

[RiaanBadenhorst]

You dont need to know how to write sql queries, there are standard reports that can provide this information. check the section as suggested by Nagalla

[Lion13]

Thank you for answer 

I found no standard report which matches my needs and I'm still looking for a solution. 

thank you

[Lion13]

Thank you for answer 

I found no standard report which matches my needs and I'm still looking for a solution. 

thank you

[CRZ]

Try asking in the OpsCenter forum?