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:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 9:17 AM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] Sent: 19. september 2002 15:08 To: [EMAIL PROTECTED] 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
