• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1399
  • Last Modified:

Getting Client informations in Remotly Citrix Client Connection

How getting Machine name and its Mac address in Remotly Citrix Client Connection
0
alialyosofy
Asked:
alialyosofy
1 Solution
 
slightwv (䄆 Netminder) 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;
0
 
alialyosofyAuthor 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.
0
 
slightwv (䄆 Netminder) 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.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
alialyosofyAuthor Commented:
I want any third party network commands regardless oracle to get Client informations in Remotly Citrix Client Connection
0
 
alialyosofyAuthor Commented:
It is good added to this Citrix Zone, I hope to find Optimal Solution
0
 
Geert GruwezOracle dbaCommented:
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
0
 
alialyosofyAuthor 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.
0
 
Sekar ChinnakannuSenior EngineerCommented:
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
0
 
alialyosofyAuthor 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.
0
 
CoralonCommented:
The MAC address is not directly accessible.  The IP is easily to get, and the client name is easy to get.

The CLIENTNAME and CLIENTADDRESS are in the registry under HKLM\Software\Citrix\ICA\Session\sessionnumber\CLIENTNAME
HKLM\Software\Citrix\ICA\Session\sessionnumber\CLIENTADDRESS

The ClientName is also in an environment variable, called CLIENTNAME :-)

You could potentially use the MS networking APIs to get the MAC, assuming they are not behind a NAT.  If they are behind a NAT, then I have no idea how you would get that.

Also, read up on the TSAPI32.DLL - this provides most of the client information that is available to the system.

Coralon
0
 
alialyosofyAuthor 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
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now