Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Netbackup reporting with Sybase SQL Anywhere query

Created: 22 Aug 2013 • Updated: 22 Aug 2013 | 3 comments
This issue has been solved. See solution.

Hi Guys,

Hope you all are doing good.

I am trying to get some customized data using sql query in Ops Center. Like getting latest 10 backup reports for each client.

The thing I am struggling with I need the table list where I could get those data. I am confident about sql writing but I need to know the associated table names.

Could some one give me any idea to get through this?

Cheers,

SS

Operating Systems:

Comments 3 CommentsJump to latest comment

Arojasbe's picture

Hi SS

You can read the post I wrote Cesar Arbizu, which left the Opscenter_Schema_v2.pdf where you have all the tables and fields most

The URL is:

http://www.symantec.com/connect/forums/looking-custom-opscenter-analytics-sql-script

I hope it will be helpful

Regards

Alfredo Rojas

SOLUTION
netbackup_toddler's picture

Hi, I was just going through the schemas. But lost myself.

Actually I am looking for a query which will show me the last 10 backup job status for every client.

But couldn't sort it out. Any idea?