Try this one....

select node_name as "NODES", platform_name as "Platform", client_version as
"VERSION", client_release as "RELEASE", client_level as
"LEVEL",client_sublevel as "SUB LEVEL" from nodes

-mdh


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


Zlatko Krastev/ACIT wrote:

>select cast(CLIENT_RELEASE as char) concat '.' concat cast(CLIENT_LEVEL as
>char) concat '.' concat cast(CLIENT_SUBLEVEL as varchar(2)) concat ' for '
>concat PLATFORM_NAME concat '/' concat CLIENT_OS_LEVEL as
>"----------------------------------------" from nodes
>
>Zlatko Krastev
>IT Consultant
>
>
>
>

Zlatko,

That is a very cool little select.  However you missed the client
version so here is my little addition.


select cast(CLIENT_VERSION as char) concat '.' concat cast(CLIENT_RELEASE as
char) concat '.' concat cast(CLIENT_LEVEL as char) concat '.' concat
cast(CLIENT_SUBLEVEL as varchar(2)) concat ' for ' concat PLATFORM_NAME
concat '/' concat CLIENT_OS_LEVEL as
"----------------------------------------" from nodes


--
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
============================================================================
===