I have a select statement that will display part of what I want but I cant seem to make it completely work. Here is the statement and the output,
select node_name as Node,count(distinct volume_name) as "Tape Pool Media",count(distinct volume_name) as "Copy Pool Media" from volumeusage where stgpool_name='TAPEPOOL' or stgpool_name='COPYPOOL' group by node_name NODE Tape Pool Media Copy Pool Media ------------------ --------------- --------------- 411 1 1 5X 2 2 6X 1 1 I would like to have the select display the volumes from the tapepool and the copypool locations for each node. How can you build a select statement that will do this? Thanks for any help JWS