cancel
Showing results for 
Search instead for 
Did you mean: 

Help with OpsCenter Reports

I need to generate two reports that OpsCenter seems to be missing.

 

One report is a Frozen Tape report.

The second report is a Scratch Tape report.

 

Can anybody give me pointers on how to create these?

1 Solution

Accepted Solutions
Accepted Solution!

Was there anything else you

Was there anything else you needed to see on the reports or will they work for your needs? If so please mark as solutions.

View solution in original post

6 Replies

I cant get the custom 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

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

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.

 

Accepted Solution!

Was there anything else you

Was there anything else you needed to see on the reports or will they work for your needs? If so please mark as solutions.

View solution in original post

The SQL queries work great

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

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.