total number of scratch tapes

[Dirk_Mueller]

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

[cradlemtn]

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.

[loori · Accepted solution]

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

[Dirk_Mueller]

Hi Michael,

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

Are my settings ok? (see attachement)

Regards

Dirk

[Dirk_Mueller]

Hi loori,

your solution works fine - thank you.

Regards

Dirk

[cradlemtn]

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

[Dyneshia]

Hi Hirk, be sure to mark the solution.