08-22-2013 12:29 AM
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
Solved! Go to Solution.
08-22-2013 12:11 PM
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
08-22-2013 12:11 PM
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
08-22-2013 06:19 PM
Thanks Alfredo. It will serve the purpose for me I believe.
08-22-2013 06:35 PM
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?