How to find out what SEGMENTS are the clients using for each TSM Server Instance?

[sandratechie27]

TSMGURUS:
Is there a way to generate an SQL statement and find out what segments are the clients using on the TSM Server side? For example we have 10 different TSM instances with different ip addresses. We will like to know what clients are registered on this ip address(TSM Server instance ip address) 10.120.130.20, 10.120.130.50 etc.

Thank you

 

[sandeepkontham]

i am not sure what you are trying to convey but may be the following helps you

select node_name, tcp_address from nodes

tcp_address === TCP/IP address of client node which is used to connect, backup etc.