Microsoft FEP 2010 Data Warehouse Discovery

Microsoft.Fep2010.Monitoring.FepDataWarehouse.Discovery (Discovery)

This discovers the FEP 2010 Data Warehouse. Discovery is done by attempting to run a query against the FEP 2010 Data Warehouse.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.Fep2010.Monitoring.FepDataWarehouse.Discovery" Enabled="true" Target="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer" ConfirmDelivery="false" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.Fep2010.Monitoring.FepDataWarehouse"/>

    <DiscoveryRelationship TypeID="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainerHostsFepDataWarehouse"/>

  </DiscoveryTypes>

  <DataSource ID="DbQuery" TypeID="Microsoft.Fep2010.Monitoring.DataSourceModule.TimedDiscoveryCheckDatabaseIsAccessibleProbe">

    <IntervalSeconds>14400</IntervalSeconds>

    <ConnectionString>Provider=SQLOLEDB;Server=$Target/Property[Type="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlServerConnectionString$;Database=$Target/Property[Type="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlDatabaseName$;Integrated Security=SSPI</ConnectionString>

    <Query>EXEC spAN_Health_GetJobHealthState 'FEP_GetNewData_$Target/Property[Type="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlDatabaseName$'</Query>

    <TimeoutSeconds>300</TimeoutSeconds>

    <ClassId>$MPElement[Name='Microsoft.Fep2010.Monitoring.FepDataWarehouse']$</ClassId>

    <InstanceSettings>

      <Settings>

        <Setting>

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

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

        </Setting>

        <Setting>

          <Name>$MPElement[Name="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlInstanceName$</Name>

          <Value>$Target/Property[Type="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlInstanceName$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlServerName$</Name>

          <Value>$Target/Property[Type="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlServerName$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlDatabaseName$</Name>

          <Value>$Target/Property[Type="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlDatabaseName$</Value>

        </Setting>

        <Setting>

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

          <Value>Microsoft FEP 2010 Data Warehouse - $Target/Host/Property[Type="Microsoft.Fep2010.Monitoring.FepDeployment"]/DeploymentSiteCode$</Value>

        </Setting>

      </Settings>

    </InstanceSettings>

    <Expression>

      <SimpleExpression>

        <ValueExpression>

          <XPathQuery Type="Boolean">Property[@Name='IsAccessible']</XPathQuery>

        </ValueExpression>

        <Operator>Equal</Operator>

        <ValueExpression>

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

        </ValueExpression>

      </SimpleExpression>

    </Expression>

  </DataSource>

</Discovery>