Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Course Of The Month
2 days, 22 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Getting Client informations in Remotly Citrix Client Connection
Posted on 2013-01-02
How getting Machine name and its Mac address in Remotly Citrix Client Connection
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
6
2
- +2
12 Comments
Active today
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;
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;
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.
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.
Active today
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.
If the end app is custom code, you can probably add this info and pass it along to Oracle.
I want any third party network commands regardless oracle to get Client informations in Remotly Citrix Client Connection
Active 1 day ago
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
> 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
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.
Active 3 days ago
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
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.
Active 1 day ago
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\S
HKLM\Software\Citrix\ICA\S
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
The CLIENTNAME and CLIENTADDRESS are in the registry under HKLM\Software\Citrix\ICA\S
HKLM\Software\Citrix\ICA\S
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
Featured Post
Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| how to tune the query | 17 | 87 | |
| Oracle - BLOB Extract Line | 2 | 21 | |
| Reasons for disabling SMB signing? | 5 | 51 | |
| Ability to change a Server 2008 R2 FQDN without disrupting environment or clients | 9 | 20 |
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
Suggested Courses
Course of the Month2 days, 22 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.