Re: [ADSM-L] Script to detect nodename not yet connected
2012-07-20 03:27:47
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
|
|
|