EdgeSight: Reporting On Non-PC Devices

UPDATE: Added new WHERE statement to select just iOS devices (see below).

Intro

Today’s workplace no longer follows a strict standard in terms of endpoint devices.  Despite the efforts of your infrastructure, network, and security teams users are connecting non-approved devices to your network and your Citrix farm.  A lot has been said about the “Consumerization of IT” and it is a reality for any Citrix administrator/engineer.  In this blog post we will explore how to find these types of devices using EdgeSight.

The Query

We will use the VW_ES_USERGROUP_ICA_USERS view for this query.  Here are the columns in this view:

image

Here is a sample of data in this view (customer specific information hidden):

image

Mobile Devices

The following query will select mobile devices that connected to your farm in the last 30 days.

SELECT CONVERT(VARCHAR,dtlast,111) AS 'Date', account_name, client_buildnum, client_productid, client_disp_horiz, client_disp_vert
FROM vw_es_usergroup_ica_users
WHERE client_name = 'mobile'
and account_name <> 'UNKNOWN'
and CONVERT(VARCHAR,dtlast,111) >= getdate() - 30
ORDER BY 'Date' DESC

UPDATE: While working on a similar query for work, I found that you may also select iOS devices by using the following in your WHERE statement

WHERE client_name like 'iOS%'

Here’s a sample of the output:
image

The new Citrix Receiver sets the client name to ‘mobile’. On a PC this is typically the environment variable %COMPUTERNAME%.  To find the devices that are connecting, you can use the horizontal (client_disp_horiz) and vertical (client_disp_vert) resolutions and compare them to current resolutions of mobile devices.  I found a nice reference list here.  This can get you half-way there.  The only other way that I’ve been able to distinguish the client that is connecting are the ‘client_buildnum’ and ‘client_productid’ fields.  Unfortunately, finding an updated list of ICA/Receiver build numbers is not easyStephane Thirion at Archy.net provides a recently updated list.

Thin Clients

We can also use VW_ES_USERGROUP_ICA_USERS to report on thin client devices.  It is unlikely that thin clients will be an unapproved device on your network, but we can get some useful data on them from this view.  The following query will select thin client devices that connected to your farm in the last 30 days.

SELECT CONVERT(VARCHAR,dtlast,111) AS 'Date', account_name, client_directory, client_version, client_buildnum, client_productid, client_disp_horiz, client_disp_vert
FROM vw_es_usergroup_ica_users
WHERE client_directory like '\%'
and account_name <> 'UNKNOWN'
and CONVERT(VARCHAR,dtlast,111) >= getdate() - 30
ORDER BY 'Date' DESC

Here’s a sample of the output:
image

If the thin client is windows-based, chances are the client_version field will give you the currently installed ICA client on the device.  You can use this information to pester the person in charge of thin client’s to update them or replace them (just kidding – but really you need to get them updated).  For this example, we examined the ‘client_directory’ column and determined that if it started with a  ‘\’, it was a thin client.  You may have to experiment with this field depending on which thin clients you have in your environment.

I hope this post has shown you how to track down non-pc devices connecting to your Citrix farm.  Once you have determined the ICA/Java client versions connecting to your farm (see the ICA Client Version report in EdgeSight!) you can modify these queries to find Java client users and Macintosh users.

As always I welcome all comments and questions.

Thanks,
Alain

Advertisements

Article: CTX113514 – How to Determine the Version of the Installed EdgeSight Agent

While researching an EdgeSight agent install issue I came across this great CTX article. I would bookmark this page for future reference.

CTX113514 – How to Determine the Version of the Installed EdgeSight Agent – Citrix Knowledge Center.

How to Determine the Version of the Installed EdgeSight Agent

Document ID: CTX113514   /   Created On: Jun 26, 2007   /   Updated On: May 4, 2011

Summary

This document describes how to determine the version of the installed EdgeSight Agent and where to find the EdgeSight Agent software.

Background

Below are the EdgeSight Agent versions as of May 2011.

