A nice Excel report of published applications, servers, etc... dynamically updated on a regular basis., in the Citrix XenApp / Presentation Server forum on BrianMadden.com

My boss wants a report (preferably Excel) that details which servers we have, what applications are running on them, which ones are published and whether or not they are duplicated on other servers so that we have a backup if one server goes down. I was going to create to excel sheets and simply pipe the results from the qfarm /apps and other commands to an xls file and have one sheet pull info from the other. I came here to see if there is a better way to do it or if someone has a ready made process, program, or script I could use instead of me doing this from scratch myself.