Avatar of alialyosofy
alialyosofy
 asked on

Getting Client informations in Remotly Citrix Client Connection

How getting Machine name and its Mac address in Remotly Citrix Client Connection
Oracle DatabaseWindows NetworkingJavaCitrix

Avatar of undefined
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.

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;
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

see these links for more info:
http://www.oracle-base.com/articles/8i/dbms_application_info.php
Get an unlimited membership to EE for less than $4 a week.
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.
rwheeler23
ASKER CERTIFIED SOLUTION
Coralon

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
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.
ask a question
alialyosofy

ASKER
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