Netbackup reporting with Sybase SQL Anywhere query

Question

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?
&nbsp;
Cheers,
SS

arojasbe · Accepted Answer

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 · Answer

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

netbackup_toddl · Answer

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?

Forum Discussion

Netbackup reporting with Sybase SQL Anywhere query

3 Replies

Related Content

Report Restore

Saving a Report Schedule - Cron

NetBackup to backup Sybase SQL anywhere DB

Question on IT Analytics SLP report

Netbackup policyies reports

Recent Discussions

netbackup opscenter 10.0.01 able to fetch data collection from netbackup master10.1

OpCenter alerts with blank report. SQL Query not fetching with the reports.

How to Remove Duplicates Emails from MS Outlook 2010

OpsCenter - 10939 error when adding new master server

Open your spellbook or skill menu DaD