The following examples show how to export Monitor Service data using the OData API.
Example 1 - Raw XML
Example 2 - PowerPivot with Excel
These instructions assume that you have already installed Microsoft Excel and PowerPivot.
Open Excel (running with the appropriate administrative permissions for the XenApp or XenDesktop Site).
If you are using Excel 2010:
If you are using Excel 2013:
Example 3 - LINQPad
These instructions assume that you have already installed LINQPad.
For further worked examples of how to use the API with LINQPad, see http://blogs.citrix.com/2014/01/14/creating-director-custom-reports-for-monitoring-xendesktop/.