select left(platform_name,13) as "PLATFORM_NAME"  -
,  left(node_name,13)         as "NODE_NAME     " -
,  cast(client_version  as CHAR(1)) ||  '.' -
|| cast(client_release  as CHAR(1)) ||  '.' -
|| cast(client_level    as CHAR(1)) ||  '.' -
|| cast(client_sublevel as CHAR(2)) as "LEVEL  " -
,  left(option_set,6)   as "OPTION_SET" -
,  contact as "Contact                             " -
   from nodes

On Thu, 19 Sep 2002, Alexander Verkooijen wrote:

> On 19-Sep-02 Karla Ross wrote:
>
> > Does anyone have a select command that will show me the clients and what
> > version of TSM they are running?  My TSM servers are running TSM v4.1, 4.2,
> > and 5.1.
>
> select node_name,client_version,client_release,client_sublevel from nodes
>
> -----------------------------------------------
> Alexander Verkooijen        (alexander AT sara DOT nl)
> Senior Systems Programmer
> SARA High Performance Computing
>