BUE2012 - Media Custom Report

[pshankland]

Hi all,

I am trying to create a custom report so I can see what tapes have been used for more than 50hrs (will increase to a more 'real' figure one I have it working).

Everything is working ok except that because I have a seperate job for each server, a single tape will have multiple jobs which means the report shows multiple entries for the tape. I have attached the report so everyone can see what I mean.

Does anyone know a way around this so I can just show a single entry per tape? I have tried grouping on the label but that still shows a load of entries.

Thanks.

Pete.

[pshankland · Accepted solution]

Didn't realise that this would be a global setting!!!

Configuration and Settings --> Backup Exec Settings --> Reports --> Show Distinct Rows

Seems an odd place to have this to be honest but works now anyway.