Hmm, that worked for me:

tsm: TSMSERV6A>select
node_name,platform_name,client_version,client_release,clie
nt_level from nodes where client_version = 5 and client_release =
2 and client_level = 2 and platform_name like 'WinNT'

NODE_NAME          PLATFORM_NAME    CLIENT_VERSION CLIENT_RELEASE
CLIENT_LEVEL
------------------ ---------------- -------------- --------------
------------
TAFORD-NODE1       WinNT                         5              2
2
TAFORD-NODE2       WinNT                         5              2
2
TAFORDSRV2_BCK     WinNT                         5              2
2

        Perhaps you don't have any clients at that level?

Ben 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Hoa V Nguyen
Sent: Wednesday, February 23, 2005 10:17 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SQL to find all NT nodes with V5.2.2.0
Importance: High

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