How to check SAP HANA Hardware Key at OS level?

Requirement: We want to know the HARDWARE Key of our HANA system. Hardware key is mandatory to request license key from SAP Marketplace.


Prerequisite:
  • Database User: We need an HANA DB user with LICENSE ADMIN or CATALOG READ or DATA ADMIN assigned.
  • SID<ADM> credentials: To log into SAP HANA OS level we need sid<adm> credentials.

Steps:
Logon to HANA host with <SID>adm user.
Once we are logged in as <SID>adm, we can directly execute the hdbsql command ,or we can go to following path and execute the hdbsql command.  
         cd /hana/shared/<SID>/hdbclient 

HDBSQL Command : 
hdbsql  -n localhost -i 00 -u HANADbUser -p yourUserPassword

Please note: In our case the system number is 00 , update the instance number accordingly.
Now execute following SQL command to get the HARDWARE key.

SQL Command: "SELECT * from M_LICENSE" ;

Output :
HARDWARE_KEY,SYSTEM_ID,INSTALL_NO,SYSTEM_NO,PRODUCT_NAME,PRODUCT_LIMIT,PRODUCT_USAGE,START_DATE,EXPIRATION_DATE,LAST_SUCCESSFUL_CHECK,PERMANENT,VALID,ENFORCED,LOCKED_DOWN,MEASUREMENT_XML
"X0891103253","HDB","unknown","unknown","SAP-HANA",0,22,?,?,?,"FALSE","FALSE","FALSE","TRUE",""


Highlighted in green is the Hardware key.


Related