Seed Data Source

Microsoft.SQLServer.2016.ReportingServices.DataSource.Seed (DataSourceModuleType)

Microsoft SQL Server 2016 Reporting Services Seed Data Source

Element properties:

Member Modules:

Overrideable Parameters:

Source Code:

<DataSourceModuleType ID="Microsoft.SQLServer.2016.ReportingServices.DataSource.Seed" Accessibility="Internal">

  <Configuration>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="PrincipalName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Frequency" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SyncTime" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="TimeoutSeconds" type="xsd:integer"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="Frequency" ParameterType="int" Selector="$Config/Frequency$"/>

    <OverrideableParameter ID="SyncTime" ParameterType="string" Selector="$Config/SyncTime$"/>

    <OverrideableParameter ID="TimeoutSeconds" ParameterType="int" Selector="$Config/TimeoutSeconds$"/>

  </OverrideableParameters>

  <ModuleImplementation>

    <Composite>

      <MemberModules>

        <DataSource ID="DS" TypeID="System!System.Discovery.Scheduler">

          <Scheduler>

            <SimpleReccuringSchedule>

              <Interval>$Config/Frequency$</Interval>

              <SyncTime>$Config/SyncTime$</SyncTime>

            </SimpleReccuringSchedule>

            <ExcludeDates/>

          </Scheduler>

        </DataSource>

        <ProbeAction ID="Script" TypeID="Windows!Microsoft.Windows.PowerShellDiscoveryProbe">

          <ScriptName>DiscoverRS2016Seed.ps1</ScriptName>

          <ScriptBody><Script>param($principalName, $MapElement, $TargetID)



$ErrorActionPreference = 'Stop'



$api = New-Object -ComObject "MOM.ScriptAPI"

$discoveryData = $api.CreateDiscoveryData(0, $MapElement, $TargetID)



$rsInstalled = Test-Path 'HKLM:SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\RS' -PathType Container -ErrorAction Stop

$sqlServer2016Installed = Test-Path 'HKLM:SOFTWARE\Microsoft\Microsoft SQL Server\130\Machines' -PathType Container -ErrorAction Stop



$rs32Installed = Test-Path 'HKLM:SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\Instance Names\RS' -PathType Container -ErrorAction Stop

$sqlServer201632Installed = Test-Path 'HKLM:SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\130\Machines' -PathType Container -ErrorAction Stop



if(!(($rsInstalled -and $sqlServer2016Installed) -or ($rs32Installed -and $sqlServer201632Installed))){

	$discoveryData

	exit

}



$computerNameData = Get-ItemProperty 'HKLM:\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters' -ErrorAction Stop

$discoveredName = $computerNameData.Hostname



if(![string]::IsNullOrEmpty($computerNameData.Domain)){

	$discoveredName = "$($computerNameData.Hostname).$($computerNameData.Domain)"

}



if($principalName -eq $discoveredName){

	$targetObj = $discoveryData.CreateClassInstance("$MPElement[Name='Microsoft.SQLServer.2016.ReportingServices.Seed']$")



	$targetObj.AddProperty("$MPElement[Name='Windows!Microsoft.Windows.Computer']/PrincipalName$", $principalName)

	$targetObj.AddProperty("$MPElement[Name='System!System.Entity']/DisplayName$", $principalName)

	

	$discoveryData.AddInstance($targetObj)

}



$discoveryData</Script></ScriptBody>

          <SnapIns/>

          <Parameters>

            <Parameter>

              <Name>MapElement</Name>

              <Value>$MPElement$</Value>

            </Parameter>

            <Parameter>

              <Name>TargetID</Name>

              <Value>$Target/Id$</Value>

            </Parameter>

            <Parameter>

              <Name>PrincipalName</Name>

              <Value>$Config/PrincipalName$</Value>

            </Parameter>

          </Parameters>

          <TimeoutSeconds>$Config/TimeoutSeconds$</TimeoutSeconds>

          <StrictErrorHandling>true</StrictErrorHandling>

        </ProbeAction>

      </MemberModules>

      <Composition>

        <Node ID="Script">

          <Node ID="DS"/>

        </Node>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <OutputType>System!System.Discovery.Data</OutputType>

</DataSourceModuleType>