MDW Appliance SQL Server Tables Discovery

Microsoft.SQLServerAppliance.MDW2.SQLServerTablesDiscovery (Discovery)

This object discovery detects the largest SQL Server tables across the user databases.

Knowledge Base article:

Summary

This object discovery detects the largest SQL Server tables across the user databases.

Element properties:

Target	Microsoft.SQLServerAppliance.MDW2.Server
Enabled	True
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServerAppliance.MDW2.Table

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServerAppliance.MDW2.SQLServerTablesDiscoveryDS	Default

Source Code:

<Discovery ID="Microsoft.SQLServerAppliance.MDW2.SQLServerTablesDiscovery" Enabled="true" Target="Microsoft.SQLServerAppliance.MDW2.Server" ConfirmDelivery="false" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServerAppliance.MDW2.Table"/>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServerAppliance.MDW2.SQLServerTablesDiscoveryDS">

    <TimeoutSeconds>300</TimeoutSeconds>

    <TablesCount>10</TablesCount>

    <TableMinSize>0</TableMinSize>

  </DataSource>

</Discovery>