cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

Opscenter(SQL Help) Amount of data backed up per month.

301
Level 3

‎12-21-2016 02:26 PM - edited ‎12-29-2016 09:32 AM

Hi All,

Fairly new to OpsCenter and Netbackup.  I am looking for a SQL query to measure the amount of data backed up by our media server per year, for say last 3 or 4 years or 5yrs.  The right parameters are not available in OpsCenter to use to generate the report needed.  I was hoping maybe an SQL query may help.  Basically trying to show an increase in data backed up over the years.  THANKS!

0 Kudos
2 REPLIES 2

D_Flood
Level 6

‎12-28-2016 09:21 AM

There are a couple of the canned reports that give this sort of information but the limitiation is going to be how long OpsCenter is set to retain information.  Unless you've previously set that limit to 4 years (more than 4 years ago), you won't be able to go back any further than whatever the current limit is set to.

301
Level 3
In response to D_Flood

‎12-28-2016 11:28 AM

Thank you D_Flood for responding.  I have checked OpsCenter and there are only certain parameters available to generate a specific report.  Unfortunately, i wasn't able to use any of them, not the right ones. I was hoping there was enough to generate that customised report.  Or if someone knows of a SQL query I could use.  (Needed to basically show that our amount of data being backed up is incresing every year)  Thanks.

0 Kudos