Inside EdgeSight Report Parameters

In part 3 of my series about custom reports for Citrix EdgeSight, I have listed some parameters that are automagically recognized by EdgeSight. Those parameters cause EdgeSight to display specialized picker or pre-populated dropdown lists. But Citrix does not provide a current documentation for report parameters processed by EdgeSight. Therefore, it’s back to reading existing reports to discover those parameters. In this article, I will introduce some more parameters for EdgeSight reports and publish a report to examing values passed from the EdgeSight web-based console to the report.

EdgeSight Report Parameters

Whenever a report is loaded in the EdgeSight console, it is parsed for report parameters. When a magic parameter name is encountered, EdgeSight displays pre-defined UI elements. In part 3 of my series about custom EdgeSight reports, I have elready listed the four mosted important parameters:

But there are more parameters. In general, whenever EdgeSight displays a special UI element, a special parameter is used in the report. So far, I am aware of the following parameters:

Both parameters can be set to zero to indicate that no filter is required through this parameter.

The following screenshots visualize which input fields control which parameters:

EdgeSight report parameters 1

EdgeSight report parameters 2

Yet, there are certainly more parameters for selecting individual devices, users and processes. But so far, I have not had the need to use them.

Writing and Testing Queries

The tricky thing about a custom EdgeSight report is writing the query to pull pieces of information from the database. This requires a thorough understanding of the database schema. Business Intelligence Development Studio (BIDS) is a nice tool for creating the graphical layout required for the report but does not qualify for writing an SQL query with the necessary facilities for exploring the database and autocompletion of tables and fields. Therefore, it is more likely that a tool like the SQL Server Management Studio (SSMS) suites our needs concerning the mentioned capabilities.

But SSMS does not handle parameters for EdgeSight reports properly so that we will have to manually declare those variables usually provided automagically by EdgeSight. This only poses a problem for more complex parameters like @Filter which cannot be easily deduced from the database or by common sense. In my article about SQL queries for EdgeSight reports, I stated that some values are save presets for the four most important parameters.

Unfortunately, these values are far from realistic. Because proper values for all report parameters can only be pulled from the EdgeSight console, I have created a report that displays the values for all report parameters currently known to me and resolves them to human readable values.

Example report to visualize EdgeSight report parameters

So, if you are working on new reports, grab my report and explore those parameter values. Afterwards build a proper header (like the one below) and use it in SSMS for testing your SQL queries.

SET @CompId = 1 /* first company */
SET @Filter = 1 /* filtered by department */
SET @Start = -7 /* report starts 7 days before today */
SET @End = -1 /* report end yesterday */
SET @Category = 0 /* no process category */
SET @UserGroup = 0 /* no user group */

I hope it helps you as much as it helped me.

Feedback is always welcome! If you'd like to get in touch with me concerning the contents of this article, please use Twitter.