Read SAP HANA Topology Details

Case 1

When database is online or the nameserver service is active then please check system view M_TOPOLOGY_TREE in order to get topology information. Run on SYSTEMDB for MDC.

SELECT * FROM M_TOPOLOGY_TREE

Case 2

When database is down we can use hdbnsutil in order to collect topology information.

Note: Via fullsysteminfodump user can read topology from topology.txt. In system replication environment topology.txt of secondary site is empty as nameserver is inactive.