XenDesktop 5 DataStore - ConnectionLog

XenDesktop 5 DataStore - ConnectionLog -

It has been nine months that I posted and I was really busy with client projects. I'll start a new blog entry talking about the ConnectionLog SQL table XenDesktop 5 datastore. Currently I am supporting a customer on site and help them solve a user problem connecting. Looking at the table chb_State.ConnectionLog in the SQL database, I can check the past of all virtual desktop connections for the last 2 days and connection failures, if any. Connection failures are indicated in the ConnectionFailureReason table column and an integer value can be from 0 to 5:

0 - Connection is successful
1 - Failure to prepare session
2 - VDA registration timeout
3 - connection time
4 - connection failed because of a license
5 - Failed to connect because of the ticket

other columns BrokeringUserUid WorkerUid and can be referenced UID AccountNames WorkerNames tables and obtain user account ID and VM hostname.

by default, the login history logs are stored for 2 days before being purged by the XenDesktop Broker service. However this can be changed by creating the registry entry "HKLM Software Policies CitrixDesktopServer Logging ConnectionLogLifetimeHour of 'type DWORD on DDC servers. The value is set in hours (default is 48 hours).

Finally, I want to mention an excellent tool that you can use to easily retrieve diagnostic data from the database. This tool is called XDDBDiag and the latest version 2.3 can be downloaded from CTX128075 . using this, you can also do a check of the consistency of data on the data from your database and outputs as the value XD5 in connection logs comma separated (.csv) located in a compressed file (.zip) .

Tweet