We are deploying DCRUM 12.2 in Citrix environment. We would like to know, if is it possible to associate the citrix user with queries executed in database server?
Is there a configuration to associate them?
The database server is accessed through of application in citrix farm, however, we are unable to identify who are the citrix users. The unique user that has been identified was the user to do the authentication with database server.
In this case we are seeing just the unique user (application user) but we are not seeing the citrix user (the customer).
TCAM is already installed in citrix server of the farm.
Thanks for your help.
Yes - you should be able to exactly this, However - this depending on whether there is encryption turned on in Citrix or not and what kind
Check chapter 2 in the "Citrix/Windows Terminal Services Monitoring User Guide" PDF
It's never mandatory to configure anything It all depends on what you want to see and how you want to see it.
Some shops only care about the connection between the User and the first tier while others want to see the whole ADC (Application Delivery Chain) including LoadBalancers, Firewall and DNS. Others only care for fractions of a ADC since some components and functions are outside their control (or care).
What do you need toi visualise and measure?
What comes to mind is turning off User Identification on the SQL tier but somehow relating the SQL connection with the Citrix connection.
I would recommend opening a ticket with support to see if this is a way or if they have a better idea.
In the case of integration Citrix user with Oracle queries, was necessary to disable the user name recognition in Oracle Software Service.
After the change has been possible to see the Citrix Users associated with the queries in the database, because the Citrix was using Microsoft Domain Account and the Oracle was using internal users.