05-10-2017 12:32 AM
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
08-08-2017 01:39 AM
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
09-17-2017 05:17 AM
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.