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/[EMAIL PROTECTED] Sent by: "ADSM: Dist Stor Manager" <[email protected]> 02/23/2005 11:32 AM Please respond to "ADSM: Dist Stor Manager" To [email protected] 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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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" <[email protected]> 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
