How to get a hostname information from SAP IQ database level

[SAPSupport]

We want to get the physical hostname from the Database level.

If you see DB is running on below host, we want to get the physical hostname from the Database level using "select query".

[testhost0447!testuser]$ hostname
testhost0447

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

We can get the hostname information by executing the below query:

(DBA)> select Value from sa_eng_properties() where PropName='MachineName'