Data Hosting Resource Manager::QueryDatabasesByServer

This procedure returns a listing of all databases allocated in the resource pool to a particular server.

Arguments

Remarks

Sample Code

Example XML Request

<request>
  <procedure>
	<execute namespace="Data Hosting Resource Manager" procedure="QueryDatabasesByServer" impersonate="1">
	<executeData>
		<container>LDAP://CN=Computers,DC=fabrikam,DC=Com</container>
		<serverName>SQL01</serverName>
		<preferredDomainController>AD01-wh.fabrikam.com</preferredDomainController>
	</executeData>
	<after source="executeData" destination="data" mode="merge"/>
	</execute>
  </procedure>
</request>

Example XML Response

Output Parameters

<databases>/<database> node containing current allocation data, for example:

	<database>
		<databaseName>AlpineCustomer</databaseName>
		<megabytes>10</megabytes>
	</database>

Typical Response

(Shown for formatting only, content may not match)

<response>
  <data>
	<container>LDAP://CN=Computers,DC=fabrikam,DC=Com</container>
	<serverName>SQL01</serverName>
	<preferredDomainController>AD01-wh.fabrikam.com</preferredDomainController>
	<GUID>AFF7B1E1DF90A042BABA475A5D5E155D</GUID>
	<path>LDAP://CN=SQL01,CN=Computers,DC=fabrikam,DC=com</path>
	<databases>
	<database>
		<databaseName>AlpineCustomer</databaseName>
		<megabytes>10</megabytes>
	</database>
	 <database>
		<databaseName>AlpineSales</databaseName>
		<megabytes>10</megabytes>
	</database>
	<database>
		<databaseName>AlpineInventory</databaseName>
		<megabytes>10</megabytes>
	</database>
	 </databases>
  </data>
</response>

Applies To