About Your ESUTH Authors

John Smith

I am a 16 year IT veteran from Unix/Linux to M ainframes,my specialties are Access Gateway Enterprise/Netscaler/Application delivery, Application Firewall and Event Correlation as well as back end Citrix XenAPP solutions to include App-V and AIE.    I have extensive experience with existing IT Regualatory framework and consider myself a “digial epidemiologist” from a security standpoint, setting up dashboards to track events such as service desk calls, security breaches, application failures, etc and using this data to predict performance.   I have also been using VMWare since 1.51 and have over 6 years of experience in the virtualization space including ESX, XenServer and Hyper-V.

I also have over ten years of experience in web server administration for various federal and e-Commerce driven solutions that includes IIS, .NET Web Services, Apache Tomcat, WebLogic and Resin Application servers.

Also, In May of this year I was named a Citrix Technology Profesional by Citrix Systems for contributions on the Networking side, I am hoping to make CTP for the Xen Side as well since that is where my career started.

http://community.citrix.com/display/ocb/2010/04/21/Meet+Our+Newest+Citrix+Technology+Professionals+%28CTPs%29

I can be reached at  jmsazboy@gmail.com

Linked In Profile


Alain Assaf

I’m a technology professional who’s worked in IT for 20+ years. In the last few years, I’ve concentrated in virtual technologies from Citrix, VMware, and Microsoft.

I’ve had experience working in diverse environments such as architecture, small business, manufacturing/distribution, medical (hospital), government (federal), industrial (chemical) and most recently healthcare technology.

I’m currently a Certified Citrix Administrator (Presentation Server 4.0 / XenServer 5.0 / XenApp 6.0) and also have CompTia’s Network+.

I now work in Georgia, USA for an international healthcare technology company.

You can view my LinkedIn profile for more information. You can also follow me on Twitter.
I can be reached at: alainassaf <AT> outlook <DOT> com

Thank you,
Alain Assaf


 

David Rowe
I am an IT professional who has been submersed in the virtualization world for the past five years.  I have had the privilege of installing and managing networks in the accounting and medical industries.

I currently work at international healthcare corporation, as a dedicated citrix support engineer.

Recently, I have been dedicating some time to create an EdgeSight report to determine the particular reason why a baby is crying.  I am still awaiting a breakthrough on that task.

I can be reached at davidprowe@gmail.com

Linked in Profile

6 thoughts on “About Your ESUTH Authors”

  1. Love the website, great to see some info about getting deep into edgesight. I’m not a SQL/RDL guru, but maybe you could give aquick overview on how to take one of your queries and getting it into a RDL?

    Also would love to see RDL’s you’ve created.

    But thanks for putting this info out there, I’ve subscribed in google reader. I wish Citrix did more to make it easier to get this info!

  2. John,

    I’m new to EdgeSight and I wonder if you can help me with a question, or possibly several questions but the tme we’ve finished!

    I’m tryng to understand what data EdgeSight actually collects. The pre-prepared reports often average the data, depending on which view you are in, however I have found a report (can’t remember which one right now) that had Max Sessions and Average Sessions at hourly granularity. Now, I’ve been told be the citrix admins that the data is collected hourly, and therefore the Max and Average should be the same – as there is only one datapoint. However, they are different. So, is the data collected at more regular intervals and only reported hourly. Is it configurable ?

    Regards,

    Adrian

    1. Adrian,

      It would depend on the table you are looking at and the interval you were querying. There are two datetime columns that I have seen in some columns Time_stamp which appears to be the time it was uploaded to the database and insterted_date which I believe is the time recorded. Some tables/views have this data, some do not. I have queries that use both Max and Average that are not the same. I would need to know which table/view you are interrogating to be able to tell you for sure.

      Which view are you querying? Also you can set the upload interval but it does cause some stress on the system. We upload payloads twice a day.

      Thanks

      John

      1. Cheers John,

        I’ll have another look at the reports, however, I have limited
        access to the ‘underbelly’ of EdgeSight at the moment and
        only have access to the pre-canned reports as setup by the
        citrix admins (EdgeSight Server V5.2 SP1 (S40) by the way).

        The granularity of the data is obviously quite key as any
        ‘average’ that EdgeSight does will be affected by any
        anomalous peaks/troughs in any underlying data. I have seen
        reports where the ‘average’ logon time has been significantly
        longer for low numbers of users than when fully loaded ! This
        was due to the low user count also having a hugh logon time
        for 1 user that skewed the average.

        Therefore, if data is actually colected at 5 minute intervals
        but reported by EdgeSight averaged to hourly then I would
        want to get my hands on the 5 min data and do my own
        aggregation.

        Ultimately, where I’m trying to get to, is a report the will
        give me the following (either as a query from Excel or CSV
        from EdgeSight for me to import):

        1) Date/Time
        2) Server
        3) CPU%
        4) Memory%
        5) Session Count

        for hourly data (or less if available), over an extended time
        range, say a week, and for a particular set of servers.

        ie

        DateTime, Server, CPU%, Memory%, SessionCount
        04/16/10 00:00, Fred, 45.3, 70, 122
        04/16/10 01:00, Fred, 20, 55%, 45
        etc…

        So far I haven’t managed to find this information
        easy to extract, to say the least…

        Do you think this kind of report is be possible ?

        Regards,

        Adrian

        ps Sorry if the formating looks odd – my typing keeps
        disappearing off of the righthand side of the comment box
        :S

    1. Hey thanks! Let me know if there is anything specific that you are looking to harvest from these logs.

      Take care Stan

      John

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: