XenAppAudit

Now Available!

The purpose of the XenAppAudit Utility is to take XenApp audit data collection from days down to minutes.  The XenAppAudit Utility provides the following:

  • Automated data collection for Citrix XenApp Farms (versions 4 – 6.5)
    • Utilizing VBSCRIPT, MFCOM, WMI, and POWERSHELL scripts
  • Data Analysis using Microsoft Access
    •  Graphical User Interface
    • Custom data conversion functions
    • Summary Reports for Analysis
  • Excel Spreadsheets for Additional Summary Analysis

XenAppAudit Main Menu

Want more?

 

Disclaimer: This software application is provided to you “as is” with no representations, warranties or conditions of any kind. You may use and distribute it at your own risk. Andy Paul and Paul Technologies disclaims all warranties whatsoever, express, implied, written, oral or statutory, including without limitation warranties of merchantability, fitness for a particular purpose, title and non-infringement. Without limiting the generality of the foregoing, you acknowledge and agree that (a) the software application may exhibit errors, design flaws or other problems, possibly resulting in loss of data or damage to property; (b) it may not be possible to make the software application fully functional; and (c) Paul Technologies may, without notice or liability to you, cease to make available the current version and/or any future versions of the software application. In no event should the code be used to support of ultra-hazardous activities, including but not limited to life support or blasting activities.

Neither Paul Technologies nor its affiliates or agents will be liable, under breach of contract or any other theory of liability, for any damages whatsoever arising from use of the software application, including without limitation direct, special, incidental, punitive, consequential or other damages, even if advised of the possibility of such damages. You agree to indemnify and defend Andy Paul and Paul Technologies against any and all claims arising from your use, modification or distribution of the code.

USE AT YOUR OWN RISK.

