ADSM-L

[ADSM-L] Script to detect nodename not yet connected

2012-07-20 03:07:19
Subject: [ADSM-L] Script to detect nodename not yet connected
From: Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 20 Jul 2012 07:04:23 +0000
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