Hi Robert,

Please try with "where platform_name is null".

Regards,
Erwann

----- Mail original -----
De: "Robert Ouzen" <rouzen AT UNIV.HAIFA.AC DOT IL>
À: ADSM-L AT VM.MARIST DOT EDU
Envoyé: Vendredi 20 Juillet 2012 09:04:23
Objet: [ADSM-L] Script to detect nodename not yet connected

Hi to all

Tried to get a list of node name they are already configure to  in the Tsm 
server but still not connect it.

When running the q node libnas got:

tsm: POSTBACK>q node libnas

Node Name                     Platform     Policy Domain      Days Since     
Days Since     Locked?
                                           Name               Last Acce-       
Password
                                                                      ss        
    Set
-------------------------     --------     --------------     ----------     
----------     -------
LIBNAS                        (?)          DOUNIX                     16        
     16       No

So tried to create few scripts but wrong output, like:

select node_name , platform_name  from nodes where platform_name like'%%?%%'    
  no output
select node_name , platform_name  from nodes where platform_name like'%% %%'   
got:
    NODE_NAME                                                              
PLATFORM_NAME
------------------------------------------------------------------     
------------------
LAB1_DB                                                                TDP 
MSSQL Win64
VMPROXY                                                                TDP 
VMware

select node_name , platform_name  from nodes where platform_name=''             
             no output

Miss something …. Any ideas ?

T.I.A Regards

Robert