32 Responses to XenAppAudit

  1. Bruc eNoe says:

    Yo dude. I want to test this for you. Also, link to my blog I started at the website above.

  2. michael says:

    Trying this on Xenapp 6.5. Not working. Keeps complaining about Unable to find Xenapp SDK. Xenapp SDK is required for the Xenapp Audit to run. It is infact installed though…

    • Andy Paul says:

      This was written against XA6, before XA6.5 was released, so the SDK path may be different. In the Launcher.vbs file, you can remove the logic or modify the path as necessary for the SDK. if line 56: filesys.fileExists(“C:\Program Files\Citrix\XenApp Server SDK\Citrix.XenApp.Sdk.ps1”) then… that is a reason I am giving this out unlocked, so anybody can modify it as necessary.

  3. MichaelEls says:

    Hello … Great Tool … like it already …
    I encountered a strange issue with a 4.5 R06 Farm … i start the Audit and after a quick moment it starts to complain “that it can not determine the XenApp Version” … what can this mean ? how to tiptoe around this ?

    Many many thanks in advance

    MichaelE

    • Andy Paul says:

      Thanks Michael. That note is where the Launcher.vbs cannot find the file wfshell.exe to pull the XenApp version from (starting in line 38). If your XenApp is installed in an alternate location (such as the D:) then this error could occur. A work around is to modify the vbs to the correct location of the wfshell.exe; or you can cheat by hard coding the ‘xenappver’ variable to be the version you want (4.5). Hope that helps!

      • Melanie says:

        Hi Andy,

        I am using the XA 6.5 as well but cannot find a way to modify your file. It only gives me an option to open it and not edit. Can you please help?

        • Andy Paul says:

          Melanie, thanks for using the tool. What are you trying to edit?
          The VBS and PS1 files can be opened/edited in Notepad if necessary.
          -Andy

  4. Tom says:

    Could really use this tool — is it ready yet??
    Thank you, Tom

  5. THANK YOU says:

    This is great. Keep up the great effort. Your free assistance is GREATLY appreciated!
    I will do my best to contribute back.

  6. Fred says:

    Hi Andy,
    This is a great tool and I would like to thank you for the sharing. I need your help because the utility doesn’t work: some reports doesn’t work or are empty (application per server). The name of the farm doesn’t appear in the front end access database.
    I saw that some data in the database were not present, such as the farm name, audit ID still at 0, etc…I’m trying to audit a presentation server 4.0 farm and read the results with access 2010 (french version). Thanks for your help !!!

    • Andy Paul says:

      Not all the data points get populated successfully on older versions of PS. Also, I am not sure if using the French version of Access will make any difference or not.
      If the AuditID is still at 0, it may be that it is not writing to the database at all. Look for the lock file while it is running. Also, under the Results folder are some logs which indicatate what is happening. Its possible the DB is not being accessed properly.

  7. JC says:

    Hi all,
    First, thank for tool !!! fantastic work.
    I only have a question, because when I passed all scripts, I have a problem with the first step in mdb file; when I try to export the files to excel, have a pop-up with error 94… and if not export the data, I can´t do nothing.
    If you could help me, would really fantastic. If you prefer, you can write me an email.

    Thank you very much.
    JC

    PD: I´m trying with XA 6.5

    • Andy Paul says:

      JC, did you get this working? I am not familiar with Error 94 off hand, but the apps should work and provide analysis, even without the Excel export.

  8. Andre Combrinck says:

    Andy! You are my new hero! I have been working on my own script over the years that I thought did what I want, but yours trump that completely. Many thanks for your hard work. I have already ran it and it is a great tool. Fantastic work!

  9. Hi there great blog! Doeѕ running a blog like this requirе a
    masѕive аmount woгk? I’ve no expertise in programming however I was hoping to start my own blog in the near future. Anyhow, should you have any suggestions or techniques for new blog owners please share. I know this is off subject nevertheless I simply had to ask. Appreciate it!

    • Andy Paul says:

      Shawn, blogs do not require a lot of work, but they do require time. You only get as much out of it as you put into it. The advice that was given to me, and that I pass along, is to write what is useful to you. If its useful to you, then it is probably useful to others. Regardless of topic. Good luck!

  10. Alain Assaf says:

    Paul,

    I’m very impressed with this tool. I ran it and was curious how you determined the information shown in the Client Builds table in the Session Summary Report. I’ve been trying to identify non-windows ICA clients for some time, so which script is gathering this info? Knowing the Windows CE and HP clients is huge for me.

    Thanks,
    Alain

    • Andy Paul says:

      Alain, sorry for the late reply. The script pulled the client version using the MFCOM library for connected sessions. I then compare the version number to a table I built called “tblBuilds” That way, as new client builds are released, you can add to the table. you can also see some of this from here: http://support.citrix.com/article/CTX112613

      Thanks,
      Andy

  11. mike says:

    Any idea when you will have time to finish the Farm Settings within the Reporting Utility to include the Load Evaluator, Xenapp Policy Report, and Farm Settings Report? This utility is amazing!

  12. mike says:

    Paul, Just wondering why you keep taking down my post about the latest version of your software? Happened twice now without any response. Looking for the final version that includes the Xenapp policies and other farm settigns that were not finalized in this version of the utility. It is in fact the best audit tool that i have seen thus far! Great job!

    • Andy Paul says:

      Thanks Mike! I was not taking down your old posts, I just haven’t logged in awhile and had not approved any comments. I have all set to require approval to keep the SPAM down. Sorry about that. I am working on 2.0 now… a post on that will come shortly.

      Thanks for using the tool and the feedback. And thanks for your patience.
      -Andy

  13. Dax says:

    Some minor changes to allow running Xenappaudit data COLLECTION from any UNC path.

    Change start.bat to:

    @ECHO OFF
    cls
    ECHO — BEGINNING XEN APP AUDIT —
    ECHO ……………………………
    pushd “%~DP0”
    cscript /nologo launcher.vbs

    pushd Results
    set resultspath=%cd%
    popd
    pushd Scripts
    queryds.exe /table:LMS_ServerLoadTable > “%resultspath%\QueryDSResults.txt”
    popd
    ECHO ……………………………
    ECHO — XEN APP AUDIT COMPLETE! —

    Change launcher VBS launcher.vbs line below:

    Dim progpath : progpath=”C:\Program Files\XenAppAudit\”

    to

    Dim progpath : progpath=Replace(WScript.ScriptFullName,WScript.ScriptName,””)

    This does not affect data analisys.

  14. Faiss says:

    Great great work man!!
    Seriously this is awesome!! keep it up!

    /Faiss

  15. Fabian says:

    Mike:
    i was wondering if you could give me a hand, i transfered the files and executed them as the user guide states, when i click on import files, MS visual basic opens and gives me a compile error, what can be the cause of this?
    i really look forward to see what can i get from your farm

  16. mike says:

    Hi Paul. How is v2.0 coming? I am willing to beta test for you if you like.

    • Andy Paul says:

      He Mike, Sorry for the delayed response, I have recently switched companies and I am writing a book, so my time has been consumed with that.
      I have a new lab setup, so I hope to have 2.0 to include XenDesktop in a few months, but no guarantee.

  17. Ben says:

    Just want to add my comments to agree with everyone else – awesome tool. Thanks for sharing this. Like Mike has posted, it would be great to know when v2.0 is going to be released, I would love to be able to run all the reports.

    • Andy Paul says:

      Sorry for the delayed response, I have recently switched companies and I am writing a book, so my time has been consumed with that.
      I have a new lab setup, so I hope to have 2.0 to include XenDesktop in a few months, but no guarantee.

Leave a Reply

Your email address will not be published. Required fields are marked *