ADSM-L

Re: [ADSM-L] Script to detect nodename not yet connected

2012-07-20 03:58:11
Subject: Re: [ADSM-L] Script to detect nodename not yet connected
From: Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 20 Jul 2012 07:48:07 +0000
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.