Netbackup reporting with Sybase SQL Anywhere query

[netbackup_toddl]

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

[Arojasbe · Accepted solution]

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

[netbackup_toddl]

Thanks Alfredo. It will serve the purpose for me I believe.

[netbackup_toddl]

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?