Use this: select node_name , platform_name from nodes where platform_name=NULL
On 20 July 2012 08:04, Robert Ouzen <[email protected]> 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
