Hi Erwann So stupid I did it too before but with combined syntax and not as you suggest in the simple way
Thanks Robert -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Erwann Simon Sent: Friday, July 20, 2012 10:23 AM To: [email protected] Subject: Re: [ADSM-L] Script to detect nodename not yet connected Hi Robert, Please try with "where platform_name is null". Regards, Erwann ----- Mail original ----- De: "Robert Ouzen" <[email protected]> À: [email protected] 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
