The Monitor Service Open Data API

In addition to using the Citrix Director console, historical data is available by querying the Monitor Service using the Open Data (OData) protocol (http://www.odata.org).

Using the OData API, you can get information about objects such as hypervisors, machines, desktop groups, users, sessions, and connections.

The following two endpoints are exposed by the Delivery Controller server:

• The Methods endpoint (used by the Director): http://<dc-server>/Citrix/Monitor/OData/v1/Methods
• The Data endpoint (with read-only access and support for the OData query language): http://<dc-server>/Citrix/Monitor/OData/v1/Data

Before being able to retrieve the data, you must authenticate with a valid account. The data you can access is determined by XenApp roles and permissions.

Using Excel PowerPivot

PowerPivot is a free plugin for Excel; you can download it from Microsoft's website.

After having installed it, open Excel and click on the PowerPivot tab, and then...