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
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
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
know of a tool or scripting language that will get me access to the database
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