Help with OpsCenter Reports

I cant get the custom reports to work for this through the UI but it should be something like this:

Custom Report >

Cat: Backup/Recovery

Subcat: Media

View Type: Tabular

 

Time Frame:

No Time Basis

 

Filters:

Media

(Frozen)

Column: Media Status

Value: Frozen/Frozen Full

(Scratch)

Column: Media Volume Pool Name

Value: Scratch(Or what ever you called your pool)

 

I'll work on some custom SQL in case this dosent help.

 

 

Here is the SQL for these.

Scratch:

SELECT * FROM domain_Media WHERE volumePoolName = 'Scratch'

 

Frozen:

SELECT * FROM domain_Media WHERE status IN (SELECT id FROM lookup_MediaStatus WHERE name LIKE '%Frozen%')

 

Also if by some chance you do not have a Scratch pool here is something that will at least get you close:

SELECT * FROM domain_Media WHERE usedCapacity IS NULL AND isCleaning = 0 AND isImported = 0

Thanks for the help.

 

I can't believe I'm the first person to ask for a Scratch Tape report or a Frozen Tape report.  You'd think those would be canned reports that come with OpsCenter.

 

The SQL queries work great but is there a way to generate a count of how many lines have been returned?  I've tried using the count(*) option but it doesn't work.  One of our DBA's suggested putting a second SQL SELECT statement but it appears it's not working either.

 

You aren't the first to look for them!  And you would think you could just filter the canned "Media Reports" -> "Media State" report, but no.

If you are looking for just the count of tapes, there are scripts for similar reports in NetBackup's .../goodies directory.  But the way to fix frozen tapes is through the NetBackup command line or GUI, which is pretty easy to find them right there and right-click to unfreeze them.

Oh, and the OpsCenter home page already has a Media Summary by Status pie chart.