Backup to tape report

[gaapeio]

I'm trying to generate an OpsCenter report which shows how much (GB/TB) data is backed up to tape.

I've tried using a tabular report using the "Media Volume Group Name", with columns for "Media Server" and "Job Size".

This report doesn't seem to show adequate numbers.

Is there a better report or SQL query to gather this type of information ?

[Tom_Egger]

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 '137076156000000000' AND '137655899400000000') ) AND ( (domain_Media.volumePoolName IN ('Poolname', 'Poolname', 'Poolname', 'Poolname' )) ) 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

[gaapeio]

The report did not return any data. I assume I have to edit some parts of this query.

What format am I supposed to enter my Poolname in this line ?

( (domain_Media.volumePoolName IN ('Poolname', 'Poolname', 'Poolname', 'Poolname' )) )