(Alain's note: see original CTX article for full table)
Version Status Release Component Availability Where to find SA Burn-in
5.3.4136.3 Current 5.3 Hotfix 4 Agent for XenApp6 (x64), ES530XA6AgentWX64003 2011-05-02 CTX129053 – Hotfix ES530XA6AgentWX64004 (Version 5.3.4136.3) – For Citrix EdgeSight 5.3 XenApp6 Agent x64 2009-09-18
5.3.4136.3 Current 5.3 Hotfix 4 Agent for XenApp (x64), ES530XAAgentWX64003 2011-05-02 CTX129029 – Hotfix ES530XAAgentWX64004 (Version 5.3.4136.3) – For Citrix EdgeSight 5.3 XenApp Agent x64 2009-09-18
5.3.4136.3 Current 5.3 Hotfix 4 Agent for XenApp (x86), ES530XAAgentWX86003 2011-05-02 CTX129028 – Hotfix ES530XAAgentWX86004 (Version 5.3.4136.3) – For Citrix EdgeSight 5.3 XenApp Agent x86 2009-09-18
5.3.4135.6 Current 5.3 Hotfix 3 Agent for VDA (x64), EDGESIGHTVDAAGENTX64.msi 2011-03-09 CTX128095 – Hotfix ES530VDAAgentWX64002 (Version 5.3.4135) – For Citrix EdgeSight 5.3 Virtual Desktop Agent x64 2009-09-18
5.3.4135.6 Current 5.3 Hotfix 3 Agent for VDA (x86), EDGESIGHTVDAAGENT.msi 2011-03-09 CTX128094 – Hotfix ES530VDAAgentWX86002 (Version 5.3.4135) – For Citrix EdgeSight 5.3 Virtual Desktop Agent x86 2009-09-18
5.3.4132.0 Current 5.3 Hotfix 1 Agent for EndPoints (x64), ES530EPAgentWX64001 2010-08-26 CTX126259 – Hotfix ES530EPAgentWX64001 (Version 5.3.4132) – For Citrix EdgeSight 5.3 Endpoint Agent x64 2009-09-18
5.3.4132.0 Current 5.3 Hotfix 1 Agent for EndPoints (x86), ES530EPAgentW86001 2010-08-26 CTX126258 – Hotfix ES530EPAgentWX86001 (Version 5.3.4132) – For Citrix EdgeSight 5.3 Endpoint Agent x86 2009-09-18
5.2.3012.0 5.2 sp1 ALL 2009-10-23 Citrix.com 2009-09-18
5.2.2183.0 5.2 ALL 2009-09-21 Citrix.com 2009-09-18
Version Status Release Component Availability Where to find SA Burn-in
5.3.4135.4 Superseded 5.3 Hotfix 3 Agent for XenApp6 (x64), ES530XA6AgentWX64003 2011-01-21 CTX127387 – Hotfix ES530XA6AgentWX64003 (Version 5.3.4135.4) – For Citrix EdgeSight 5.3 XenApp6 Agent x64 2009-09-18
5.3.4135.4 Superseded 5.3 Hotfix 3 Agent for XenApp (x64), ES530XAAgentWX64003 2011-01-18 CTX127386 – Hotfix ES530XAAgentWX64003 (Version 5.3.4135.4) – For Citrix EdgeSight 5.3 XenApp Agent x64 2009-09-18
5.3.4135.4 Superseded 5.3 Hotfix 3 Agent for XenApp (x86), ES530XAAgentWX86003 2011-01-18 CTX127385 – Hotfix ES530XAAgentWX86003 (Version 5.3.4135.4) – For Citrix EdgeSight 5.3 XenApp Agent x86 2009-09-18
5.3.4134.3 Superseded 5.3 Hotfix 2 Agent for XenApp6 (x64), ES530XA6AgentWX64002 2010-11-05 CTX126912 – Hotfix ES530XA6AgentWX64002 (Version 5.3.4134) – For Citrix EdgeSight 5.3 XenApp6 Agent x64 2009-09-18
5.3.4134.3 Superseded 5.3 Hotfix 2 Agent for XenApp (x64), ES530XAAgentWX64002 2010-11-05 CTX126911 – Hotfix ES530XAAgentWX64002 (Version 5.3.4134) – For Citrix EdgeSight 5.3 XenApp Agent x64 2009-09-18
5.3.4134.3 Superseded 5.3 Hotfix 2 Agent for XenApp (x86), ES530XAAgentWX86002 2010-11-05 CTX126910 – Hotfix ES530XAAgentWX86002 (Version 5.3.4134) – For Citrix EdgeSight 5.3 XenApp Agent x86 2009-09-18
5.3.4132.3 Superseded 5.3 Hotfix 1 Agent for XenApp6 (x64), ES530XA6AgentWX64001 2010-08-06 CTX125868 – Hotfix ES530XA6AgentWX64001 (Version 5.3.4132) – For Citrix EdgeSight 5.3 XenApp6 Agent x64 2009-09-18
5.3.4132.3 Superseded 5.3 Hotfix 1 Agent for XenApp (x64), ES530XAAgentWX64001 2010-07-29 CTX125867 – Hotfix ES530XAAgentWX64001 (Version 5.3.4132) – For Citrix EdgeSight 5.3 XenApp Agent x64 2009-09-18
5.3.4132.3 Superseded 5.3 Hotfix 1 Agent for XenApp (x86), ES530XAAgentWX86001 2010-07-29 CTX125866 – Hotfix ES530XAAgentWX86001 (Version 5.3.4132) – For Citrix EdgeSight 5.3 XenApp Agent x86 2009-09-18
5.3.4109.0 Superseded 5.3 Agent for XenApp (x64), EDGESIGHTXAAGENTX64.msi 2010-04-20 Citrix.com 2009-09-18
5.3.4109.0 Superseded 5.3 Agent for XenApp (x86), EDGESIGHTXAAGENT.msi 2010-04-20 Citrix.com 2009-09-18
5.3.4101.0 Superseded 5.3 Agent for VDA (x64), EDGESIGHTVDAAGENTX64.msi 2010-04-20 Citrix.com 2009-09-18
5.3.4101.0 Superseded 5.3 Agent for VDA (x86), EDGESIGHTVDAAGENT.msi 2010-04-20 Citrix.com 2009-09-18
5.3.4101.0 Superseded 5.3 Agent for EndPoints (x64), EDGESIGHTEPAGENTX64.msi 2010-04-20 Citrix.com 2009-09-18
5.3.4101.0 Superseded 5.3 Agent for EndPoints (x86), EDGESIGHTEPAGENT.msi 2010-04-20 Citrix.com 2009-09-18
5.3.4101.0 Superseded 5.3 Agent for XenApp6 (x64), EDGESIGHTXA6AGENTX64.msi 2010-03-11 Citrix.com 2009-09-18

The RTM release and service packs are downloaded from Citrix.com. It is not necessary to install the RTM release prior to installation of the Hotfix.

About EdgeSight Hotfix

• The Hotfix is downloaded from the public Knowledge Center site, using the designated CTX article.

• Each specific component is downloadable from a separate individual CTX article.

• Each EdgeSight 5.3 Hotfix is a full installation (can run as new installation or upgrade installation; does not require previous EdgeSight 5.3 versions).

• To subscribe to a Hotfix, the subscriber selects a method under Resources (such as “Add to your hotfix alerts” for email notification) after choosing the product line (such as http://support.citrix.com/product/es/xav5.3/ for EdgeSight for XenApp/XenApp 6; http://support.citrix.com/product/es/epv5.3/ for EdgeSight for EP/VDA).

• Currently EdgeSight Hotfix is distributed in the form of a MSI installer.

Procedure to determine the agent version

Method 1

  • Using the EdgeSight web console, navigate to the Configure (tab) > Company Configuration > Device Management > Devices.
  • From the Show: drop-down menu, select EdgeSight Version/Functionality.
  • The Device name is shown with the corresponding EdgeSight Version.

EdgeSight 5.3 server showing a sample set of device agent versions:

Method 2

  • EdgeSight agents log the version number upon startup. This information can be viewed in the SYS_EVENT_TXT.txt file on the EdgeSight Agent device
  • Upon startup, the first line that it writes to this log file contains the EdgeSight core version.
  • The SYS_EVENT_TXT.txt log file can be found as follows:
    %allusersprofile%\Application Data\Citrix\System Monitoring\Data\

Sample text:

2010-04-21 10:57:52 Core     Service     —– Starting Agent on <someMachineName> version 5.3.4109.0 —–Old Versions (EOL reached)

Release Version Component Availability SA Burn-in
5.1.1 5.3.4109.0 ALL 2010-03-02 2009-08-27
4.5 sp5 4.5.3304 ALL 2010-08-25

Old Versions Memo: The agent is a multi-product architecture with a core component and an extension component. The only extension component available is EdgeSight so this is more commonly referred to as simply the EdgeSight version. Because of these two components, you might see two different version numbers reported by the EdgeSight Agent.

Release version Agent version Core if different
5.1.1 5.1.1110.0
5.1* 5.1.1104.0
5.0 SP2* 5.0.622.0
5.0 SP1* 5.0.275.0 5.0.236.0
5.0.1* 5.0.269.1 5.0.233.0
4.5 sp5 4.5.3304
4.5 sp4* 4.5.3295 4.5.3275
4.5 sp2* 4.5.3281 4.5.3267
4.5 sp1* 4.5.3261 4.5.3253
4.5* 4.5.3244 4.5.3237
4.2 sp3* 4.2.2937 4.2.2896
4.2 sp2* 4.2.2928 4.2.2888
4.2 sp1* 4.2.2922 4.2.2879
4.2* 4.2.2902 4.2.2866

*Note: Some EdgeSight versions (4.5 Service Pack 2 through 5.1) become inoperable beyond March 25, 2010, because of expired digital certificates. These software versions will not function properly after this date. Version 5.1.1 or 5.2 (or later than 5.2) is required to function properly.

More Information

CTX125986 – How to Determine the Version of the Installed EdgeSight Server

Thanks,
Alain

Article: Finding the XenServer 6.0 Beta

Finding the XenServer 6.0 Beta
http://blogs.citrix.com/2011/07/06/finding-the-xenserver-6-0-beta/

Here’s how to find the public XenServer 6.0 Beta:
1. Log on to your MyCitrix account. You do not need to be an existing customer. You can create one for free.
2. Go to XenServer Beta Central (http://www.citrix.com/xenserver/beta) – and click the Download Now button.

20110706-071239.jpg

3. On the XenServer 6.0 Beta page, expand the Show Downloads link for the item you want to download. The files for XenServer 6.0 itself are in the first section. Workload Balancing and the License Server are under XenServer Advanced Management Services.

Here are a few other links you might find handy:

Webinar with live demonstrations of the new features on July 7. Register here: https://www1.gotomeeting.com/register/656087777
XenServer Project Boston Public Beta Forum – http://forums.citrix.com/forum.jspa?forumID=1273
XenServer Project Boston Usability Forum – http://forums.citrix.com/forum.jspa?forumID=1274

—-

Sarah Vallieres – Principal Technical Writer – XenServer
Twitter: @xsresearcher