DHCP Server Configuration Report

Microsoft.Windows.DHCPServer.Library.ServerConfiguration.Report (Report)

Element properties:

Source Code:

<Report ID="Microsoft.Windows.DHCPServer.Library.ServerConfiguration.Report" Accessibility="Public" Target="Microsoft.Windows.DHCPServer.Library.Server" Visible="true">

  <Dependencies>

    <ReportParameterControl>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.TextBox</ReportParameterControl>

  </Dependencies>

  <Definition>

    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

      <DataSources>

        <DataSource Name="DataWarehouseMain">

          <rd:DataSourceID>b76332ac-4c3a-426e-97a0-d762b2fe5623</rd:DataSourceID>

          <DataSourceReference>Data Warehouse Main</DataSourceReference>

        </DataSource>

      </DataSources>

      <InteractiveHeight>11in</InteractiveHeight>

      <ReportParameters>

        <ReportParameter Name="FilterOption">

          <DataType>Integer</DataType>

          <DefaultValue>

            <Values>

              <Value>=0</Value>

            </Values>

          </DefaultValue>

          <Prompt>Filter Option</Prompt>

          <ValidValues>

            <ParameterValues>

              <ParameterValue>

                <Value>0</Value>

                <Label>All</Label>

              </ParameterValue>

              <ParameterValue>

                <Value>1</Value>

                <Label>Only DHCP 2003</Label>

              </ParameterValue>

              <ParameterValue>

                <Value>2</Value>

                <Label>Only DHCP 2008</Label>

              </ParameterValue>

            </ParameterValues>

          </ValidValues>

        </ReportParameter>

        <ReportParameter Name="ServerName">

          <DataType>String</DataType>

          <Prompt>[Server Name]</Prompt>

          <ValidValues>

            <DataSetReference>

              <DataSetName>ObjectList</DataSetName>

              <ValueField>Name</ValueField>

              <LabelField>Name</LabelField>

            </DataSetReference>

          </ValidValues>

        </ReportParameter>

      </ReportParameters>

      <rd:DrawGrid>true</rd:DrawGrid>

      <InteractiveWidth>8.5in</InteractiveWidth>

      <rd:SnapToGrid>true</rd:SnapToGrid>

      <RightMargin>1in</RightMargin>

      <LeftMargin>1in</LeftMargin>

      <BottomMargin>1in</BottomMargin>

      <rd:ReportID>8cbc7d36-2f23-4bee-9af1-af081d2e8e51</rd:ReportID>

      <DataSets>

        <DataSet Name="ObjectList">

          <Fields>

            <Field Name="ManagedEntityRowId">

              <DataField>ManagedEntityRowId</DataField>

              <rd:TypeName>System.Int32</rd:TypeName>

            </Field>

            <Field Name="Name">

              <DataField>Name</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

          </Fields>

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <CommandText>

                    Select Distinct	MPR.ManagedEntityRowId, MgEn.Name

                    From ManagedEntity MgEn (NoLock)

                    Inner Join vManagedEntityPropertySet MPR (NoLock)

                    On MPR.ManagedEntityRowId = MgEn.ManagedEntityRowId

                    Inner Join vManagedEntityTypeProperty  PrNm (NoLock)

                    On MPR.PropertyGUID = PrNm.PropertyGUID

                    WHERE

                    (

                    (

                    @FilterOption = 0 And

                    MPR.ManagedEntityRowId In

                    (

                    select distinct MPR.ManagedEntityRowId

                    From vManagedEntityPropertySet MPR (NoLock)

                    Inner Join vManagedEntityTypeProperty  PrNm (NoLock)

                    On MPR.PropertyGUID = PrNm.PropertyGUID

                    where MPR.ManagedEntityRowId

                    in

                    (

                    select	ME.ManagedEntityRowId

                    from ManagedEntity ME (NoLock)

                    where ME.ManagedEntityTypeRowId in

                    (

                    select MT.ManagedEntityTypeRowId

                    from vManagedEntityType MT (NoLock)

                    where MT.managementpackrowid

                    in (

                    select MP.managementpackrowid

                    from vManagementPack MP (NoLock)

                    where

                    (

                    MP.managementPackSystemName in ('Microsoft.Windows.DHCPServer.Library')

                    )

                    )

                    And ManagedEntityTypeSystemName in ('Microsoft.Windows.DHCPServer.Library.Server')

                    )

                    )

                    And MPR.ToDateTime is null

                    )

                    ) Or

                    (

                    @FilterOption = 1 And

                    MPR.ManagedEntityRowId In

                    (

                    select distinct MPR.ManagedEntityRowId

                    From vManagedEntityPropertySet MPR (NoLock)

                    Inner Join vManagedEntityTypeProperty  PrNm (NoLock)

                    On MPR.PropertyGUID = PrNm.PropertyGUID

                    where MPR.ManagedEntityRowId

                    in

                    (

                    select	ME.ManagedEntityRowId

                    from ManagedEntity ME (NoLock)

                    where ME.ManagedEntityTypeRowId in

                    (

                    select MT.ManagedEntityTypeRowId

                    from vManagedEntityType MT (NoLock)

                    where MT.managementpackrowid

                    in (

                    select MP.managementpackrowid

                    from vManagementPack MP (NoLock)

                    where

                    (

                    MP.managementPackSystemName in ('Microsoft.Windows.DHCPServer.Library')

                    )

                    )

                    And ManagedEntityTypeSystemName in ('Microsoft.Windows.DHCPServer.Library.Server')

                    )

                    )

                    And MPR.ToDateTime is null

                    )

                    AND MPR.ManagedEntityRowId not in

                    (

                    (

                    select distinct MPR.ManagedEntityRowId

                    From vManagedEntityPropertySet MPR (NoLock)

                    Inner Join vManagedEntityTypeProperty  PrNm (NoLock)

                    On	MPR.PropertyGUID = PrNm.PropertyGUID

                    Inner Join vManagedEntityType MET (NoLock)

                    On  MET.ManagedEntityTypeRowId = PrNm.ManagedEntityTypeRowId

                    where MET.ManagedEntityTypeRowId

                    in

                    (

                    select MT.ManagedEntityTypeRowId

                    from vManagedEntityType MT (NoLock)

                    where MT.managementpackrowid

                    in (

                    select MP.managementpackrowid

                    from vManagementPack MP (NoLock)

                    where

                    (

                    MP.managementPackSystemName in ('Microsoft.Windows.DHCPServer.2008')

                    )

                    )

                    And ManagedEntityTypeSystemName in ('Microsoft.Windows.DHCPServer.2008.Server')

                    )

                    And MPR.ToDateTime is null

                    )

                    )

                    ) Or

                    (

                    @FilterOption = 2 And

                    MPR.ManagedEntityRowId In

                    (

                    select distinct MPR.ManagedEntityRowId

                    From vManagedEntityPropertySet MPR (NoLock)

                    Inner Join vManagedEntityTypeProperty  PrNm (NoLock)

                    On	MPR.PropertyGUID = PrNm.PropertyGUID

                    Inner Join vManagedEntityType MET (NoLock)

                    On  MET.ManagedEntityTypeRowId = PrNm.ManagedEntityTypeRowId

                    where MET.ManagedEntityTypeRowId

                    in

                    (

                    select MT.ManagedEntityTypeRowId

                    from vManagedEntityType MT (NoLock)

                    where MT.managementpackrowid

                    in (

                    select MP.managementpackrowid

                    from vManagementPack MP (NoLock)

                    where

                    (

                    MP.managementPackSystemName in ('Microsoft.Windows.DHCPServer.2008')

                    )

                    )

                    And ManagedEntityTypeSystemName in ('Microsoft.Windows.DHCPServer.2008.Server')

                    )

                    And MPR.ToDateTime is null



                    )

                    )



                    )

                  </CommandText>

            <QueryParameters>

              <QueryParameter Name="@FilterOption">

                <Value>=Parameters!FilterOption.Value</Value>

              </QueryParameter>

            </QueryParameters>

            <rd:UseGenericDesigner>true</rd:UseGenericDesigner>

          </Query>

        </DataSet>

        <DataSet Name="ServerDetails">

          <Fields>

            <Field Name="PropertyDefaultName">

              <DataField>PropertyDefaultName</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

            <Field Name="PropertyValue">

              <DataField>PropertyValue</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

          </Fields>

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <CommandText>

                    Select Distinct	PrNm.PropertyDefaultName,

                    MPR.PropertyValue

                    from  vManagedEntityPropertySet MPR (NoLock)

                    Inner Join vManagedEntityTypeProperty as PrNm (NoLock)

                    On MPR.PropertyGUID = PrNm.PropertyGUID

                    where MPR.ManagedEntityRowId

                    in (select	ME.ManagedEntityRowId

                    from ManagedEntity ME (NoLock)

                    where ME.ManagedEntityTypeRowId in

                    (select MT.ManagedEntityTypeRowId

                    from vManagedEntityType MT (NoLock)

                    where MT.managementpackrowid

                    in (select MP.managementpackrowid

                    from vManagementPack MP (NoLock)

                    where MP.managementPackSystemName

                    in ('Microsoft.Windows.DHCPServer.Library')

                    and ManagedEntityTypeSystemName in ('Microsoft.Windows.DHCPServer.Library.Server'))

                    and ME.Name = @ServerName))

                    And PrNm.PropertyDefaultName != 'Name'

                    And PrNm.PropertyDefaultName != 'Principal Name'

                    and MPR.ToDateTime is null

                  </CommandText>

            <QueryParameters>

              <QueryParameter Name="@ServerName">

                <Value>=Parameters!ServerName.Value</Value>

              </QueryParameter>

            </QueryParameters>

            <rd:UseGenericDesigner>true</rd:UseGenericDesigner>

          </Query>

        </DataSet>

        <DataSet Name="DatabaseDetails">

          <Fields>

            <Field Name="PropertyDefaultName">

              <DataField>PropertyDefaultName</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

            <Field Name="PropertyValue">

              <DataField>PropertyValue</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

          </Fields>

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <CommandText>

                    Select	distinct PrNm.PropertyDefaultName,

                    MPR.PropertyValue

                    from  vManagedEntityPropertySet MPR (NoLock)

                    Inner Join vManagedEntityTypeProperty as PrNm (NoLock)

                    On MPR.PropertyGUID = PrNm.PropertyGUID

                    Inner Join (

                    select RL.RelationShipRowId,

                    RL.SourceManagedEntityRowId,

                    RL.TargetManagedEntityRowId

                    From vrelationship RL (NoLock)

                    where RL.RelationshipTypeRowId in

                    (

                    select RLTP.RelationshipTypeRowId

                    From dbo.vRelationshipType RLTP (NoLock)

                    where RLTP.RelationshipTypeSystemName = 'Microsoft.Windows.DHCPServer.Library.Hosts.ServerHostsDHCPComponent'

                    )

                    And RL.SourceManagedEntityRowId in

                    (

                    select MgEn.ManagedEntityRowId

                    from ManagedEntity MgEn (NoLock)

                    where MgEn.ManagedEntityTypeRowId in

                    (

                    select EnTp.ManagedEntityTypeRowId

                    From vManagedEntityType EnTp (NoLock)

                    where EnTp.ManagedEntityTypeDefaultName = 'Microsoft.Windows.DHCPServer.Library.Server'

                    )

                    And MgEn.Name = @ServerName

                    )

                    And RL.TargetManagedEntityRowId in

                    (

                    select MgEn.ManagedEntityRowId

                    from ManagedEntity MgEn (NoLock)

                    where MgEn.ManagedEntityTypeRowId in

                    (

                    select EnTp.ManagedEntityTypeRowId

                    From vManagedEntityType EnTp (NoLock)

                    where EnTp.ManagedEntityTypeDefaultName = 'Microsoft.Windows.DHCPServer.Library.Database'

                    )

                    )

                    ) as Rel

                    On  MPR.ManagedEntityRowId = Rel.TargetManagedEntityRowId

                    And PrNm.PropertyDefaultName != 'Name'

                    And PrNm.PropertyDefaultName != 'Principal Name'

                    And MPR.ToDateTime is null

                  </CommandText>

            <QueryParameters>

              <QueryParameter Name="@ServerName">

                <Value>=Parameters!ServerName.Value</Value>

              </QueryParameter>

            </QueryParameters>

            <rd:UseGenericDesigner>true</rd:UseGenericDesigner>

          </Query>

        </DataSet>

        <DataSet Name="IPv4RuntimeDetails">

          <Fields>

            <Field Name="PropertyDefaultName">

              <DataField>PropertyDefaultName</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

            <Field Name="PropertyValue">

              <DataField>PropertyValue</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

          </Fields>

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <CommandText>

                    Select	distinct PrNm.PropertyDefaultName,

                    MPR.PropertyValue

                    from  vManagedEntityPropertySet MPR (NoLock)

                    Inner Join vManagedEntityTypeProperty as PrNm (NoLock)

                    On MPR.PropertyGUID = PrNm.PropertyGUID

                    Inner Join (

                    select RL.RelationShipRowId,

                    RL.SourceManagedEntityRowId,

                    RL.TargetManagedEntityRowId

                    From vrelationship RL (NoLock)

                    where RL.RelationshipTypeRowId in

                    (

                    select RLTP.RelationshipTypeRowId

                    From dbo.vRelationshipType RLTP (NoLock)

                    where RLTP.RelationshipTypeSystemName = 'Microsoft.Windows.DHCPServer.Library.Hosts.ServerHostsDHCPComponent'

                    )

                    And RL.SourceManagedEntityRowId in

                    (

                    select MgEn.ManagedEntityRowId

                    from ManagedEntity MgEn (NoLock)

                    where MgEn.ManagedEntityTypeRowId in

                    (

                    select EnTp.ManagedEntityTypeRowId

                    From vManagedEntityType EnTp (NoLock)

                    where EnTp.ManagedEntityTypeDefaultName = 'Microsoft.Windows.DHCPServer.Library.Server'

                    )

                    And MgEn.Name = @ServerName

                    )

                    And RL.TargetManagedEntityRowId in

                    (

                    select MgEn.ManagedEntityRowId

                    from ManagedEntity MgEn (NoLock)

                    where MgEn.ManagedEntityTypeRowId in

                    (

                    select EnTp.ManagedEntityTypeRowId

                    From vManagedEntityType EnTp (NoLock)

                    where EnTp.ManagedEntityTypeDefaultName = 'Microsoft.Windows.DHCPServer.Library.IPv4Runtime'

                    )

                    )

                    ) as Rel

                    On  MPR.ManagedEntityRowId = Rel.TargetManagedEntityRowId

                    And PrNm.PropertyDefaultName != 'Name'

                    And PrNm.PropertyDefaultName != 'Principal Name'

                    And MPR.ToDateTime is null

                  </CommandText>

            <QueryParameters>

              <QueryParameter Name="@ServerName">

                <Value>=Parameters!ServerName.Value</Value>

              </QueryParameter>

            </QueryParameters>

            <rd:UseGenericDesigner>true</rd:UseGenericDesigner>

          </Query>

        </DataSet>

        <DataSet Name="SuperscopeDetails">

          <Fields>

            <Field Name="ManagedEntityRowId">

              <DataField>ManagedEntityRowId</DataField>

              <rd:TypeName>System.Int32</rd:TypeName>

            </Field>

            <Field Name="PropertyDefaultName">

              <DataField>PropertyDefaultName</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

            <Field Name="PropertyValue">

              <DataField>PropertyValue</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

          </Fields>

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <CommandText>

                    Select	distinct MPR.ManagedEntityRowId,

                    PrNm.PropertyDefaultName,

                    MPR.PropertyValue

                    from  vManagedEntityPropertySet MPR (NoLock)

                    Inner Join vManagedEntityTypeProperty as PrNm (NoLock)

                    On MPR.PropertyGUID = PrNm.PropertyGUID

                    Inner Join (

                    select RL.RelationShipRowId,

                    RL.SourceManagedEntityRowId,

                    RL.TargetManagedEntityRowId

                    From vrelationship RL (NoLock)

                    where RL.RelationshipTypeRowId in

                    (

                    select RLTP.RelationshipTypeRowId

                    From dbo.vRelationshipType RLTP (NoLock)

                    where RLTP.RelationshipTypeSystemName = 'Microsoft.Windows.DHCPServer.Library.Hosts.ServerHostsSuperscope'

                    )

                    And RL.SourceManagedEntityRowId in

                    (

                    select MgEn.ManagedEntityRowId

                    from ManagedEntity MgEn (NoLock)

                    where MgEn.ManagedEntityTypeRowId in

                    (

                    select EnTp.ManagedEntityTypeRowId

                    From vManagedEntityType EnTp (NoLock)

                    where EnTp.ManagedEntityTypeDefaultName = 'Microsoft.Windows.DHCPServer.Library.Server'

                    )

                    And MgEn.Name = @ServerName

                    )

                    And RL.TargetManagedEntityRowId in

                    (

                    select MgEn.ManagedEntityRowId

                    from ManagedEntity MgEn (NoLock)

                    where MgEn.ManagedEntityTypeRowId in

                    (

                    select EnTp.ManagedEntityTypeRowId

                    From vManagedEntityType EnTp (NoLock)

                    where EnTp.ManagedEntityTypeDefaultName = 'Microsoft.Windows.DHCPServer.Library.Superscope'

                    )

                    )

                    ) as Rel

                    On  MPR.ManagedEntityRowId = Rel.TargetManagedEntityRowId

                    And PrNm.PropertyDefaultName != 'Name'

                    And PrNm.PropertyDefaultName != 'Principal Name'

                    and MPR.ToDateTime is null

                  </CommandText>

            <QueryParameters>

              <QueryParameter Name="@ServerName">

                <Value>=Parameters!ServerName.Value</Value>

              </QueryParameter>

            </QueryParameters>

            <rd:UseGenericDesigner>true</rd:UseGenericDesigner>

          </Query>

        </DataSet>

        <DataSet Name="ScopeDetails">

          <Fields>

            <Field Name="ManagedEntityRowId">

              <DataField>ManagedEntityRowId</DataField>

              <rd:TypeName>System.Int32</rd:TypeName>

            </Field>

            <Field Name="PropertyDefaultName">

              <DataField>PropertyDefaultName</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

            <Field Name="PropertyValue">

              <DataField>PropertyValue</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

          </Fields>

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <CommandText>

                    Select	distinct MPR.ManagedEntityRowId,

                    PrNm.PropertyDefaultName,

                    MPR.PropertyValue

                    from  vManagedEntityPropertySet MPR (NoLock)

                    Inner Join vManagedEntityTypeProperty as PrNm (NoLock)

                    On MPR.PropertyGUID = PrNm.PropertyGUID

                    Inner Join (

                    select RL.RelationShipRowId,

                    RL.SourceManagedEntityRowId,

                    RL.TargetManagedEntityRowId

                    From vrelationship RL (NoLock)

                    where RL.RelationshipTypeRowId in

                    (

                    select RLTP.RelationshipTypeRowId

                    From dbo.vRelationshipType RLTP (NoLock)

                    where RLTP.RelationshipTypeSystemName = 'Microsoft.Windows.DHCPServer.Library.Hosts.ServerHostsDHCPComponent'

                    )

                    And RL.SourceManagedEntityRowId in

                    (

                    select MgEn.ManagedEntityRowId

                    from ManagedEntity MgEn (NoLock)

                    where MgEn.ManagedEntityTypeRowId in

                    (

                    select EnTp.ManagedEntityTypeRowId

                    From vManagedEntityType EnTp (NoLock)

                    where EnTp.ManagedEntityTypeDefaultName = 'Microsoft.Windows.DHCPServer.Library.Server'

                    )

                    And MgEn.Name = @ServerName

                    )

                    And RL.TargetManagedEntityRowId in

                    (

                    select MgEn.ManagedEntityRowId

                    from ManagedEntity MgEn (NoLock)

                    where MgEn.ManagedEntityTypeRowId in

                    (

                    select EnTp.ManagedEntityTypeRowId

                    From vManagedEntityType EnTp (NoLock)

                    where EnTp.ManagedEntityTypeDefaultName = 'Microsoft.Windows.DHCPServer.Library.IPv4Scope'

                    )

                    )

                    ) as Rel

                    On  MPR.ManagedEntityRowId = Rel.TargetManagedEntityRowId

                    And PrNm.PropertyDefaultName != 'Name'

                    And PrNm.PropertyDefaultName != 'Principal Name'

                    and MPR.ToDateTime is null

                    Union

                    Select	distinct MPR.ManagedEntityRowId,

                    PrNm.PropertyDefaultName,

                    MPR.PropertyValue

                    from  vManagedEntityPropertySet MPR (NoLock)

                    Inner Join vManagedEntityTypeProperty as PrNm (NoLock)

                    On MPR.PropertyGUID = PrNm.PropertyGUID

                    Inner Join (

                    select RL.RelationShipRowId,

                    RL.SourceManagedEntityRowId,

                    RL.TargetManagedEntityRowId

                    From vrelationship RL (NoLock)

                    where RL.RelationshipTypeRowId in

                    (

                    select RLTP.RelationshipTypeRowId

                    From dbo.vRelationshipType RLTP (NoLock)

                    where RLTP.RelationshipTypeSystemName = 'Microsoft.Windows.DHCPServer.Library.Hosts.ServerHostsDHCPComponent'

                    )

                    And RL.SourceManagedEntityRowId in

                    (

                    select MgEn.ManagedEntityRowId

                    from ManagedEntity MgEn (NoLock)

                    where MgEn.ManagedEntityTypeRowId in

                    (

                    select EnTp.ManagedEntityTypeRowId

                    From vManagedEntityType EnTp (NoLock)

                    where EnTp.ManagedEntityTypeDefaultName = 'Microsoft.Windows.DHCPServer.Library.Server'

                    )

                    And MgEn.Name = @ServerName

                    )

                    And RL.TargetManagedEntityRowId in

                    (

                    select MgEn.ManagedEntityRowId

                    from ManagedEntity MgEn (NoLock)

                    where MgEn.ManagedEntityTypeRowId in

                    (

                    select EnTp.ManagedEntityTypeRowId

                    From vManagedEntityType EnTp (NoLock)

                    where EnTp.ManagedEntityTypeDefaultName = 'Microsoft.Windows.DHCPServer.2008.IPv6Scope'

                    )

                    )

                    ) as Rel

                    On  MPR.ManagedEntityRowId = Rel.TargetManagedEntityRowId

                    And PrNm.PropertyDefaultName != 'Name'

                    And PrNm.PropertyDefaultName != 'Principal Name'

                    and MPR.ToDateTime is null

                  </CommandText>

            <QueryParameters>

              <QueryParameter Name="@ServerName">

                <Value>=Parameters!ServerName.Value</Value>

              </QueryParameter>

            </QueryParameters>

            <rd:UseGenericDesigner>true</rd:UseGenericDesigner>

          </Query>

        </DataSet>

        <DataSet Name="IPV6RuntimeDetails">

          <Fields>

            <Field Name="PropertyDefaultName">

              <DataField>PropertyDefaultName</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

            <Field Name="PropertyValue">

              <DataField>PropertyValue</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

          </Fields>

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <CommandText>

                    Select 'N/A'	As PropertyDefaultName,

                    'N/A'	As PropertyValue

                    Union

                    Select	distinct PrNm.PropertyDefaultName,

                    MPR.PropertyValue

                    from  vManagedEntityPropertySet MPR (NoLock)

                    Inner Join vManagedEntityTypeProperty as PrNm (NoLock)

                    On MPR.PropertyGUID = PrNm.PropertyGUID

                    Inner Join

                    (

                    select RL.RelationShipRowId,

                    RL.SourceManagedEntityRowId,

                    RL.TargetManagedEntityRowId

                    From vrelationship RL (NoLock)

                    where RL.RelationshipTypeRowId in

                    (

                    select RLTP.RelationshipTypeRowId

                    From dbo.vRelationshipType RLTP (NoLock)

                    where RLTP.RelationshipTypeSystemName = 'Microsoft.Windows.DHCPServer.Library.Hosts.ServerHostsDHCPComponent'

                    )

                    And RL.SourceManagedEntityRowId in

                    (

                    select MgEn.ManagedEntityRowId

                    from ManagedEntity MgEn (NoLock)

                    where MgEn.ManagedEntityTypeRowId in

                    (

                    select EnTp.ManagedEntityTypeRowId

                    From vManagedEntityType EnTp (NoLock)

                    where EnTp.ManagedEntityTypeDefaultName in ('Microsoft.Windows.DHCPServer.Library.Server','Microsoft.Windows.DHCPServer.2003.Server','Microsoft.Windows.DHCPServer.2008.Server')

                    )

                    And MgEn.Name = @ServerName

                    )

                    And RL.TargetManagedEntityRowId in

                    (

                    select MgEn.ManagedEntityRowId

                    from ManagedEntity MgEn (NoLock)

                    where MgEn.ManagedEntityTypeRowId in

                    (

                    select EnTp.ManagedEntityTypeRowId

                    From vManagedEntityType EnTp (NoLock)

                    where EnTp.ManagedEntityTypeDefaultName = 'Microsoft.Windows.DHCPServer.2008.IPv6Runtime'

                    )

                    )

                    ) as Rel

                    On  MPR.ManagedEntityRowId = Rel.TargetManagedEntityRowId

                    And PrNm.PropertyDefaultName != 'Name'

                    And PrNm.PropertyDefaultName != 'Principal Name'

                    And MPR.ToDateTime is null

                  </CommandText>

            <QueryParameters>

              <QueryParameter Name="@ServerName">

                <Value>=Parameters!ServerName.Value</Value>

              </QueryParameter>

            </QueryParameters>

            <rd:UseGenericDesigner>true</rd:UseGenericDesigner>

          </Query>

        </DataSet>

      </DataSets>

      <Code/>

      <Width>8.25in</Width>

      <Body><Script>

        <ReportItems>

          <Table Name="ScopesTable">

            <ZIndex>13</ZIndex>

            <DetailDataElementOutput>NoOutput</DetailDataElementOutput>

            <DataElementOutput>Output</DataElementOutput>

            <DataSetName>ScopeDetails</DataSetName>

            <Visibility>

              <Hidden>true</Hidden>

              <ToggleItem>ScopesSection</ToggleItem>

            </Visibility>

            <KeepTogether>true</KeepTogether>

            <DetailDataElementName>SuperScopes</DetailDataElementName>

            <Top>4.75in</Top>

            <TableGroups>

              <TableGroup>

                <Grouping Name="table1_Group1">

                  <Label>=Fields!PropertyDefaultName.Value</Label>

                  <GroupExpressions>

                    <GroupExpression>=Fields!ManagedEntityRowId.Value</GroupExpression>

                  </GroupExpressions>

                </Grouping>

                <Header>

                  <TableRows>

                    <TableRow>

                      <TableCells>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox15">

                              <Style></Style>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                              <ZIndex>3</ZIndex>

                              <CanGrow>true</CanGrow>

                              <Value>=Fields!PropertyValue.Value</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox16">

                              <Style></Style>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                              <ZIndex>2</ZIndex>

                              <CanGrow>true</CanGrow>

                              <Value/>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                      </TableCells>

                      <Height>0.25in</Height>

                    </TableRow>

                  </TableRows>

                </Header>

              </TableGroup>

            </TableGroups>

            <Width>8in</Width>

            <Details>

              <TableRows>

                <TableRow>

                  <Visibility>

                    <Hidden>true</Hidden>

                    <ToggleItem>textbox15</ToggleItem>

                  </Visibility>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox17">

                          <Visibility>

                            <Hidden>true</Hidden>

                            <ToggleItem>textbox15</ToggleItem>

                          </Visibility>

                          <CanShrink>true</CanShrink>

                          <Style></Style>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>1</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>=Fields!PropertyDefaultName.Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox18">

                          <Visibility>

                            <Hidden>true</Hidden>

                            <ToggleItem>textbox15</ToggleItem>

                          </Visibility>

                          <CanShrink>true</CanShrink>

                          <Style></Style>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <CanGrow>true</CanGrow>

                          <Value>=IIF(Fields!PropertyValue.Value="1","True",IIF(Fields!PropertyValue.Value="0","False",Fields!PropertyValue.Value))</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.25in</Height>

                </TableRow>

              </TableRows>

            </Details>

            <Style></Style>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>8pt</FontSize>

            </Style>

            <Header>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox25">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <Style></Style>

                            <Color>White</Color>

                            <BackgroundColor>Gray</BackgroundColor>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Center</TextAlign>

                            <VerticalAlign>Middle</VerticalAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>5</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>Property Name</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox26">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <Style></Style>

                            <Color>White</Color>

                            <BackgroundColor>Gray</BackgroundColor>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Center</TextAlign>

                            <VerticalAlign>Middle</VerticalAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>4</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>Property Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.2in</Height>

                </TableRow>

              </TableRows>

              <RepeatOnNewPage>true</RepeatOnNewPage>

            </Header>

            <TableColumns>

              <TableColumn>

                <Width>3.25in</Width>

              </TableColumn>

              <TableColumn>

                <Width>4.75in</Width>

              </TableColumn>

            </TableColumns>

            <DataElementName>SuperScopesTable</DataElementName>

            <Height>0.7in</Height>

            <Left>0.125in</Left>

          </Table>

          <Table Name="IPV6RuntimeTable">

            <ZIndex>12</ZIndex>

            <DetailDataElementOutput>NoOutput</DetailDataElementOutput>

            <DataElementOutput>Output</DataElementOutput>

            <DataSetName>IPV6RuntimeDetails</DataSetName>

            <Visibility>

              <Hidden>true</Hidden>

              <ToggleItem>IPV6Section</ToggleItem>

            </Visibility>

            <DetailDataElementName>IPv6Runtime</DetailDataElementName>

            <Top>6.75in</Top>

            <Width>8in</Width>

            <Details>

              <TableRows>

                <TableRow>

                  <Visibility>

                    <Hidden>=IIF(Fields!PropertyValue.Value = "N/A",True,False)</Hidden>

                  </Visibility>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox19">

                          <Style></Style>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>1</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>=Fields!PropertyDefaultName.Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox20">

                          <Style></Style>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <CanGrow>true</CanGrow>

                          <Value>=Fields!PropertyValue.Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.25in</Height>

                </TableRow>

              </TableRows>

            </Details>

            <Style></Style>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>8pt</FontSize>

            </Style>

            <Header>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox21">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <Style></Style>

                            <Color>White</Color>

                            <BackgroundColor>Gray</BackgroundColor>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Center</TextAlign>

                            <VerticalAlign>Middle</VerticalAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>3</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>Property Name</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox22">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <Style></Style>

                            <Color>White</Color>

                            <BackgroundColor>Gray</BackgroundColor>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Center</TextAlign>

                            <VerticalAlign>Middle</VerticalAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>2</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>Property Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.2in</Height>

                </TableRow>

              </TableRows>

              <RepeatOnNewPage>true</RepeatOnNewPage>

            </Header>

            <TableColumns>

              <TableColumn>

                <Width>3.25in</Width>

              </TableColumn>

              <TableColumn>

                <Width>4.75in</Width>

              </TableColumn>

            </TableColumns>

            <DataElementName>IPv6RuntimeTable</DataElementName>

            <Height>0.45in</Height>

            <Left>0.125in</Left>

          </Table>

          <Textbox Name="IPV6Section">

            <DataElementOutput>Output</DataElementOutput>

            <RepeatWith>IPV6RuntimeTable</RepeatWith>

            <Visibility>

              <Hidden>=IIF((Count(Fields!PropertyValue.Value, "IPV6RuntimeDetails") = 1),True,False)</Hidden>

            </Visibility>

            <Top>6.5in</Top>

            <Width>8in</Width>

            <Style></Style>

              <BorderStyle>

                <Default>Solid</Default>

                <Left>Solid</Left>

                <Right>Solid</Right>

                <Top>Solid</Top>

                <Bottom>Solid</Bottom>

              </BorderStyle>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>11pt</FontSize>

              <FontWeight>700</FontWeight>

              <TextAlign>Center</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <DataElementStyle>ElementNormal</DataElementStyle>

            <ZIndex>11</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>0.125in</Left>

            <DataElementName>Title</DataElementName>

            <Height>0.25in</Height>

            <Value>="IPv6 Runtime Details"</Value>

          </Textbox>

          <Textbox Name="ScopesSection">

            <DataElementOutput>Output</DataElementOutput>

            <Top>4.5in</Top>

            <Width>8in</Width>

            <Style></Style>

              <BorderStyle>

                <Default>Solid</Default>

                <Left>Solid</Left>

                <Right>Solid</Right>

                <Top>Solid</Top>

                <Bottom>Solid</Bottom>

              </BorderStyle>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>11pt</FontSize>

              <FontWeight>700</FontWeight>

              <TextAlign>Center</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <DataElementStyle>ElementNormal</DataElementStyle>

            <ZIndex>10</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>0.125in</Left>

            <DataElementName>Title</DataElementName>

            <Height>0.25in</Height>

            <Value>="Scopes Details"</Value>

          </Textbox>

          <Table Name="SuperScopesTable">

            <ZIndex>9</ZIndex>

            <DetailDataElementOutput>NoOutput</DetailDataElementOutput>

            <DataElementOutput>Output</DataElementOutput>

            <DataSetName>SuperscopeDetails</DataSetName>

            <Visibility>

              <Hidden>true</Hidden>

              <ToggleItem>SuperScopesSection</ToggleItem>

            </Visibility>

            <DetailDataElementName>SuperScopes</DetailDataElementName>

            <Top>3.625in</Top>

            <TableGroups>

              <TableGroup>

                <Grouping Name="SuperScopesTable_Group1">

                  <Label>=Fields!PropertyDefaultName.Value</Label>

                  <GroupExpressions>

                    <GroupExpression>=Fields!ManagedEntityRowId.Value</GroupExpression>

                  </GroupExpressions>

                </Grouping>

                <Header>

                  <TableRows>

                    <TableRow>

                      <TableCells>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox23">

                              <rd:DefaultName>textbox23</rd:DefaultName>

                              <Style></Style>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                              <ZIndex>3</ZIndex>

                              <CanGrow>true</CanGrow>

                              <Value>=Fields!PropertyValue.Value</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox24">

                              <rd:DefaultName>textbox24</rd:DefaultName>

                              <Style></Style>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                                <PaddingBottom>2pt</PaddingBottom>

                              </Style>

                              <ZIndex>2</ZIndex>

                              <CanGrow>true</CanGrow>

                              <Value/>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                      </TableCells>

                      <Height>0.25in</Height>

                    </TableRow>

                  </TableRows>

                </Header>

              </TableGroup>

            </TableGroups>

            <Width>8in</Width>

            <Details>

              <TableRows>

                <TableRow>

                  <Visibility>

                    <Hidden>true</Hidden>

                    <ToggleItem>textbox23</ToggleItem>

                  </Visibility>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox11">

                          <rd:DefaultName>textbox11</rd:DefaultName>

                          <Visibility>

                            <Hidden>true</Hidden>

                            <ToggleItem>textbox23</ToggleItem>

                          </Visibility>

                          <Style></Style>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>1</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>=Fields!PropertyDefaultName.Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox12">

                          <rd:DefaultName>textbox12</rd:DefaultName>

                          <Visibility>

                            <Hidden>true</Hidden>

                            <ToggleItem>textbox23</ToggleItem>

                          </Visibility>

                          <Style></Style>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <CanGrow>true</CanGrow>

                          <Value>=IIF(Fields!PropertyValue.Value="1","True",IIF(Fields!PropertyValue.Value="0","False",Fields!PropertyValue.Value))</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.25in</Height>

                </TableRow>

              </TableRows>

            </Details>

            <Style></Style>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>8pt</FontSize>

            </Style>

            <Header>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox13">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <Style></Style>

                            <Color>White</Color>

                            <BackgroundColor>Gray</BackgroundColor>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Center</TextAlign>

                            <VerticalAlign>Middle</VerticalAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>5</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>Property Name</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox14">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <Style></Style>

                            <Color>White</Color>

                            <BackgroundColor>Gray</BackgroundColor>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Center</TextAlign>

                            <VerticalAlign>Middle</VerticalAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>4</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>Property Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.2in</Height>

                </TableRow>

              </TableRows>

              <RepeatOnNewPage>true</RepeatOnNewPage>

            </Header>

            <TableColumns>

              <TableColumn>

                <Width>3.25in</Width>

              </TableColumn>

              <TableColumn>

                <Width>4.75in</Width>

              </TableColumn>

            </TableColumns>

            <DataElementName>SuperScopesTable</DataElementName>

            <Height>0.7in</Height>

            <Left>0.125in</Left>

          </Table>

          <Textbox Name="SuperScopesSection">

            <DataElementOutput>Output</DataElementOutput>

            <Top>3.375in</Top>

            <Width>8in</Width>

            <Style></Style>

              <BorderStyle>

                <Default>Solid</Default>

                <Left>Solid</Left>

                <Right>Solid</Right>

                <Top>Solid</Top>

                <Bottom>Solid</Bottom>

              </BorderStyle>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>11pt</FontSize>

              <FontWeight>700</FontWeight>

              <TextAlign>Center</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <DataElementStyle>ElementNormal</DataElementStyle>

            <ZIndex>8</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>0.125in</Left>

            <DataElementName>Title</DataElementName>

            <Height>0.25in</Height>

            <Value>="SuperScopes Details"</Value>

          </Textbox>

          <Table Name="IPv4RuntimeTable">

            <ZIndex>7</ZIndex>

            <DetailDataElementOutput>NoOutput</DetailDataElementOutput>

            <DataElementOutput>Output</DataElementOutput>

            <DataSetName>IPv4RuntimeDetails</DataSetName>

            <Visibility>

              <Hidden>true</Hidden>

              <ToggleItem>IPv4RuntimeSection</ToggleItem>

            </Visibility>

            <DetailDataElementName>IPv4Runtime</DetailDataElementName>

            <Top>5.875in</Top>

            <Width>8in</Width>

            <Details>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox1">

                          <Style></Style>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>1</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>=Fields!PropertyDefaultName.Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox8">

                          <Style></Style>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <CanGrow>true</CanGrow>

                          <Value>=IIF(Fields!PropertyValue.Value="1","True",IIF(Fields!PropertyValue.Value="0","False",Fields!PropertyValue.Value))</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.25in</Height>

                </TableRow>

              </TableRows>

            </Details>

            <Style></Style>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>8pt</FontSize>

            </Style>

            <Header>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox9">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <Style></Style>

                            <Color>White</Color>

                            <BackgroundColor>Gray</BackgroundColor>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Center</TextAlign>

                            <VerticalAlign>Middle</VerticalAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>3</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>Property Name</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox10">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <Style></Style>

                            <Color>White</Color>

                            <BackgroundColor>Gray</BackgroundColor>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Center</TextAlign>

                            <VerticalAlign>Middle</VerticalAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>2</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>Property Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.2in</Height>

                </TableRow>

              </TableRows>

              <RepeatOnNewPage>true</RepeatOnNewPage>

            </Header>

            <TableColumns>

              <TableColumn>

                <Width>3.25in</Width>

              </TableColumn>

              <TableColumn>

                <Width>4.75in</Width>

              </TableColumn>

            </TableColumns>

            <DataElementName>IPv4RuntimeTable</DataElementName>

            <Height>0.45in</Height>

            <Left>0.125in</Left>

          </Table>

          <Textbox Name="IPv4RuntimeSection">

            <DataElementOutput>Output</DataElementOutput>

            <Top>5.625in</Top>

            <Width>8in</Width>

            <Style></Style>

              <BorderStyle>

                <Default>Solid</Default>

                <Left>Solid</Left>

                <Right>Solid</Right>

                <Top>Solid</Top>

                <Bottom>Solid</Bottom>

              </BorderStyle>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>11pt</FontSize>

              <FontWeight>700</FontWeight>

              <TextAlign>Center</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <DataElementStyle>ElementNormal</DataElementStyle>

            <ZIndex>6</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>0.125in</Left>

            <DataElementName>Title</DataElementName>

            <Height>0.25in</Height>

            <Value>="IPv4 Runtime Details"</Value>

          </Textbox>

          <Table Name="Database">

            <ZIndex>5</ZIndex>

            <DetailDataElementOutput>NoOutput</DetailDataElementOutput>

            <DataElementOutput>Output</DataElementOutput>

            <DataSetName>DatabaseDetails</DataSetName>

            <Visibility>

              <Hidden>true</Hidden>

              <ToggleItem>DatabaseSection</ToggleItem>

            </Visibility>

            <DetailDataElementName>Database</DetailDataElementName>

            <Top>2.75in</Top>

            <Width>8in</Width>

            <Details>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox4">

                          <Style></Style>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>1</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>=Fields!PropertyDefaultName.Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox5">

                          <Style></Style>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <CanGrow>true</CanGrow>

                          <Value>=IIF(Fields!PropertyValue.Value="1","True",IIF(Fields!PropertyValue.Value="0","False",Fields!PropertyValue.Value))</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.25in</Height>

                </TableRow>

              </TableRows>

            </Details>

            <Style></Style>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>8pt</FontSize>

            </Style>

            <Header>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox6">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <Style></Style>

                            <Color>White</Color>

                            <BackgroundColor>Gray</BackgroundColor>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Center</TextAlign>

                            <VerticalAlign>Middle</VerticalAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>3</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>Property Name</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox7">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <Style></Style>

                            <Color>White</Color>

                            <BackgroundColor>Gray</BackgroundColor>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Center</TextAlign>

                            <VerticalAlign>Middle</VerticalAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>2</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>Property Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.2in</Height>

                </TableRow>

              </TableRows>

              <RepeatOnNewPage>true</RepeatOnNewPage>

            </Header>

            <TableColumns>

              <TableColumn>

                <Width>3.25in</Width>

              </TableColumn>

              <TableColumn>

                <Width>4.75in</Width>

              </TableColumn>

            </TableColumns>

            <DataElementName>DatabaseTable</DataElementName>

            <Height>0.45in</Height>

            <Left>0.125in</Left>

          </Table>

          <Textbox Name="DatabaseSection">

            <DataElementOutput>Output</DataElementOutput>

            <Top>2.5in</Top>

            <Width>8in</Width>

            <Style></Style>

              <BorderStyle>

                <Default>Solid</Default>

                <Left>Solid</Left>

                <Right>Solid</Right>

                <Top>Solid</Top>

                <Bottom>Solid</Bottom>

              </BorderStyle>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>11pt</FontSize>

              <FontWeight>700</FontWeight>

              <TextAlign>Center</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <DataElementStyle>ElementNormal</DataElementStyle>

            <ZIndex>4</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>0.125in</Left>

            <DataElementName>Title</DataElementName>

            <Height>0.25in</Height>

            <Value>="Database Details"</Value>

          </Textbox>

          <Table Name="ServerTable">

            <ZIndex>3</ZIndex>

            <DetailDataElementOutput>NoOutput</DetailDataElementOutput>

            <DataElementOutput>Output</DataElementOutput>

            <DataSetName>ServerDetails</DataSetName>

            <Visibility>

              <Hidden>true</Hidden>

              <ToggleItem>ServerSection</ToggleItem>

            </Visibility>

            <DetailDataElementName>Server</DetailDataElementName>

            <Top>1.875in</Top>

            <Width>8in</Width>

            <Details>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox2">

                          <rd:DefaultName>textbox2</rd:DefaultName>

                          <Style></Style>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>1</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>=Fields!PropertyDefaultName.Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox3">

                          <rd:DefaultName>textbox3</rd:DefaultName>

                          <Style></Style>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <CanGrow>true</CanGrow>

                          <Value>=IIF(Fields!PropertyDefaultName.Value ="ConflictPingRetries", Fields!PropertyValue.Value, IIF(Fields!PropertyValue.Value="1","True",IIF(Fields!PropertyValue.Value="0","False",Fields!PropertyValue.Value)))</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.25in</Height>

                </TableRow>

              </TableRows>

            </Details>

            <Style></Style>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>8pt</FontSize>

            </Style>

            <Header>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox42">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <Style></Style>

                            <Color>White</Color>

                            <BackgroundColor>Gray</BackgroundColor>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Center</TextAlign>

                            <VerticalAlign>Middle</VerticalAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>3</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>Property Name</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox46">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <Style></Style>

                            <Color>White</Color>

                            <BackgroundColor>Gray</BackgroundColor>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <TextAlign>Center</TextAlign>

                            <VerticalAlign>Middle</VerticalAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                            <PaddingBottom>2pt</PaddingBottom>

                          </Style>

                          <ZIndex>2</ZIndex>

                          <CanGrow>true</CanGrow>

                          <Value>Property Value</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.2in</Height>

                </TableRow>

              </TableRows>

              <RepeatOnNewPage>true</RepeatOnNewPage>

            </Header>

            <TableColumns>

              <TableColumn>

                <Width>3.25in</Width>

              </TableColumn>

              <TableColumn>

                <Width>4.75in</Width>

              </TableColumn>

            </TableColumns>

            <DataElementName>ServerTable</DataElementName>

            <Height>0.45in</Height>

            <Left>0.125in</Left>

          </Table>

          <Textbox Name="ServerSection">

            <DataElementOutput>Output</DataElementOutput>

            <Top>1.625in</Top>

            <Width>8in</Width>

            <Style></Style>

              <BorderStyle>

                <Default>Solid</Default>

                <Left>Solid</Left>

                <Right>Solid</Right>

                <Top>Solid</Top>

                <Bottom>Solid</Bottom>

              </BorderStyle>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>11pt</FontSize>

              <FontWeight>700</FontWeight>

              <TextAlign>Center</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <DataElementStyle>ElementNormal</DataElementStyle>

            <ZIndex>2</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>0.125in</Left>

            <DataElementName>Title</DataElementName>

            <Height>0.25in</Height>

            <Value>="Server Details"</Value>

          </Textbox>

          <Image Name="banner_image">

            <Sizing>AutoSize</Sizing>

            <Top>0.125in</Top>

            <Width>8.05in</Width>

            <MIMEType/>

            <Source>External</Source>

            <Style/>

            <ZIndex>1</ZIndex>

            <Left>0.125in</Left>

            <Height>0.53958in</Height>

            <Value>../banner_portrait.jpg</Value>

          </Image>

          <Rectangle Name="rectangle4">

            <Left>0.125in</Left>

            <ReportItems>

              <Textbox Name="textbox28">

                <Top>0.375in</Top>

                <Width>3.625in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                  <PaddingBottom>2pt</PaddingBottom>

                </Style>

                <ZIndex>2</ZIndex>

                <CanGrow>true</CanGrow>

                <Left>4.25in</Left>

                <Height>0.25in</Height>

                <Value>="Report Date Time: " &amp; Globals!ExecutionTime</Value>

              </Textbox>

              <Textbox Name="textbox27">

                <rd:DefaultName>textbox27</rd:DefaultName>

                <Top>0.375in</Top>

                <Width>3.925in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                  <PaddingBottom>2pt</PaddingBottom>

                </Style>

                <ZIndex>1</ZIndex>

                <CanGrow>true</CanGrow>

                <Left>0.2in</Left>

                <Height>0.25in</Height>

                <Value>="Server Name: " &amp; Parameters!ServerName.Value</Value>

              </Textbox>

              <Textbox Name="reportTitle">

                <DataElementOutput>Output</DataElementOutput>

                <Top>0.05in</Top>

                <Width>7.675in</Width>

                <Style></Style>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>11pt</FontSize>

                  <FontWeight>700</FontWeight>

                  <TextAlign>Center</TextAlign>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                  <PaddingBottom>2pt</PaddingBottom>

                </Style>

                <DataElementStyle>ElementNormal</DataElementStyle>

                <CanGrow>true</CanGrow>

                <Left>0.2in</Left>

                <DataElementName>Title</DataElementName>

                <Height>0.25in</Height>

                <Value>="Microsoft Windows Server DHCP - Server Configuration Report"</Value>

              </Textbox>

            </ReportItems>

            <Top>0.75in</Top>

            <Width>8in</Width>

            <Style></Style>

              <BackgroundColor>Gainsboro</BackgroundColor>

            </Style>

            <Height>0.75in</Height>

          </Rectangle>

        </ReportItems>

        <Height>7.25in</Height>

      </Script></Body>

      <Language>en-US</Language>

      <PageFooter>

        <PrintOnFirstPage>true</PrintOnFirstPage>

        <ReportItems>

          <Textbox Name="textbox37">

            <Top>0.03125in</Top>

            <Width>7.9625in</Width>

            <Style></Style>

              <Color>DimGray</Color>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>8pt</FontSize>

              <TextAlign>Right</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <CanGrow>true</CanGrow>

            <Left>0.1625in</Left>

            <Height>0.1875in</Height>

            <Value>=Globals!ExecutionTime</Value>

          </Textbox>

        </ReportItems>

        <Height>0.375in</Height>

        <PrintOnLastPage>true</PrintOnLastPage>

      </PageFooter>

      <TopMargin>1in</TopMargin>

    </Report>

  </Definition>

</Report>