Data Hosting Resource Manager::QueryDatabasesByOrganization

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

Arguments

Remarks

Sample Code

Example XML Request

<request>
  <procedure>
	<execute namespace="Data Hosting Resource Manager" procedure="QueryDatabasesByOrganization" impersonate="1">
	<executeData>
		<org>LDAP://OU=alpineskihouse,OU=consolidatedmessenger,OU=Hosting,DC=fabrikam,DC=Com</org>
		<preferredDomainController>AD01-wh.fabrikam.com</preferredDomainController>
	</executeData>
	<after source="executeData" destination="data" mode="merge"/>
	</execute>
  </procedure>
</request>

Example XML Response

Output Parameters

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

			<server>
		<GUID>6AD7B4A02DC5FA44AAD90005870EEB49</GUID>
		<path>LDAP://CN=SQL01,CN=Computers,DC=fabrikam,DC=com</path>
		<databases>
		<database>
			<databaseName>AlpineSales</databaseName>
			<megabytes>10</megabytes>
		</database>
		 <database>
			<databaseName>AlpineCustomer</databaseName>
			<megabytes>10</megabytes>
		</database>
	 </databases>
	</server>

Typical Response

<response>
  <data>
	<org>LDAP://OU=alpineskihouse,OU=consolidatedmessenger,OU=Hosting,DC=fabrikam,DC=Com</org>
	<preferredDomainController>AD01-wh.fabrikam.com</preferredDomainController>
	<GUID>48DD9AB9D94A6B4BBBA6C2F6B1E9BDFC</GUID>
	<servers>
	<server>
		<GUID>6AD7B4A02DC5FA44AAD90005870EEB49</GUID>
		<path>LDAP://CN=SQL01,CN=Computers,DC=fabrikam,DC=com</path>
		<databases>
		<database>
			<databaseName>AlpineSales</databaseName>
			<megabytes>10</megabytes>
		</database>
		 <database>
			<databaseName>AlpineCustomer</databaseName>
			<megabytes>10</megabytes>
		</database>
	 </databases>
	</server>
	<server>
		<GUID>AFF7B1E1DF90A042BABA475A5D5E155D</GUID>
		<path>LDAP://CN=SQL02,CN=Computers,DC=fabrikam,DC=com</path>
		<databases>
		<database>
			<databaseName>AlpineInventory</databaseName>
			<megabytes>10</megabytes>
		</database>
		</databases>
	</server>
	</servers>
  </data>
</response>

Applies To