We want to know the HARDWARE Key of our HANA system

Prerequisite:

• Database User: We need an HANA DB user like (SYSTEM) with LICENSE ADMIN or CATALOG READ or DATA ADMIN assigned.

• To log into SAP HANA OS level we need <sid>adm credentials.

For our sample, the SID is HXE, the instance No is 90, and the hostname is hxehost

• Logon to HANA host with hxeadm user.

We can directly execute the hdbsql command the hdbsql command.  

# hdbsql  -n hxehost -i 90 -u SYSTEM -p yourUserPassword

 

Now execute following SQL command to get the HARDWARE key.

> SQL Command: "SELECT HARDWARE_KEY,SYSTEM_ID from M_LICENSE" ;

Output : 

HARDWARE_KEY,SYSTEM_ID

"P1016984971","HXE"

The bold one is the Hardware key.