Forum Discussion

Tom_Egger's avatar
Tom_Egger
Level 4
9 years ago

Tape written report in opscenter

Hi all

I'm looking for a report in the Opscenter for tape written by month. i need Date,Mediaserver,VolumePool, MediaId,Size in GB.

Can anyone help me?

Thanks

Tom

2 Replies

  • this was i'm looking for;

    select sum (domain_Media.usedCapacity) as "domain_Media.usedCapacity",domain_Media.volumePoolName as "domain_Media.volumePoolName",domain_Media.masterServerId as "domain_Media.masterServerId",YEARS(adjust_timestamp_dst(domain_Media.allocationTime )) as "yearCol",MONTH(adjust_timestamp_dst(domain_Media.allocationTime )) as "monthCol" from domain_Media , domain_MasterServer where domain_MasterServer.id = domain_Media.masterServerId and ( ( (domain_Media.allocationTime BETWEEN '137025180000000000' AND '137340539400000000') ) AND ( (domain_Media.volumePoolName IN ('ZF-NBU-ACS11', 'BE-NBU-ACS00', 'BE-NBU-ACS01', 'ZF-NBU-ACS10' )) ) AND ( ( (CASE WHEN domain_Media.isValid = 1 THEN 1 WHEN domain_Media.isValid = 0 THEN 0 ELSE 1 END) = '1') ) AND ( ( (CASE WHEN domain_Media.deleted = 1 THEN 1 WHEN domain_Media.deleted = 0 THEN 0 ELSE 1 END) = '0') ) AND ( ( (domain_MasterServer.id IN (1897 )) ) ) ) GROUP BY "domain_Media.volumePoolName", "domain_Media.masterServerId", "yearCol", "monthCol" ORDER BY "domain_Media"."volumePoolName" ASC , "domain_Media"."masterServerId" ASC , "yearCol" ASC , "monthCol" ASC

    • puneet102's avatar
      puneet102
      Level 4

      Hey Tom, As I know there is no report in opscenter which can display the correct data with media id. I am also looking for the same. Currently the issue is with media id. When we enter media id or job associated media id column in report. Th all report is showing wrong data. It showing incorrect volume pool  name and media ids in the report which we was not using from the long time.

       

      Please also let me know if you have some information for the same.