Listing Volume Pool IDs and Media Types
Using the Report Template Designer, create a custom report using the following query to identify Volume Pool IDs and Media Type codes:
select DISTINCT n.vendor_media_type, t.vendor_media_type_name, n.volume_pool_id
from apt_v_nbu_tape_media_detail n, apt_v_tape_media t
where n.tape_media_id = t.tape_media_id
and t.server_id in ($(hosts))
When you create this custom report via the Report Template Designer, configure the Report Designer to include the selection of a host group, enabling users to narrow the scope of the report when they generate the report.