TSM - Select Parte 2

[girreis]

Dear friends,

Is there a command using the "SELECT" that may get the following information:

- When the TCP / IP Node Name is different from the name.
- You can draw up a command "SELECT" which checks daily if there was a change in TCP / IP Node Name in relation to the name, it is necessary to be equal.

Thanks for listening,

Ramon

 

[smajl]

select * from nodes where NODE_NAME!=upper(TCP_NAME)

 

[girreis]

Thanks, smajl!