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

by Stan Czerno November 18, 2011 20:45 CST

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

http://www.czerno.com/default.asp?inc=/html/citrix/scripts/PubAppReportExcelPS.asp

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 10:40 CST

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

Reply

Gordon Wilton United Kingdom
July 18, 2012 04: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.

Reply

Alexander Augustine
May 18, 2014 02:28 CST

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

Reply

Raj
November 21, 2014 07:31 CST

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

Reply

Vish
January 7, 2015 23: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.

Reply

Stan Czerno
January 8, 2015 07:01 CST

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

www.virtualizationadmin.com/.../...ce-manager.html

Reply

Jeffry Castro
May 20, 2015 22:32 CST

Help Me a lot, thank you so much!

Reply

Glenn
June 15, 2015 12: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,
-GB

Reply

Stan Czerno
June 15, 2015 12:29 CST

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

Reply

Raf
October 28, 2015 08:44 CST

Hi

Do you have a script for 7.6?

Reply

Stan Czerno
October 28, 2015 08:46 CST

No, not yet.

Reply

Raff
October 29, 2015 01:47 CST

Thanks for the super quick reply!

Reply

Prakash G
December 18, 2015 06:01 CST

Stan,
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.

Reply

Stan Czerno
December 18, 2015 06: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.

Reply

Sitrarasu
March 1, 2016 12: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

Reply

YugandharAnanda
March 4, 2016 08: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!

Reply

Add comment