ADSM-L

Re: Select command to q client name and version

2002-09-19 12:39:22
Subject: Re: Select command to q client name and version
From: Karla Ross <keross AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 19 Sep 2002 11:21:32 -0500
This works great, thanks for all the replays.

Karla Ross




Hussein Abdirahman <hussein.abdirahman AT IRWINTOY DOT COM>@VM.MARIST.EDU> on
09/19/2002 08:34:10 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:    "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:    ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:    Re: Select command to q client name and version



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:keross AT US.IBM DOT COM]
Sent: Thursday, September 19, 2002 9:08 AM
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