Use this:

select node_name , platform_name  from nodes where platform_name=NULL

On 20 July 2012 08:04, Robert Ouzen <rouzen AT univ.haifa.ac DOT il> wrote:
> 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