how to find sid user and instance number of HANA db ?

[former_member751298]

for some script i wanted to find HANA sid and instance number from the server as a root user, is there any way to find it ?

[former_member213277]

Please check this table: "SYS"."M_SYSTEM_OVERVIEW"

[eason_chen]

Dear customer,

You could use following OS command to find all HANA sid users.

cat /etc/passwd |grep HANA

Moreover, for HANA system instance number, you could refer to the folder name of your HANA system.
e.g.
/usr/sap/<SID>/HDB<instance number>

Best Regards,
Eason Chen

[Former Member]

SELECT * FROM SYS.M_SYSTEM_OVERVIEW;

From this sql command you will get the sid user ,instance number,current patch ...etc

[akshinde]

SELECT * FROM SYS.M_SERVICES

Derive instance number from sql port , if sql port is 34015 then instance number is 40.