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