Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

total number of scratch tapes

Created: 09 Jan 2013 • Updated: 08 Feb 2013 | 6 comments
This issue has been solved. See solution.

Hi,

I need a report with the total number of scratch tapes for every robot. Is it possible in OpcCenter 7.1.0.4????

I don´t  need barcodes, only the total number.

Regards

Dirk

Comments 6 CommentsJump to latest comment

cradlemtn's picture

Hi Dirk,

you can define a custom report for the scratch pool related to each Library.

To do this create a custom report under 'My Reports'.

For example, I tried with

Backup Category-->Backup/Recovery

Subcategory-->Backup Media

Report Type View-->Historical

Filters-->Media-->Backup Media Volume Pool Name=<Your Scratch-Pool-Name>

Timeline Chart Properties-->Type Library Unique ID (or Serial Number)

Timeline Chart Properties-->Y1-Axis-->Report Data =Media ID and Count

The other options adjust for your convenience, e.g. time frame.

Regards
Michael

Murphy ist our dear friend, but are we his friend?

(NBU 7.5 on Solaris 10, SuSE Linux and Windows2003/2008)

loori's picture

I use an SQL-Query - as usual are the prefab reporsts useless

select  RobotNumber,
count (*) "Kassetten im Scratch Pool"
from nom_NBVolume where VolumePoolName = 'scratch' group by RobotNumber

I'm not sure if that works in 7.1, but it should, as far as I remember, I didn't change it after the update 7.1->7.5

SOLUTION
Dirk Müller's picture

Hi Michael,

thanks for your answer, but the output of my report isn´t correct.

Are my settings ok? (see attachement)

Regards

Dirk

Ops1.jpg
Dirk Müller's picture

Hi loori,

your solution works fine - thank you.

Regards

Dirk

Dyneshia's picture

Hi Hirk, be sure to mark the solution.

cradlemtn's picture

Hi Dirk,

I may have missed the X-Axis Settings. Please see the pics with my settings and the result below.

Hope this will help.

Ciao

Michael

OpsCenter_Scratch_Tapes_Report_Settings.jpg OpsCenter_Scratch_Tapes_Report.jpg

Regards
Michael

Murphy ist our dear friend, but are we his friend?

(NBU 7.5 on Solaris 10, SuSE Linux and Windows2003/2008)