Home > View, Vmware > VMware View 4.5 real-time usage statistics

VMware View 4.5 real-time usage statistics

I was somewhat disappointed by the lack of usage information from View 4.5. Specifically that I had to login to the admin side of a connection server to find out how many machines were in use out of a given pool.

The data that View stores is in ADAM and in searching the net, I’ve not found a good way to query that data. What I’d like to do is have a webpage that shows how many desktops are in use or available for a given pool.

I had already started parsing the View Event database for historical statistics (users per day, average length of time logged on, busiest days etc) but nowhere in there was an easy method to just go “hey, there are 75 people on right now”

What I came up with (this may or may not work in your environment) was to put an AFTER INSERT  trigger on the viewevent table. The trigger either increments or decrements a counter in a table on a remote-linked server that is accessible to my web server.

At this point I am not looking at specific pools, only overall usage. There are a few event types in the log table that you can use and it all depends on which one you want to pick as the definitive “a user logged on” event for the trigger:

  • AGENT_CONNECTED
  • BROKER_DESKTOP_REQUEST
  • BROKER_USERLOGGEDIN

For me, the most obvious seemed to be to base counts on the BROKER_USERLOGGED -IN and -OUT event types. The issue with these is that in the record, neither the pool nor the desktop are listed. Only the userid of the person logging in and the name of the View Connection server. If you based your trigger on the “AGENT_CONNECTED” event type, you have the name of the user and the name of the responding desktop. If you use BROKER_DESKTOP_REQUEST then you have the name of the pool.

I didn’t want to make my trigger complex at this point so I am just getting an overall/aggregate usage for all pools.

Basically my trigger is as follows (note, I removed the linked server name and some other specific data, this code is NOT guaranteed to run as-is or at all):
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
--written by Paul Dunn
--(C) 2011
--will increment/decrement a counter for view usage based on event type
--in the viewevent table
--dunnsept@gmail.com
ALTER TRIGGER [test1]    ON  [dbo].[viewevent]  
  AFTER insert
AS
declare @etype as varchar(50),
@count as int
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.  
SET NOCOUNT ON;  
select @etype = [EventType] from inserted  
select @count = (select num from view_usage where poolid = 1)  
 if @etype = 'BROKER_USERLOGGEDIN'
 BEGIN   
update view_usage set num = (@COUNT + 1)
 END
 ELSE
  if @etype = 'BROKER_USERLOGGEDOUT'
  BEGIN  
 if @count> 0   
 BEGIN      
update view_usage set num = (@COUNT - 1)  
  END  
 END  
set NOCOUNT OFF;
END

Now all I have to do it query that value in the table and display it on the page. I have the tables setup so that I can track usage by pool, which makes more sense than all users, but this is a start at least. This should also help get others off my case as I run View 4.5 pools for 3 other departments besides my own and now I don’t have to give them access to the admin side for them to see the usage on their pools.

I am going to re-write this eventually so that it will be pool-based, shouldn’t be that big of a deal, just means using a different event type in the table and parsing out the name of the pool. Could even go so far as to grab the name of the logged in user, although at this point I don’t see much use for that.

Advertisements
Categories: View, Vmware
  1. Lance Hundt
    January 5, 2011 at 3:45 am

    Hey dunnsept,

    Good article, I’m trying to do the same thing but instead of using sql queries I’m looking at PowerShell cmdlets. I’m using “Get-RemoteSession | Group pool_id”

    I’m trying to get this out to a web page that I could check regularly to get a view of usage at different parts of the day. Anyways, I’m glad other folks are looking at this sort of stuff. Thanks!

  2. April 26, 2011 at 3:34 pm

    I’m also working on this and trying to get a better metrics about our view setup. wondering if you had any additional luck in this area. I’ll update this if find a way.

    • April 28, 2011 at 1:02 pm

      Chris: yea.. well,.. it works.. sorta. Part of the issue seems to be that there isn’t always the same disconnect transaction coming through. It would be much better if we could query the local LDAP directly for the data. I’m going to be taking the vmware view “bootcamp” class soon and plan on bugging the guy about it

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: