Need a Script to find storage pool names of volumes present in library

[niteshm149]

Hello,

I need a Script to find storage pool names of volumes present in library which will give the LTO Number and it's storage pool in output.

Please help me out.

 

[niteshm149]

Thanks for the helpful reply.

But I don't want to see all the volume names.

I just need pool name of those tapes which are currently present in library.

Simply I want stgpool names of all the volumes (TSM>Query Libvolumes).

I hope you understand my concern.

 

[opermty]

You must to use an anidate query .. =)

select * from volumes where volume_ name in (select volume_name from libvolumes)

something like that

 

[marclant]

If I understand correctly, you just want the storage pool names for which there are volumes in the library. If that is the case, then use this:

select distinct(stgpool_name) from volumes where volume_name in (select volume_name from libvolumes)