Microsoft Azure SQL Database Federations Discovery

Microsoft.SqlServer.Azure.Discovery.Federations (Discovery)

This workflow discovers federations hosted in Microsoft Azure SQL Database Cloud Server.

Knowledge Base article:

Summary

This workflow discovers federations hosted in Microsoft Azure SQL Database Cloud Server.

Overrideable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	No
Interval (seconds)	The recurring interval of time in seconds in which to run the workflow.	14400
Synchronization Time	The synchronization time specified by using a 24-hour format. May be omitted.
Timeout (seconds)	Specifies the time the workflow is allowed to run before being closed and marked as failed.	600

Element properties:

Target	Microsoft.SqlServer.Azure.UserDatabase
Enabled	False
Frequency	14400
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SqlServer.Azure.Federation FederationId FederationRoot Microsoft.SqlServer.Azure.FederationMember MemberId LowerBound UpperBound ServerName DatabaseId DatabaseName MaxSize

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SqlServer.Azure.Module.BaseScriptedDiscoveryDataSource	Default

Source Code:

<Discovery ID="Microsoft.SqlServer.Azure.Discovery.Federations" Target="Microsoft.SqlServer.Azure.UserDatabase" Enabled="false" ConfirmDelivery="false" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SqlServer.Azure.Federation">

      <Property TypeID="Microsoft.SqlServer.Azure.Federation" PropertyID="FederationId"/>

      <Property TypeID="Microsoft.SqlServer.Azure.Federation" PropertyID="FederationRoot"/>

    </DiscoveryClass>

    <DiscoveryClass TypeID="Microsoft.SqlServer.Azure.FederationMember">

      <Property TypeID="Microsoft.SqlServer.Azure.FederationMember" PropertyID="MemberId"/>

      <Property TypeID="Microsoft.SqlServer.Azure.FederationMember" PropertyID="LowerBound"/>

      <Property TypeID="Microsoft.SqlServer.Azure.FederationMember" PropertyID="UpperBound"/>

      <Property TypeID="Microsoft.SqlServer.Azure.Database" PropertyID="ServerName"/>

      <Property TypeID="Microsoft.SqlServer.Azure.Database" PropertyID="DatabaseId"/>

      <Property TypeID="Microsoft.SqlServer.Azure.Database" PropertyID="DatabaseName"/>

      <Property TypeID="Microsoft.SqlServer.Azure.Database" PropertyID="MaxSize"/>

    </DiscoveryClass>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SqlServer.Azure.Module.BaseScriptedDiscoveryDataSource">

    <IntervalSeconds>14400</IntervalSeconds>

    <SyncTime/>

    <TimeoutSeconds>600</TimeoutSeconds>

    <DiscoveryName>FederationsDiscovery</DiscoveryName>

    <Script/>

    <Parameters>

      <Parameter>

        <Name>ServerName</Name>

        <Value>$Target/Host/Property[Type="Microsoft.SqlServer.Azure.Server"]/ServerName$</Value>

      </Parameter>

      <Parameter>

        <Name>RootDatabaseName</Name>

        <Value>$Target/Property[Type="Microsoft.SqlServer.Azure.Database"]/DatabaseName$</Value>

      </Parameter>

      <Parameter>

        <Name>Username</Name>

        <Value>$RunAs[Name="Microsoft.SqlServer.Azure.Profile.Sql"]/UserName$</Value>

      </Parameter>

      <Parameter>

        <Name>Password</Name>

        <Value>$RunAs[Name="Microsoft.SqlServer.Azure.Profile.Sql"]/Password$</Value>

      </Parameter>

    </Parameters>

  </DataSource>

</Discovery>