Thanks to all ....
Lovely day you too .... And hope more happiness news instead bad one !
Regards Robert
Haifa University
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Carlo Zanelli
Sent: Friday, July 20, 2012 10:38 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Script to detect nodename not yet connected
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Robert Ouzen
Sent: Friday, July 20, 2012 9:04 AM
To: ADSM-L AT VM.MARIST DOT EDU
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.
|