Hi Carla; Try this. I got this from group. It will also display the OS versions.
select platform_name as OS, - client_os_level as OS_VER, - node_name as Node, - cast(cast(client_version as char(2)) || '.' - || cast(client_release as char(2)) || '.' - || cast(client_level as char(2)) || '.' - || cast(client_sublevel as char(2)) - as char(15)) as "Client" - from nodes - order by platform_name, "Client", Node regrds; Hussein M. Abdirahman UNIX Administrator ---------------------------------------------------------------------------- ---- -----Original Message----- From: Karla Ross [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 9:08 AM 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