We help IT Professionals succeed at work.

Getting Client informations in Remotly Citrix Client Connection

1,699 Views
Last Modified: 2013-01-04
How getting Machine name and its Mac address in Remotly Citrix Client Connection
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

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

Author

Commented:
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.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
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.

Author

Commented:
I want any third party network commands regardless oracle to get Client informations in Remotly Citrix Client Connection

Author

Commented:
It is good added to this Citrix Zone, I hope to find Optimal Solution
Geert GOracle dba
CERTIFIED EXPERT
Top Expert 2009

Commented:
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

Author

Commented:
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 ChinnakannuStaff Engineer
CERTIFIED EXPERT

Commented:
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

Author

Commented:
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.
Senior Citrix Engineer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.