Have you ever looked in the XenApp / XenDesktop monitoring database using SQL Server Management Studio or a simple SQL query? If not, you might be surprised how much data in this DB stored, which is not exposed in Director.
So if you are looking for historical records or information to certain trends that you can not see the Director web interface, you can easily create a custom report.
that sounds complicated, as you would need to Guru SQL scripting are, it is actually quite simple and can be achieved with the help of Excel.
So always just a matter of getting more insight into XenApp / XenDesktop environment data from the DB and convert it into a human readable format. In this blog post I'd like you to guide through setting an Excel workbook that does exactly this.
To the workflow to illustrate
We will create a report that outlines the versions of the receiver used to connect the site. So if you follow the steps listed below, you should end up with something like this:
Please note that the monitoring DB access causes Excel to read a This amount of data. means that you will see Excel significant CPU and RAM resources consume, and you might have some overhead on the broker and on the SQL server. So before in your shop with this, give it to understand its impact a shot in the test environment.
1. Open a blank Excel workbook
2. Select Data -> From Other Sources -> From OData Data Feed
3. Connect Excel on your monitoring DB API by following data input URI http: // {} NameOFYourBroker / Citrix / monitor / OData / v2 / data in the "link or file" field ( please ... / specify OData / V1 / data for 7.5 and earlier), an account with Admin permissions in the XA / XD site and click Next:
4. Select the ports table and click Next: make
5. Give it a name and click Finish:
6. Select PivotTable report and click OK. (If you select Table instead, you will receive it imports all contents of the connection table to the Excel spreadsheet. This image can be beautiful than what is stored in the monitoring database.)
7. on the right side of the Excel window in the PivotTable fields menu with the right mouse button on the client version and choose Add lables on line: 
8. right-click the client and select Add to values ;. (Column now B to be filled with a lot of numbers This number indicates how many times an HDX connection was established using a special version of Citrix Receiver But it is important to understand that. Each connection is counted. So when a user three times are we connecting three sessions count).
9. In order to clean up the list, and make sure that each customer only counted once, click Count of client in the field values and select Value Field Settings: 
10. Scroll to the bottom of the list, select Distinct Count and click OK:
11
12: you should like to see this a list similar. To see which clients have connected using a particular version, select the version, click the little magnifying glass icon, choose Client and click Drill Client:
13 . now you should see a list of each client.
Just this list always with relatively few clicks (I know that should be accessible from director directly, but that's another discussion) is pretty cool. But there are still a few things we can do to improve it.
Timeline
So far, we use all available data in the monitoring database. If you are a Platinum customer, this means we are looking at data from the last 365 days. Usually a lot of things will happen in a year, so we could use the time frame we are looking to want to restrict. This is very easy to reach
- Click on the table we just created, select Analyze within the PivotTable Tools and click Insert Timeline .:
- Select BrokeringDate and click OK:
- now you should have a selection window, to look like :. just choose the months or periods you want and the list of recipients versions look, should change in real time
PivotChart
to the list of recipients versions a bit easier to read, we can add a PivotChart.
- Select analyzing within the PivotTable Tools and click PivotChart:
- Select the chart that you prefer (I personally prefer the donut chart) and click OK:
- No, you should see something like this:
receiver version dropdown
using the pivot table drill-down feature is ok, but there is an even simpler way to access the list of clients with a particular version of the receiver. This requires that we create another pivot table that can use the same data connection, and can be placed on the same Excel sheet. To this blog I will be as short as possible not to add screenshot for steps that we already covered
- select data and click Existing Connections .:
- Select the OData connection that we have previously created and click OK.
- Select PivotTable Report and click OK.
- on client right-click and choose Add Labels series.
- Right click on client version and choose Add Filter to report
Now you should see something .:
- In order to filter for a specific version of the receiver, click the drop-down box with All highlighted and select the version you are looking for.
- in case you would like to add the timeline feature and this pivot table, right-click the timeline and select Report Relationship.
- Select both pivot tables and click OK:
This is it. Now you should have a dashboard that you. With a detailed coverage of the receiver versions and provides an easy way, using which customers a specific version receiver to find out
In this blog we have only used data from a single table of the monitoring DB, but there is much more data available. So, if you think there are other reports urgently needed, please call to leave a comment below, and I will some how-tos time permits post
Some reference material:
- eDocs. - Monitor Service OData API
- eDocs - Service API Monitoring
- Blog - XenDesktop 7 Monitor Service - What data is available
- Blog - Creating Director Custom Reports for monitoring XenDesktop with LinqPad
-Thomas
Follow me on Twitter @ tberger80.
0 Komentar