Hi Robert, You can easily achieve the result running 'not like' sql statement in the query excluding the platform names you have in your environment.
In our case for example we have Linux,Windows, Sun, Aix, Tdps and db2s, so running this sql gives to us the result: select * from nodes where ( - ( PLATFORM_NAME not like 'Linux%' ) and - ( PLATFORM_NAME not like 'Win%' ) and - ( PLATFORM_NAME not like 'SUN SOLARIS' ) and - ( PLATFORM_NAME not like 'AIX' ) and - ( PLATFORM_NAME not like 'TDP%') and - ( PLATFORM_NAME not like 'DB2%') ) Have a lovely day. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Robert Ouzen Sent: Friday, July 20, 2012 9:04 AM To: [email protected] Subject: [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 ----- Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute nel messaggio e negli eventuali allegati sono riservate al/ai destinatario/i indicato/i. Nel caso di erroneo recapito, si chiede cortesemente a chi legge di dare immediata comunicazione al mittente e di cancellare il presente messaggio e gli eventuali allegati. Si invita ad astenersi dall'effettuare: inoltri, copie, distribuzioni e divulgazioni non autorizzate del presente messaggio e degli eventuali allegati. ---------- According to Italian law (D.Lgs 196/2003) information contained in this message and any attachment contained therein is addressed exclusively to the intended recipient. If you have received this message in error would you please inform immediately the sender and delete the message and its attachments. You are also requested not to make copies, nor to forward the message and its attachments or disclose their content unless authorised.
