Thank you very much Andy,

I have issued the command on a server WITHOUT NT nodes and I thought it
didn't work, but it IS.
Thanks again.
Hoa.




Andrew Raibeck/Tucson/IBM@IBMUS
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
02/23/2005 11:32 AM
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: SQL to find all NT nodes with V5.2.2.0






I copied & pasted your command into the TSM Admin CLI, and it ran just
fine.

It would help to have some additional detail about what "it didn't work"
means.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-02-23
10:16:35:

> Hi Folks,
>
> I'm trying to list all NT nodes with TSM Client V5.2.2.0 from the
server.
> I have tried:
>
> select
node_name,platform_name,client_version,client_release,client_level
> from nodes where client_version = 5 and client_release = 2 and
> client_level = 2 and platform_name like 'WinNT'
>
> but it didn't work,
> please give me some hints.
>
> Thanks for your help.
> Hoa.
> AIX 5, Release 2, Level 2.0
> Client V5.2.2.0