MFCOM Script - Published Application Server Wise, in the Scripting / Automation forum on BrianMadden.com

Reply

Anurag Goswami Posted: Thu, May 21 2009 11:58 AM

rated by 0 users

Hi,

I have MFCOM Script which gives me information of farm like applications published on farm,application path,groups,users who has access on the applications.

But the information which I am getting in this I need to format that information and this takes long time to do formatting.

Secondly sometimes I want to see on which server how many applications are published which user or group has access on the published application.

Can someone please help me to modify script which would provide me information:

1. Script sends data in Excel and information would comes in rows and columns.

2. I need server wise published application details.

Thanks in advance.

Anurag

Script:

Dim mfFarm
Dim mfApp
Dim mfGrp
Dim mfUsr

Set mfFarm = CreateObject("MetaFrameCOM.MetaFrameFarm")
mfFarm.Initialize 1

For Each mfApp In mfFarm.Applications
mfApp.LoadData 1

WScript.Echo "Published Application - " & mfApp.Appname
WScript.Echo " Application Location"
WScript.Echo " " & mfApp.WinAppObject.DefaultInitProg
WScript.Echo

WScript.Echo " Groups"
For Each mfGrp In mfApp.Groups
WScript.Echo " " & mfGrp.GroupName
Next

WScript.Echo
WScript.Echo " Users"
For Each mfUsr In mfApp.Users
WScript.Echo " " & mfUsr.UserName
Next

WScript.Echo " Servers"
For Each mfUsr In mfApp.Servers
WScript.Echo " " & mfUsr.ServerName
Next
WScript.Echo

Next

Reply

Michael Scardigno replied on Sun, Jun 14 2009 12:02 PM

rated by 0 users

Hi Anurag,

To accomplish you goal, you would need to first load up all your data into a relational database and then output the data to a web page(s).   I have already developed such a system.   Let me know if you would like further information on how to implement this.

Michael

Reply

Mike Johnson replied on Mon, Jun 22 2009 2:51 AM

rated by 0 users

Here is the trick, do the following

- Create Column headings for each of the coulmns, servers, users groups and published apps (in the excel file used to output values)

- Enable  Data filter feature in excel for that first row with column names and from there you can do what you are looking for!!

Reply

Alan Osborne replied on Tue, Jun 23 2009 5:29 PM

rated by 0 users

FYI: You might want to have a look at this utility from Citrix:

http://support.citrix.com/article/ctx119955

Also, this website has some decent tools as well:

http://ctxadmtools.musumeci.com.ar/

And there is the Citrix Documentor:

http://www.brianmadden.com/content/article/Ilja-Godau-Releases-Tool-to-Automatically-Document-your-Citrix-PS4-Environments