Web Interface for Resource Manager 1.2

Got Citrix Resource Manager? Try out Web Interface for Resource Manager! Web Interface for Resource Manager is an ASP.NET 2.0 web application that contains several SQL queries to display useful information contained in the Citrix Resource Manager Summary Database.

version 1.2

Got Citrix Resource Manager?  Try out Web Interface for Resource Manager!

Web Interface for Resource Manager is an ASP.NET 2.0 web application that contains several SQL queries to display useful information contained in the Citrix Resource Manager Summary Database.  Web Interface for Resource Manager displays this information in a drill-down graphical and tabular manner.

What’s new in version 1.2?
Web Interface for Resource Manager version 1.2 includes everything in version 1.1, plus the following new features: 

  • Client Usage Report. View every client version that has ever made a connection to your farm.  This report includes a date/time range filter.  You can also drill down to see which users have used particular client versions.
  • Application Report Filters. A date range filter has been added to the Application Report.  Also, the top number of applications is selectable from 1 – 10.  The combination of these two filters allows you to select the top x applications for any given date/time range. 

Web Interface for Resource Manager version 1.2 (for Presentation Server 3.0 and above)

Note: Version 1.2 is only intended for Presentation Server 3.0 and above. This is due to the differences in the Resource Manager Summary Database schema.  The MetaFrame XP Summary Database schema does not include the tables necessary to generate these new reports. Please use Web Interface for Resource Manager Version 1.1 for MetaFrame XP.

Screen Shots of Web Interface for Resource Manager

Usage Calendar (displays number of unique user sessions per day)

Click to enlarge

Bar Chart of sessions started on a particular day

Click to enlarge

Session Details

Click to enlarge

Application Usage

Click to enlarge

Client Usage Report

Click to enlarge

Known Issues

  • You may receive a message stating  Invalid object name ‘table if the owner of a table is anything other than dbo.
    Use the technique described here to change the object owner to dbo.

Please note that this project is a work in progress.  There are several other ideas that are in the works to add to the functionality of this web application.  If you have ideas for further functionality, please let me know in the comments section below.

Author: Jason Conger

Hey there. Hope you like the site.

