SQL DM Discovery

Idera.SQLDM.DMservice.Discovery (Discovery)

This object discovers SQL DM installations by examining the registry of all managed Windows computers. When an instance is discovered, configuration data from the SQL DM registry area is gathered as properties of the discovered objects.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Idera.SQLDM.DMservice.Discovery" Enabled="true" Target="Windows!Microsoft.Windows.OperatingSystem" ConfirmDelivery="false" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Idera.SQLDM.DMservice"/>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Windows!Microsoft.Windows.FilteredRegistryDiscoveryProvider">

    <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

    <RegistryAttributeDefinitions>

      <RegistryAttributeDefinition>

        <AttributeName>DbRegValExists</AttributeName>

        <Path>Software\Idera\SQLdm\Database</Path>

        <PathType>1</PathType>

        <AttributeType>0</AttributeType>

      </RegistryAttributeDefinition>

      <RegistryAttributeDefinition>

        <AttributeName>Version</AttributeName>

        <Path>Software\Idera\SQLdm\Version</Path>

        <PathType>1</PathType>

        <AttributeType>1</AttributeType>

      </RegistryAttributeDefinition>

      <RegistryAttributeDefinition>

        <AttributeName>DmPath</AttributeName>

        <Path>Software\Idera\SQLdm\Path</Path>

        <PathType>1</PathType>

        <AttributeType>1</AttributeType>

      </RegistryAttributeDefinition>

      <RegistryAttributeDefinition>

        <AttributeName>DmDatabase</AttributeName>

        <Path>Software\Idera\SQLdm\Database</Path>

        <PathType>1</PathType>

        <AttributeType>1</AttributeType>

      </RegistryAttributeDefinition>

    </RegistryAttributeDefinitions>

    <Frequency>43200</Frequency>

    <ClassId>$MPElement[Name="Idera.SQLDM.DMservice"]$</ClassId>

    <InstanceSettings>

      <Settings>

        <Setting>

          <Name>$MPElement[Name="Windows!Microsoft.Windows.Computer"]/PrincipalName$</Name>

          <Value>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/DNSName$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="Idera.SQLDM.DMservice"]/Version$</Name>

          <Value>$Data/Values/Version$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="Idera.SQLDM.DMservice"]/DmPath$</Name>

          <Value>$Data/Values/DmPath$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="Idera.SQLDM.DMservice"]/DmDatabase$</Name>

          <Value>$Data/Values/DmDatabase$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="System!System.Entity"]/DisplayName$</Name>

          <Value>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</Value>

        </Setting>

      </Settings>

    </InstanceSettings>

    <Expression>

      <SimpleExpression>

        <ValueExpression>

          <XPathQuery Type="String">Values/DbRegValExists</XPathQuery>

        </ValueExpression>

        <Operator>Equal</Operator>

        <ValueExpression>

          <Value Type="String">true</Value>

        </ValueExpression>

      </SimpleExpression>

    </Expression>

  </DataSource>

</Discovery>