Hot Diggety! Deon George was rumored to have written:
> Has anybody got an SQL, that can list all VOLUMES, and highlight (either
> showing the element number or something) those that are in the library?
>
> This report would be useful to see quickly if a list of tapes are already
> in the library - or which tapes in the list are not and need to be checked
> in.

I got a list of tables by doing:

tsm> select tabnames,remarks from tables

Then I decided to look at the table called LIBVOLUMES because your request
is essentially the SQL equivalent of 'query libvolume'.

So then I decided to see what fields (columns) were present in the table
called 'LIBVOLUMES' with:

tsm: MYSERVER>select colname from columns where tabname='LIBVOLUMES'

COLNAME
------------------
LIBRARY_NAME
VOLUME_NAME
STATUS
OWNER
LAST_USE
HOME_ELEMENT
CLEANINGS_LEFT

Based on that, I figured only three columns might be useful. So:

tsm> select library_name,volume_name,home_element from libvolumes

...which would produce an output like:

tsm: MYSERVER>select library_name,volume_name,home_element from libvolumes

LIBRARY_NAME           VOLUME_NAME            HOME_ELEMENT
------------------     ------------------     ------------
3584LIB1               MYS000                         1026
3584LIB1               MYS001                         1027
3584LIB1               MYS002                         1028
3584LIB1               MYS003                         1029
3584LIB1               MYS004                         1030
3584LIB1               MYS005                         1031
[...snip...]

If you have only one library, you are free to leave the library_name off
the select query.

Parse the results as you like, regardless of if it's called via an internal
TSM server-side script or if it's called via a script that parses the
output of calling dsmadmc in batch mode. It is trivial in either case.

-Dan