Backup Central

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

Hi Robert,

Please try with "where platform_name is null".

Regards,
Erwann

----- Mail original -----
De: "Robert Ouzen" <rouzen < at > UNIV.HAIFA.AC.IL>
À: ADSM-L < at > VM.MARIST.EDU
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

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.EDU] On Behalf Of
Robert Ouzen
Sent: Friday, July 20, 2012 9:04 AM
To: ADSM-L < at > VM.MARIST.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.

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:ADSM-L < at > VM.MARIST.EDU] On Behalf Of Erwann Simon
Sent: Friday, July 20, 2012 10:23 AM
To: ADSM-L < at > VM.MARIST.EDU
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" <rouzen < at > UNIV.HAIFA.AC.IL>
À: ADSM-L < at > VM.MARIST.EDU
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

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.EDU] On Behalf Of Carlo Zanelli
Sent: Friday, July 20, 2012 10:38 AM
To: ADSM-L < at > VM.MARIST.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.EDU] On Behalf Of Robert Ouzen
Sent: Friday, July 20, 2012 9:04 AM
To: ADSM-L < at > VM.MARIST.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.

Use this:

select node_name , platform_name from nodes where platform_name=NULL

On 20 July 2012 08:04, Robert Ouzen <rouzen < at > univ.haifa.ac.il> 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