Data Hosting Resource Manager::QueryAllServers

This procedure returns a listing of all SQL Servers in the resource pool with capacity data.

Arguments

Remarks

Sample Code

Example XML Request

<request>
  <procedure>
	<execute namespace="Data Hosting Resource Manager" procedure="QueryAllServers"
	impersonate="1">
	<executeData>
		<preferredDomainController>AD01.fabrikam.com</preferredDomainController>
	</executeData>
	<after source="executeData" destination="data" mode="merge" />
	</execute>
  </procedure>
</request>

Example XML Response

Output Parameters

<servers>/<server> node containing current capacity data, for example:

	<server provisionable="1">
		<serverName>SQL01</serverName>
		<GUID>15CD15983A7C0C459697ECF33469B84C</GUID>
		<path>LDAP://CN=SQL01,CN=Computers,DC=fabrikam,DC=com</path>
		<megabytes>1000</megabytes>
		<megabytesFree>1000</megabytesFree>
		<maxDatabases>200</maxDatabases>
		<databasesFree>200</databasesFree>
		<warningPercentage>80</warningPercentage>
		<shared>1</shared>
		<serverClassName>SQLServerBasic</serverClassName>
	</server>

Typical Response

(Shown for formatting only, content may not match)

<response>
  <data>
	<preferredDomainController>AD01-wh.fabrikam.com</preferredDomainController>
	<servers>
	<server provisionable="1">
		<serverName>SQL01</serverName>
		<GUID>15CD15983A7C0C459697ECF33469B84C</GUID>
		<path>LDAP://CN=SQL01,CN=Computers,DC=fabrikam,DC=com</path>
		<megabytes>1000</megabytes>
		<megabytesFree>1000</megabytesFree>
		<maxDatabases>200</maxDatabases>
		<databasesFree>200</databasesFree>
		<warningPercentage>80</warningPercentage>
		<shared>1</shared>
		<serverClassName>SQLServerBasic</serverClassName>
	</server>
	<server provisionable="1">
		<serverName>SQL02</serverName>
		<GUID>6AD7B4A02DC5FA44AAD90005870EEB49</GUID>
		<path>LDAP://CN=SQL02,CN=Computers,DC=fabrikam,DC=com</path>
		<megabytes>1000</megabytes>
		<megabytesFree>990</megabytesFree>
		<maxDatabases>200</maxDatabases>
		<databasesFree>199</databasesFree>
		<warningPercentage>80</warningPercentage>
		<shared>1</shared>
		<serverClassName>SQLServerBasic</serverClassName>
	</server>
	<server provisionable="1">
		<serverName>SQL03</serverName>
		<GUID>ABD38CF0BC2785439AA23B035B43E1B7</GUID>
		<path>LDAP://CN=SQL03,CN=Computers,DC=fabrikam,DC=com</path>
		<megabytes>10000</megabytes>
		<megabytesFree>10000</megabytesFree>
		<maxDatabases>400</maxDatabases>
		<databasesFree>400</databasesFree>
		<warningPercentage>80</warningPercentage>
		<shared>1</shared>
		<serverClassName>SQLServerProfessional</serverClassName>
	</server>
	<server provisionable="1">
		<serverName>SQL04</serverName>
		<GUID>AFF7B1E1DF90A042BABA475A5D5E155D</GUID>
		<path>LDAP://CN=SQL04,CN=Computers,DC=fabrikam,DC=com</path>
		<megabytes>20000</megabytes>
		<megabytesFree>20000</megabytesFree>
		<maxDatabases>600</maxDatabases>
		<databasesFree>600</databasesFree>
		<warningPercentage>80</warningPercentage>
		<shared>1</shared>
		<serverClassName>SQLServerPremium</serverClassName>
	</server>
	</servers>
  </data>
</response>

Applies To