check labeled tape is what LTO

[fadzlirot]

how do i check what LTO (LTO3 or LTO4) the tapes thta i have in library?
i tried select * from volumes and q vol f=d but cant find it.

 

[Trident]

Hi,

A quick select:
select LIBRARY_NAME,VOLUME_NAME,MEDIATYPE from libvolumes

 

[fadzlirot]

Is there any way to see for every tape that ever labeled? not just the one inside library

 

[Trident]

Hi,
Libvolumes does only store information about current config. Not sure if any tables holds the information you seek. The volumehistory does not store mediatype.

 

[fadzlirot]

thanks. i forgot about libvolumes earlier. too bad i cant list every tape the labeled before.

 

[marclant]

I'm guessing you are not using 8 character labels, but if you are, you can use:

select distinct(volume_name) from volhistory where volume_name like '%L3'
select distinct(volume_name) from volhistory where volume_name like '%L4'

That won't give you all volumes ever labelled, but at least every volume still in the volume history.