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.
I can be reached at jmsazboy@cox.net
Linked In Profile
Alain Assaf:
I’m a technology professional who’s worked in IT for over 15 years. In the last few years, I’ve been able to concentrate 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) and most recently industrial (chemical). 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 chemical company.
You can view my LinkedIn profile for more information. You can also follow me on Twitter.
I can be reached at:alainassaf-wagthereal2010@yahoo.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
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!
Posted by Paul | March 10, 2010, 1:08 amJohn,
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
Posted by Adrian | March 16, 2010, 5:15 amAdrian,
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
Posted by John M. Smith | March 16, 2010, 6:02 amCheers 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
Posted by Adrian | March 16, 2010, 7:27 amThese are some great tips! Keep ‘em coming!!
Posted by Stan | April 6, 2010, 2:46 pmHey thanks! Let me know if there is anything specific that you are looking to harvest from these logs.
Take care Stan
John
Posted by John M. Smith | April 6, 2010, 7:24 pm