Hi TSM guru,

For tracking and tape management purpose, I am trying to come up with a
list of volumes needed for restore and/or tapes used  for each storage
pool.
Now, I came up with this one after performing a search of adsm forum..

select node_name, count (distinct volume_name) as NumOfTape,stgpool_name
from volumeusage group by node_name, stgpool_name

NODE_NAME  NUMOFTAPE  STGPOOL_NAME
--------------------     --------------------    ------------------
xxxxxxxxxxxxxx   #xx                          xxxxxxxxxxxxxxxx

However, what I am looking for is similar to this output.   Any idea..
Thanks

NodeName          Storagepool(a)  Storagepool(b)  Storagepool(c) and
Storagepool(d)
---------------------------           ------------------------
----------------------- -----------------------
-----------------------------
xxxxxxxxxxx       # of  tape  # of tape   # of tape   # of tape

Thanks,

Sung Y. Lee