RUn the q_columns tsm script, "RUN Q_COLUMNS volumes" to see all the column 
names for the volumes table.  run q_tables gives you all the table names.

David

>>> sunglee AT US.IBM DOT COM 05/25/05 3:07 PM >>>
Howdy folks,

Does anyone know what are column names and table name(s) for WWN and Serial
Number for tape drives?
I am trying to pull these information using select similar to q drive
output.

Thanks,

Sung Y. Lee