Filtered articles: "SQL Server"

In my series about custom report for Citrix EdgeSight, I introduced a lengthy example query for system performance including standard constructs for filtering by time and department as well as machine groups. Now that we know about additional parameters for process categories and user groups, let’s have a look at an example SQL query.

This week I tried to write a simple PowerShell script to connect and create a new database on a Microsoft SQL-Server. The script’s purpose is to create the new database in an automated Citrix XenApp 6 installation with a given domain-user account. The script will be started as a task in a task sequence. Because of a malfunction in SCCM vNext I can't start the task with a given domain service account. After some research I found out that there are three different ways to access a SQL Server with PowerShell. Especially the access with given domain credentials doesn’t work as I expected!

After explaining the schema of the EdgeSight database in the previous article in this series, I will now show you how to formulate SQL queries to retrieve data from the EdgeSight database by starting out slowly and building typical example just like it is used by Citrix for many reports in the product.

Please accept that I cannot provide you with a general introduction to SQL. There are some valuable resources on the web. It is not that hard to learn the basics to understand the queries presented herein.

For quite a while now, Citrix is offering EdgeSight for performance analysis and historical reporting. It started off for endpoints and XenApp (still called Presentation Server at that time) and now includes virtual desktops as well. EdgeSight is offering a huge number of reports seemingly covering all possible aspects of performance analysis.

But in my eyes, the agents are collecting a lot more pieces of information than the reports are able to display. This article is the first in a series describing the EdgeSight database schema, what is necessary for a valid query and how it is built into a report.