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

Chetan

February 6, 2012 04:40 CST

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

Gordon Wilton

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.

Raj

November 21, 2014 01:31 CST

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

Vish

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.

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

Jeffry Castro

May 20, 2015 17:32 CST

Help Me a lot, thank you so much!

Glenn

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,
-GB

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.

Raf

October 28, 2015 03:44 CST

Hi

Do you have a script for 7.6?

Stan Czerno

October 28, 2015 03:46 CST

No, not yet.

Raff

October 28, 2015 20:47 CST

Thanks for the super quick reply!

Prakash G

December 18, 2015 00: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: ( [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.

Sitrarasu

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

YugandharAnanda

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!