About Your Wire Data Authors

John Smith:

I am a 16 year IT veteran from Unix/Linux to Mainframes,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.


I can be reached at  john@wiredata.net

Linked In Profile

Dona Stewart:

Dona is a former geography professor turned project manager and data analyst. Passionate about the analytic power of Python.

6 thoughts on “About Your Wire Data Authors

  1. Paul

    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. Adrian


    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 ?



    1. John M. Smith


      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.



      1. Adrian

        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

        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.


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

        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 ?



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

    1. John M. Smith

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

      Take care Stan



Leave a Reply