PowerShell Script to create a report of Citrix XenApp v6-v6.5 Published Applications in Excel

by Stan Czerno November 18, 2011 14:45 CST

This script uses PowerShell and the Citrix XenApp PowerShell SDK to create a report of Citrix Published Applications in Excel.


Let me know what you think about the script and if you have a better way of doing this.

Tags: ,

Catergories: Citrix | XenApp | Powershell

Comments (16) -

Chetan United Kingdom
February 6, 2012 04:40 CST

Thanks for this Script. It works like Charm.....

Gordon Wilton United Kingdom
July 17, 2012 23:40 CST

The script works great whilst logged in to a server - i have noticed that if its scheduled to run  it does produce a csv file but wont produce the *.xlsx file and the excel process will just contine to use resources until stopped.  Not sure why at the moment.  

The script is still very useful though.

Alexander Augustine
May 17, 2014 21:28 CST

Thanks you so much your script really help me so much in xenapp 5.0 for 2003.

November 21, 2014 01:31 CST

Many thanks for the script, it fulfilled my requirement with the minimal effort.

January 7, 2015 17:29 CST

We have Citrix 4.5 and do not have reporting installed. I would like to know if there is a way to retrieve information regarding how many users are accessing a specific published application. Please assist.

Stan Czerno
January 8, 2015 01:01 CST

You need to setup Resource Manager, it is part of Citrix Presentation Server 4.x.


Jeffry Castro
May 20, 2015 17:32 CST

Help Me a lot, thank you so much!

June 15, 2015 07:26 CST

This is a great script.  I want to run this against a specific server or list of servers how would I do this?
Thank you,

Stan Czerno
June 15, 2015 07:29 CST

The script reports against the Farm, not individual Servers. Installed the SDK on one server, per farm, then run the script.

October 28, 2015 03:44 CST


Do you have a script for 7.6?

Stan Czerno
October 28, 2015 03:46 CST

No, not yet.

October 28, 2015 20:47 CST

Thanks for the super quick reply!

Prakash G
December 18, 2015 00:01 CST

Thank you for the wonderful script and it was working in many environments for my setup.
But, after loading the "pssnapin" -- Get-XAFarm command itself taking more time to execute and finally it throw an error message stating that,

"PS H:\> add-pssnapin citrix*
PS H:\> get-xafarm
Get-XAFarm : The open operation did not complete within the allotted timeout of 00:00:00. The time allotted to this ope
ration may have been a portion of a longer timeout.
At line:1 char:11
+ get-xafarm <<<<
    + CategoryInfo          : NotSpecified: (Smile [Get-XAFarm], TimeoutException
    + FullyQualifiedErrorId : System.TimeoutException,Citrix.XenApp.Commands.GetFarmCmdlet"

Please advice to proceed further.

Stan Czerno
December 18, 2015 00:58 CST

Not sure, is the Server under a heavy load?

Are you running this locally? If not: carlwebster.com/.../

The error is from the Powershell cmdlet, I did not write that.

March 1, 2016 06:26 CST

You cannot call a method on a null-valued expression.
Hi I am getting below error. Please help to resolve the issue.

At line:5 char:19
+  $excel.cells.item <<<< ($i,3) = $process.FolderPath
    + CategoryInfo          : InvalidOperation: (item:String) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At line:6 char:19
+  $excel.cells.item <<<< ($i,4) = $process.Enabled
    + CategoryInfo          : InvalidOperation: (item:String) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

March 4, 2016 02:15 CST

Hello Stan,

Wonderful script to create published applications.

But i have a query. In my farm there are 33 published applications/desktops. But when i generated the script, It is showing only 20 applications in the Excel sheet.
May i know where is the problem.

Thanks in advance!

Comments are closed