Vmware View Pool Counts/Monitoring

[duhaas]

Anyone know where I can find this information that shows pool stats in the backend SQL tables:

Looking for a quick report I can put together to pull information for all pools to show me whats open vs not

[mikebarnett]

The pool stats actually come from the AD LDS database running on the View Connection Servers.

To pull that manually you would have to put together something that would read the structure of the pools/VMs and then parse out the status of the VMs from there.

-Mike

[duhaas]

know of a tool or scripting language that will get me access to the database

[mikebarnett · Accepted solution]

I know you can do it with VBScript. The following two links will hopefully get you started:

http://www.activexperts.com/network-monitor/windowsmanagement/scripts/otherds/adam/retrieving/

http://technet.microsoft.com/en-us/library/cc758446(v=ws.10).aspx

As long as the script is running as a local admin user on a Connection Server you should be able to bind to the server and run the queries necessary to get the info.

The relevant areas you will want to look are:

OU=Servers <-This contains a reference for each virtual desktop

OU-Server Groups <-This contains a reference for each pool

Under each desktop object you will want to look for the status attribute and the maintenance mode attribute to get more info.

The best way to get familiar with what you're looking for is to log into ADAM using ADSIedit and poke around the above areas. That way you can see which object you're looking at by using the pae-DisplayName attribute and compare the status it's in with what is displayed in the attributes for that object.

Hopefully this helps get you started!

-Mike