select node_name,cast (client_version as char(1)) || '.' || cast
(client_release as char(1)) || '.' || cast (client_level as char(1)) || '.'
|| trim(cast(client_sublevel as char(2))) as "Level" from nodes order by 2,1

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: Halvorsen Geirr Gulbrand [mailto:gehal AT WMDATA DOT COM]
Sent: Thursday, September 19, 2002 9:17 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Select command to q client name and version


Hi Karla,
try
select node_name,client_version,client_release,client_level,client_sublevel
from nodes

Rgds,
Geirr G. Halvorsen

-----Original Message-----
From: Karla Ross [mailto:keross AT US.IBM DOT COM]
Sent: 19. september 2002 15:08
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Select command to q client name and version


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.

Karla Ross