05-28-2013 06:02 PM
Hi all
I am new to OpsCenter. I want to know how many TB my media server backed up during the last X days
So in short I want to reproduce the query that is populated in the "Job Summary by Job Status" dashboard. That dashboard only shows the last 3 days. I want to use the same quesry but to show the last X days and use it to go back in time.
Anybody know how I can achieve this?
I looked through the canned reports but no luck so far
Thanks!
Solved! Go to Solution.
05-30-2013 12:24 PM
05-30-2013 10:24 AM
Are you using OpsCenter (the free version that comes with NetBackup), or OpsCenter Analytics (separately licensed, extra cost)? I have the Analytics option and I don't know what the free version includes or lacks, but I could try to help. Also, make sure you are using the most current version of OpsCenter, even if it is a higher version than your NetBackup installation.
05-30-2013 12:24 PM
05-30-2013 12:33 PM
I guess I could have been nice and converted the bytes to TB for you.... But what fun would that be ;)
05-30-2013 05:58 PM
@Ron : For your info I am using OpsCenter Analytics 7.5
@Miles: That worked like a charm. Don't worry about the TB conversion, you did all the hard work I can take care of converting the results :)
Question for you: where did you get the table names and field names? I usually like to build queries (with MS SQL) but with OpsCenter I hit a wall. I don't know how to get the table names like I would usually do with ManagementStudio for SQL.
Thanks a lot for your help, I have the reports I needed!
05-31-2013 06:26 AM
Follow this guide to install Sybase Anywhere:
http://www.symantec.com/business/support/index?page=content&id=TECH141827&key=58330&actp=LIST
Once you map the ODBC conenction and connect you will be able to view all of the tables and other objects.
Hint: look at the view's to get some of the relationships/joins as a template.
05-31-2013 08:21 AM
Excellent, you have been a great help!
Thanks again!
05-31-2013 10:04 AM
Frank and Miles...
If you would like to generate an output / list of the tables... you should be able to run the following
SELECT * from SP_TABLES();
You may need to execute this from DBISQLC, as the WebUI sometimes shows the same data on each page... or save the query and try executing as a CSV.
--Tom