117 thoughts on “Web Interface for Resource Manager 1.2”

  1. Were you able to fix this (from 1.1)

    Hello,

    When launching:

    http://rm/wirm/calendar.aspxclientUTCOffset=9.5

    I get a runtime error:
    (Note: I have remove the so I can post)

    !– Web.Config Configuration File —

    configuration
    system.web
    customErrors mode=”Off”
    system.web
    configuration

    And:

    !– Web.Config Configuration File —

    configuration
    system.web
    customErrors mode=”RemoteOnly” defaultRedirect=”mycustompage.htm”
    system.web
    configuration

    Fix:

    If I launch:
    http://rm/wirm/calendar.aspxclientUTCOffset=10
    It works!

    And if i launch:
    http://rm/wirm/calendar.aspxclientUTCOffset=9.5
    again, it works, no runtime error?

    Strange? What do you think?

    The IIS Server is in the +10 Time Zone. Client was in the +9.5 Time Zone.

    Thanks

  2. I have setup Web Interface for Resource Manager 1.2. Everything is working except Top 5 applications and Top five clients. Any ideas?

  3. I get the same thing, it’s the graph that is not showing. If you use the top x apps combo box the page appears to reload but the graph is still empty and there is no list of apps/clients as shown in the screenshots.

  4. Is this installed on each Citrix server??
    Is this installed somewhere else??
    Is .NET Framework 2.0 required??
    Etc. etc.

  5. I cannot reproduce this behavior. I have tested using IE6, IE7, and Firefox browsers. Could somebody please email at [email protected] with the following information:

    – Launch the applications or clients report
    – View the HTML page source
    – Email me everything between the <object> and </object> tags

    Thanks!

  6. Everything is working great for me except the client report. Everything is blank. There is the framework for the graph and info but nothing appears. It looks like an error message appears for a split second but too fast to read. The client information does appear in the session details. Thanks!

  7. Can you email me the source of the HTML page? Just right click on the page that is not showing the graph and select View Source. Then save the text as a text file and attach to an email.

    Thanks,
    Jason

  8. Hi Jason,

    I get the same error; both of the graphs show nothing.

    I just sent you an email with the source code you requested.

    Thanks,
    Julian

  9. First off, Awesome tool Jason!!

    Version 1.1 for both our XPe and PS4.0 farms are working great.

    However version 1.2 has the problem listed above: The graphs “Shell” shows up but doesn’t populate with any information. This is for top users and top apps, basically the new code in 1.2.

    Everything else in 1.2 is working fine, just the graphs are not displaying.

  10. After Configuring as per the docoment given in website folder.

    I am not able to reports.

    ————————————-
    localhost – /CTXRM/

    ——————————————————————————–

    [To Parent Directory] Wednesday, July 19, 2006 3:58 PM App_Code Wednesday, July 19, 2006 3:58 PM App_Data Wednesday, July 19, 2006 3:58 PM App_Themes Monday, July 17, 2006 7:31 AM 6070 applicationReport.aspx Monday, July 17, 2006 7:31 AM 16137 applicationReport.aspx.cs Wednesday, July 19, 2006 3:58 PM Bin Monday, July 17, 2006 7:31 AM 1815 calendar.aspx Monday, July 17, 2006 7:41 AM 8217 calendar.aspx.cs Wednesday, July 19, 2006 3:58 PM Charts Monday, July 17, 2006 7:32 AM 6928 clientReport.aspx Monday, July 17, 2006 7:32 AM 17354 clientReport.aspx.cs Monday, July 17, 2006 7:48 AM 3152 clientsByUser.aspx Monday, July 17, 2006 7:32 AM 2026 clientsByUser.aspx.cs Wednesday, July 19, 2006 3:58 PM clientScripts Monday, July 17, 2006 7:55 AM 2267 Copy of Web.Config Monday, July 17, 2006 7:32 AM 4235 datepicker.css Monday, July 17, 2006 7:32 AM 693 Default.aspx Monday, July 17, 2006 7:42 AM 4895 generateXMLChartData.aspx Monday, July 17, 2006 7:47 AM 2575 hourDetail.aspx Monday, July 17, 2006 7:43 AM 3230 hourDetail.aspx.cs Monday, July 17, 2006 7:32 AM 1183 hourlyBarchart.aspx Monday, July 17, 2006 7:32 AM 1285 hourlyBarchart.aspx.cs Wednesday, July 19, 2006 3:58 PM images Monday, July 17, 2006 7:32 AM 1843 Layout.master Monday, July 17, 2006 7:32 AM 760 Layout.master.cs Monday, July 17, 2006 7:49 AM 9032 sessionDetail.aspx Monday, July 17, 2006 7:32 AM 5193 sessionDetail.aspx.cs Monday, July 17, 2006 7:32 AM 814 style.css Monday, July 17, 2006 7:49 AM 2489 UserReport.aspx Monday, July 17, 2006 7:32 AM 2174 UserReport.aspx.cs Monday, July 17, 2006 7:49 AM 2335 userSessions.aspx Monday, July 17, 2006 7:32 AM 1804 userSessions.aspx.cs Wednesday, July 19, 2006 4:05 PM 2099 Web.Config

  11. We have Default.aspx listed as a default document on your IIS server but still having the same problem.

    Everything else in 1.2 is working fine, just the graphs are not displaying.

    Thanks

  12. Right now my rmsummarydb is updated at Midnight everynight. How much of a burden (aka user impact) is created if i update that frequency to be like 6 hours?

  13. I agree. The current reports are excellent but I think adding some server specific reports (eg line graphs showing %CPU utilisation, memory used, concurrent users) similar to the graphs in the CMC would be awesome. Maybe a version 1.3 enhancement 🙂

  14. After changing owner of all the tables to dbo, everything is working fine.

    It is a very nice Tool!!!

    Thanks Jason.

  15. The tables are not owned by DBO, but my Connection String for SQL is using the DB Owner accout for RM.

    Guess I need to change ownership to DBO ?

  16. Jason,

    I have to tell you…this is just great! You need to put up a “Donate Now” Paypal link or something. This thing is so great I “want” to give you money. Thanks for doing this!

    J.

  17. Perhaps in the future you could add “Max Concurrent Connections” per server and per application as a view. Being able to filter out sessions that were connected for less than a “specified duration” would be nice too (i.e. A client connects for 3 seconds can be filtered out). The ability to “Print” reports or save them as a “PDF” would be great.

    Keep up the good work.

    S.

  18. I am glad you are finding value in this product. I did not write this product in hopes of getting compensated for it. I am just trying to give back to a community that has given me so much.

  19. Awesome app!!!! It would be great to export entire table to Excel, not just one screen at a time, is this possible? Thanks

  20. At least for SQLServer Express the setting for language should be “Language=English” and not “Language=US_English”.
    I use a german version of SQLServer Express with german language settings.

    Andreas

  21. Hi. This app seems to be so cool but I’m running Oracle as summary Database and I’m unable to link the web.config to the tnsname.org defined DB reference. What did you do ?

  22. I’d be interested in seeing some graphs or reports listing the users that have accessed a certain server and what application was used.

  23. Do you have any examples of how you would connect to an Oracle DB? I am using ODBC and would be very grateful if you could provide any information.

  24. oh wow, the new version is as cool as the old one. i really love this tool. thx to jason for this perfect work.
    greetz
    otto (austria)

  25. Took a while to get work due to Win2003 IIS restrictions and SQL connection strings but top, top job.
    Thanks very much.
    Iain(UK)

  26. hi , just downloaded and think (?) i’ve followed the instructions….. can’t seem to open the default.aspx file , i’ve confirmed the correct locations by putting a test.html file in the same location , but when i try and launch default.aspx i get an error suggesting :- the page cannot be found ….

    any help / advice would be appreciated

  27. I’ve tried everything to make it working with Oracle. No luck. The app has been designed to work only with SQLsrv…

  28. Hi. Looking forward to connect to an Oracle Sum DB too.
    Does anyone manage to specify the good directive in web.config xml file ? If so, can u please post it ?

  29. hi ,

    thanks for the advice , i hadn’t enabled within the web service extensions, once i enabled asp.net it worked fine !

  30. Agree, great work. But unfortunately I’m in a 9.5 timezone and it reports on the integer value of 9. Any chnace it can report on .5 timezones correctly. Thanks.

  31. Hi, Can Web Interface RM 1.2 handle 1000+ applications for reporting??
    Because we are having 1100+ application

  32. Hi Jason,

    I get this error after leaving the page open in my browser for over 10 mins. It happens when I click the usuage calendar link. Browsing to the root of the site fixes this..

    Thanks
    Andrew

    Server Error in ‘/’ Application.
    ——————————————————————————–

    Runtime Error
    Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

    Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a “web.config” configuration file located in the root directory of the current web application. This tag should then have its “mode” attribute set to “Off”.

    Notes: The current error page you are seeing can be replaced by a custom error page by modifying the “defaultRedirect” attribute of the application’s configuration tag to point to a custom error page URL.

  33. Thanks for this. This appears to be a session timeout issue. The application stores the local workstation’s UTC offset in a session variable so dates and times can be displayed in the correct time zone. I will get this fixed!

  34. My database is not rmsummarydb b/c I have more than one farm. Does this matter? I’ve updated the web.config, but can’t get the page to load. “the page cannot be found”

    Thanks

  35. Hi Jason,

    Have you found the problem with this? You are correct I have GMT +10 set…

    Cheers
    Andrew

  36. In your Web.config file, add <sessionState timeout=”x” /> directly after <system.web> (where x equals the number of minutes you want the session to live). If this is not added to the Web.Config, the session will time out after 20 minutes.

  37. Is there any way to to send the page to a timed out type of page (like what WI does), or even make the usage calendar link point to the root of the web site?

  38. Can the connect string use Windows Authentication? I’m not having any luck getting it to work. I keep getting logon failed for … and I know the user name and password are correct. Below is my connect string, am I doing something wrong?

  39. ok my connect string didn’t show up for some reason, here it is again..

    add name=”rmsummarydbConnectionString” connectionString=”Data Source=sqlserver\instance,1397;Initial Catalog=rmsummarydb;User ID=domain\user; Password=pass” providerName=”System.Data.SqlClient”

  40. Just replace rmsummarydb in the connection string found in Web.Config with the name or your database. Just make sure the name of the connection string remains rmsummarydbConnectionString.

  41. Has anyone had any problems implementing this using an RM db that is on an SQL 2005 server? Just to try it out, I loaded up a 2003 server with SQL 2005, created an RM db and pointed some app servers to it. I then loaded IIS on the same server, and followed the WI4RM to a tee. I keep on getting a “Exception from HRESULT: 0x800736B1”. Has anyone else seen this issue?

  42. in the Web.Config (or another file) allow the owner of the tables to be specified as a variable?

    If it is set, you use that in all table lookups (like %SUMDB_Owner%.SDB_SessionID) rather than just assuming DBO has to own everything. If it is not set, you can then assume dbo owns everything.

    Just a suggestion.

  43. When running this WebApp in FIPS mode I recieved this error.

    Runtime Error
    Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

    Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a “web.config” configuration file located in the root directory of the current web application. This tag should then have its “mode” attribute set to “Off”.

    Notes: The current error page you are seeing can be replaced by a custom error page by modifying the “defaultRedirect” attribute of the application’s configuration tag to point to a custom error page URL.

    We have to run our server with FIPS turned on. It works fine when we disable FIPS. Can anyone help.

  44. This goes with the above POST.

    !– Web.Config Configuration File —

    configuration
    system.web
    customErrors mode=”Off”
    system.web
    configuration

    And:

    !– Web.Config Configuration File —

    configuration
    system.web
    customErrors mode=”RemoteOnly” defaultRedirect=”mycustompage.htm”
    system.web
    configuration

  45. Dude, the tool is sweet. Been using for over a month. Management loves it. I was just at a CTX user group in JAX, FL (first ever) and made sure all SE’s knew of your app. Great work and thanks!

  46. Usage Calendar and Applications works great!

    Windows 2003, SQL 2005 & PS 4.0

    The Usres and Client reports are blank.

    Not sure why?

  47. Jason nice job with the app, I just have 2 questions is there any way around the dbo owner for clients?. My account has read only.

    The 2nd question in the web config file I have the username and password. My Security department would go nuts if they seen the password in the config file is there any way around where you are prompted for the username and password?

    Thanks jason

  48. Here is what I do:

    1) Open SQL Enterprise Manager
    2) Go to Security -> Logins
    3) Create a new Login
    4) Specify the name of an AD group for the login (Domain Users for example).
    5) Set the default database from the drop down list
    6) Select the Database Access tab
    7) Select your RM Summary DB
    8) Select db_datareader as a role for this group
    9) Modify your Web.Config file to use Integrated Security (does not require a username and password)

    This way, any user in the group specified will be able to read the database. The web application will use the user’s windows credentials to access the database.

    You do not have to assign the db_owner role to anybody; just make sure dbo owns the RM DB tables.

  49. Jason the account I use does have db_owner on all tables in the RM except for the SQL System tables.
    This however still does not work.

    Here is the next stupid thing how do you add integrated security to the config file? yes I am a dumbass 🙂

  50. What I mean when I say “make sure dbo owns the tables” is this:

    Open SQL Enterprise Manager and browse to your RM database. In the left pane, select the “Tables” node of you RM database. In the right hand pane, a list of all the RM tables will appear. Make sure dbo is listed in the “Owner” column for each table.

    Next, in Web.Config there should be an example Integrated Security connection string. If not, use this as an example:

    <add name=”rmsummarydbConnectionString” connectionString=”Data Source=server;Initial Catalog=rmsummarydb;Integrated Security=True;Language=US_English” providerName=”System.Data.SqlClient”/>

  51. Jason thanks for the above info. I noticed under the clients option the word frequency. Like for Version 9 of the client it says something like 20000 for frequency what do you mean by that and the same goes for applications?

    For the future it be nice to see the machine name(client machine name and IP a user connected by. It would aslo be nice to get server reports like uptime.

    It would also be nice to have the max concurrent usage per server and per farm. It would also be nice to have a drop down list where you could select an published app and see the max usage for that app over a particular time concurrently.

    This is very good work and makes citrix effort look for poor indeed.

  52. Frequency refers to the number of times an application has been launched, or the number of times a particular client has connected to your farm. Also, drilling down to session details does show the client machine name and IP.

    I am currently working on version 2.0 of Web Interface for Resource Manager. Getting concurrent statistics is not an easy task, but I plan on including concurrent statistics in version 2.0. Thanks for your great suggestions!

  53. Hello, dbo account is not owner on my RM database and I can’t that?. I resolved the problem by deleting all the cases “rmsummary.dbo.” then all the cases “dbo.” in the following 3 files “clientsByUser.aspx”, “ApplicationsDataSet.xsd” and “ClientDataSet.xsd”
    Clément.

  54. jason when is the planned release of version 2 I am really looking forward to seen it. Or do you have any planned beta release?

  55. I’ve spent pretty much a whole day trying to get this to work with an Oracle 9i database. The client and the rest of my Oracle config should be right, and I think my connect string is right too. Might there be another change required in the code to reference the oracle provider maybe?

    I’d really like to make this work. I will investigate more tomorrow I think.

    Jason, any clues? Is there a sql provider hard-coded in somewhere?

  56. Jason,

    I notice that when the Calendar is fist opened that the “Users: XXXX” for each day looks to represent the actual number of users for that day. When you filter by applications it appears what is reported is the number of application launches in that day not the number of users that ran that filtered application. For example: If I had 20 users that logged in on Sept 1st and during a 8 hour period 18 users open and closed Outlook two times, when I open the reporting tool it will report 20 users for Sept 1st and when filtered by App for Outlook it would report 36…causing some confusion.

    Would it be possible to build in a “Reconcile” option for those of us who don’t need to know how many times a application is launched in a 24 hour period but would rather have a solid count of the actual users who used a application regardless of how many times?

    For example: On Sept 1st during a 8 hour period I had 20 users logged in and 18 users opened and closed Outlook 2 times. Open the tool and filter by Application and check a “reconcile” box and it would report “20 total users for Sept 1st 18 of which ran Outlook”.

    J.

  57. When I click on a paticular client version in the client report page, I am prompted for authentication, and no matter what user I enter i recieve “Error message 401.3.” I am running IIS6 with anonymous access and integrated windows. I have tried just anonymous and just integrated with same result. IUSR has full control to web directory. Any suggestions?

  58. Thanks.
    This is an awesome product. It would be great if I could view stats on a per server basis. Are you planning to add that type of functionality?

  59. Any idea why running top x Applications works OK for 1-6 but 7+ I get an error “An error occured while processing the data. Please refresh the page. If the error persists, please contact the webmaster”

    I have change the owner to DBO etc and it all works nicely except for this part. Changing the graph type maked no difference.

    Changing the date range to one month reduces the error point to 4. Could it be corrupt data in thr DB??

  60. I can’t seem to change the ownership of the tables that begin with LU_ and SDB_. I ran the script from the SQLTeam website, and I get the confirmation that the ownership on those tables have changed. But when I look at the tables they are still owned by my sqlconnect account. Does anyone know of a manual way of doing this? Thanks.

    Bob

  61. First, great product. Can’t wait for new version.
    The only issue I’m having is that the Applications and Clients chart are not showing any data. The DBO owner is dbo I ave checked this. Any thing else I can look at? Jason thanks for creating this.

  62. Love the version 2.0 but I am seeing the following issue, the server cpu statistics don’t agree with the canned reports from report center in access console, nor do they agree with the cpu results from the vm console. the discrepancy that we are seeing is that there are some cpu spikes in the graph which don’t show up with the other tools
    thks

  63. Hi Jason…the app rocks!
    quick question though the calendar show extremely high session info for our environme nt. we usually hve 100+ concurrent users, but the calendar stats show 1400+ sessions per day. Also when I drill down into the session chart I can’t correlate those numbers to the calendar. Any help is greatly appreciated

    Thanks Larz

  64. First off.. very nice.
    One thing I have noticed though all my application mem usage reports in GB when I know it isn’t. Has anyone else noticed this?

    Allistar

  65. Citrix stores this statistical data as a sum of an average for the lifetime of the session. So, this data may look quite large for sessions that were logged on for longer periods of time.

  66. hi, have been using this product for months , no problems at all until now, don’t have any info after 16th march 2007 , checked the citrix summary database logs and sql and it looks ok , can’t quite understand why it stopped on 16th march ? , any advice , pointers would be appreciated

  67. Jason, nice tool, I’d like to use it, but cannot get it to display data through a Named Instance connection. Any pointers?

  68. Hi, The WIRM works fine, except not showing any graphs – all tables and RM DB is owned by DBO……PLEASE HELP ASAP……thanks.

  69. Hi I have a sql db for our Citrix summary DB using SQL authentication. This works through ODBC however I cannot connect through the web configuration screen.

  70. Sorry I get the message “An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under The default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)” we use 2000 sql servers allow remote connections is enabled. And I can run reports through citrix reporting ?

  71. Hello Jason,

    Just had a question about the reporting aspect of your app. Would it be possile to spit out a report for say, all apps used for the whole day? Currently, we can go into Usage Calendar and bring up the day’s sessions, but we then have to click on each hour to see who logged into what, at what time. Is there a way to get the day’s info without having to click through hour by hour?

    Also, under Applications->Concurrrent Usage, is there a way to have the pie chart display Application usage with regards to time, rather than just sessions? I guess I’m really just asking if your app’s functionality can be expanded to report based on a different set.

    Thanks very much Jason.

Leave a Reply

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