Getting Client informations in Remotly Citrix Client Connection
How getting Machine name and its Mac address in Remotly Citrix Client Connection
Oracle DatabaseWindows NetworkingJavaCitrix
Last Comment
alialyosofy
8/22/2022 - Mon
slightwv (䄆 Netminder)
Since this was posted in an Oracle zone, I assume you want to do this from a remote Oracle database connection. Not familiar with Citrix but if you can query from it, you can use SYS_CONTEXT to get client connection information.
Don't think you can get MAC address but IP address is doable.
For example to get machine name of the client connection:
SELECT SYS_CONTEXT ('USERENV', 'HOST') FROM DUAL;
alialyosofy
ASKER
The SQL statement SELECT SYS_CONTEXT ('USERENV', 'HOST') FROM DUAL;
give me the Host name of the Citrix Server that is accessed remotly by Citrix Client,and I want the host name of the Citrix Client that connected remoltly to citrix server.
slightwv (䄆 Netminder)
Unfortunately Oracle only cares about where the client connection comes from. If that is another remote connection from a 3rd party app, it will be up to that app to log where it comes from.
If the end app is custom code, you can probably add this info and pass it along to Oracle.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
alialyosofy
ASKER
I want any third party network commands regardless oracle to get Client informations in Remotly Citrix Client Connection
alialyosofy
ASKER
It is good added to this Citrix Zone, I hope to find Optimal Solution
Geert G
if you have control over the application
> like if you have the source code and compile it
you could use dbms_application_info to set that information
Unlimited question asking, solutions, articles and more.
alialyosofy
ASKER
I have full control of my application either accessing remotly or not,But when my application run via citrix client that access the citrix server (i.e my database server in citrix server and my client application in this case is run via citrix client ) then any client info. returned is represent the database Server(Citrix server) info.
Sekar Chinnakannu
for machine name you can get the same in connection center. MAC i don't think so you can get it from client end for a citrix server
alialyosofy
ASKER
Its good if there was a Dos command to get either Host name ,IP Address or MAC Address of Citrix client when its connected to Citrix server.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
Its good answer to get information of citrix client session using the following registery entries:-
HKLM\Software\Citrix\ICA\Session\sessionnumber\CLIENTADDRESS
HKLM\Software\Citrix\ICA\Session\sessionnumber\CLIENTNAME
Don't think you can get MAC address but IP address is doable.
http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions184.htm#SQLRF06117
For example to get machine name of the client connection:
SELECT SYS_CONTEXT ('USERENV', 'HOST') FROM DUAL;