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
