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
Forum Discussion
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
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.
