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_os_level, "Client", Node

---------------------------------------
Bruce Kamp
Midrange Systems Analyst II
Memorial Healthcare System
E: bkamp AT mhs DOT net
P: (954) 987-2020 x4597
F: (954) 985-1404
---------------------------------------


-----Original Message-----
From: Mark D. Rodriguez [mailto:mark AT MDRCONSULT DOT COM]
Sent: Monday, December 02, 2002 2:37 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Client version stored in Database?


Nelson, Doug wrote:

>Can I issue a query to tell the version of TSM client software on each
node?
>                                        Thanks, Doug
>
>Douglas C. Nelson
>Distributed Computing Consultant
>Alltel Information Services
>Chittenden Data Center
>2 Burlington Square
>Burlington, Vt. 05401
>802-660-2336
>
>
Doug,

You can do a "q node f=d", client version is one of the reported fields.

--
Regards,
Mark D. Rodriguez
President MDR Consulting, Inc.

============================================================================
===
MDR Consulting
The very best in Technical Training and Consulting.
IBM Advanced Business Partner
SAIR Linux and GNU Authorized Center for Education
IBM Certified Advanced Technical Expert, CATE
AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat
Certified Engineer, RHCE
============================================================================
===