I resolved the problem with a very small C# dll, which I deployed as a .Net component.  I used the AppeonDotNetComponent object to access the dll.

Unfortunately none of these ideas are working.  Might it be possible to get to the computer name environment variable on the server hosting the session?  Or read a file on the server which would contain the server name.  I am currently using a value in the application ini file, but every time I redeploy,  the ini file has to be changed on both production servers - easy to do but annoying.

Hi Mark;

   FYI: ZhaoKai's suggested code is basically what I use in my framework. Works great ...

Regards ... Chris

Hi Mark,

Please try using the function getSessionByID to get the current session information, which includes the server ID. Please refer to the article below for details:
https://docs.appeon.com/ps2020/workarounds_and_api_guide/ch04s01s04.html

For example, the script below for .net server:

AppeonDotNetComponent lnvo
any la_l[]
long ll_ret
string ls_clientID

ls_clientID = appeonGetClientID()

la_l[1] = ls_clientID // actually, can be empty and this will mean "take current session ID"
la_l[2] = ""

lnvo = Create AppeonDotNetComponent
lnvo.ComponentType = "4"
lnvo.TypeLib = ""
lnvo.ClassDescript = ""

ll_ret = lnvo.of_ExecInterface ("getSessionByID",la_l)
If ll_ret = 0 Then
MessageBox("Get session info successfully.", "Session info: " + string(la_l[2]))
End If

Regards,
ZhaoKai

Just an idea:

If your DB runs on the same server as Powerserver, maybe there's a way to get it from the DB with a SELECT or some system stored procedure.

For example, Oracle: https://stackoverflow.com/questions/2366962/find-the-server-name-for-an-oracle-database

regards