Script to create a report of Citrix Presentation Server v4-v4.5 and XenApp 5 Published Applications in Excel

by Stan Czerno July 21, 2011 18:03 CST

This script uses MFCOM and VBScript to create a report of Citrix Published Applications in Excel.

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

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

Tags: , , , ,

Catergories: Citrix | XenApp | VBScript

Comments (19) -

Stephan H. Germany
February 8, 2012 16:15 CST

Nice Script... Very Quick... High Detail... Perfect Format... Thanks a lot!!!! Wink

Reply

Nicole Australia
June 11, 2012 19:26 CST

Hi,

Great script, but is there a way to have it report also on Enabled and Disabled applications?

Thanks

Reply

Lal Mohan New Zealand
August 22, 2012 21:22 CST

Awesome Script

Reply

Serge Canada
February 27, 2013 11:19 CST

Does this script show what are the configured users for each application?

Thanks

Reply

Halla France
May 23, 2013 14:40 CST

nice script Thanks lots!
regards

Reply

Raj India
June 6, 2013 03:28 CST

Truely this is very good script. Working just like bullet speed.

Good work done Czerno Smile

thanks alot

Reply

Wojtek
June 4, 2014 05:26 CST

Great job !!!!!
Just one thing to add enabled/disabled into the report would be great.

Reply

Joƫlle
March 13, 2015 05:40 CST

Thank you for the sharing !

Reply

Muthukumar
March 23, 2015 06:38 CST

Ultimate script, done a miracle to fetch the data for Citrix 4.0. Thanks alot.

Reply

Vinoth
January 22, 2016 09:07 CST

Could you please share the script to list the disabled application in metaframe presentation server 4.0

Reply

naveen
March 7, 2016 03:59 CST

Hi All,

Using Script we can pull the active sessions users list on presenation server 4.5  please share the script ?

Reply

Ruwan
April 7, 2016 21:16 CST

Really nice script Smile. You saved lot of our time.

Reply

Kishore
July 13, 2016 08:58 CST

First I would like to say Thank You for providing the really nice script. I have some issues while running the script and getting and error at line no: 280, Char:2 with Error :unspecified error;  Code : 80004005

Reply

Stan Czerno
July 13, 2016 09:17 CST

Are you sure you are running this as a XenApp administrator? Are you running this from one of the XenApp servers? Is the MFCOM service running?

I do not even have anything this old to test against anymore so I cannot really help you. All I have running is XA 6.5 and 7.8.

Reply

Kishore
July 13, 2016 09:56 CST

Thank you for the quick reply.. It seems that I don't have complete access on the Citrix farm. I've executed the script in different farm and it works perfectly. Thank you once again.

Do you have any script for XA 6.5 to get the farm inventory ?

Reply

Stan Czerno
July 13, 2016 10:01 CST

Yes, I have a PowerShell equivalent for XA 6.5: czerno.com/.../PowerShell-Script-to-create-a-report-of-Citrix-XenApp-6-Published-Applications-in-Excel

Reply

Kishore
July 14, 2016 02:52 CST

Thank You for the reply!! Script works perfectly.

Reply

Terry
August 11, 2016 10:41 CST

I get the following if I click yes to application details, works fine if i click no.

queryapps.vbs(144, 4) (null): Unspecified error

This is the code that starts there:
Else
      Set aWinApp = mfApp.WinAppObject
      getservers()
      getusers()
      getgroups()

      objExcel.Cells(CurrentRow, 1).Value = mfApp.DistinguishedName
      objExcel.Cells(CurrentRow, 2).Value = mfApp.AppName
      objExcel.Cells(CurrentRow, 3).Value = mfApp.FarmName

      If aWinApp.PNAttributes = 8 Then
              objExcel.Cells(CurrentRow, 4).Value = "Published Desktop"
              objExcel.Cells(CurrentRow, 5).Value = ""
            Else
              objExcel.Cells(CurrentRow, 4).Value = aWinApp.DefaultInitProg
              objExcel.Cells(CurrentRow, 5).Value = aWinApp.DefaultWorkDir
            End if
      objExcel.Cells(CurrentRow, 6).Value = appservers
      objExcel.Cells(CurrentRow, 7).Value = appusers
      objExcel.Cells(CurrentRow, 8).Value = appgroups
                        
    End if

Reply

Stan Czerno
August 11, 2016 10:51 CST

You'll just have to try to figure out which part is failing by using some wscript.echo lines to see which command is failing. I do not have a farm running this old stuff anymore to confirm it still works.

I would start by trying to use the following to confirm they are working:

wscript.echo mfApp.WinAppObject
wscript.echo mfApp.DistinguishedName
wscript.echo mfApp.AppName
etc
etc

Reply

Add comment