Posted by Trevor Best on 07/25/06 12:51

I have some users on Citrix, running an Access front end with ODBC
attached tables.

In sp_who. on a normal workstation they'd usually show once or maybe
more but all with the same hostname so counting actual number of users
is easy, group on loginame,hostname.

When someone connects from a Citrix server, I append the connection
number to the workstation name in the connect string so the hostname
looks something like "CITRIXBOX\ICA-tcp#256" also for terminal services
the hostname will look like "GANDALF\RDP-Tcp#8".

The problem is that on Citrix the user appears twice with a different
tcp number, the hostname is made up of the name of the citrix/ts server
+ the environment variable %SESSIONNAME%, which is surely static for a
session?

Has anyone seen this in Citrix? Does it ghost old connections? I looged
out and in again just now and saw the sessions look like:

CITRIXBOX\ICA-tcp#199 & CITRIXBOX\ICA-tcp#254 for my user name then
after re-logging on I got CITRIXBOX\ICA-tcp#199 & CITRIXBOX\ICA-tcp#256
so that session 199 has stuck there but wasn't visible in sp_who while
not logged into the Citrix box.

[Back to original message]