SQL Server Configuration

Microsoft.SQLServer.Linux.Views.Report.SQLServerConfiguration (LinkedReport)

SQL Server Configuration For Custom Configuration Report

Knowledge Base article:

Summary

How does this report work?

The SQL Server Configuration report displays these discovered properties:

Version
Language

The report finds data if the objects supplied are of type "MSSQL on Linux: DB Engine".

Search for objects with contains and the Instance name (e.g. “Instance 1”)

The report displays a matrix detailing all the found properties.

How to use this report?

When run from the Reporting space:

The second column in the search results shows of which type the displayed objects are. Make sure you select objects of type SQL DB Engine.

When run from the Monitoring space:

Create a state view or performance view by choosing the “MSSQL on Linux: DB Engine” type.

What Parameters are offered?

Date/Time selection: Allows selecting a relative or fixed date and time range and time zone.

Object: Allows adding objects to run this report.

Element properties:

Base	Microsoft.SystemCenter.DataWarehouse.Report.CustomConfiguration
Target	Microsoft.SQLServer.Linux.DBEngine
Accessibility	Public
Visible	True

Source Code:

<LinkedReport ID="Microsoft.SQLServer.Linux.Views.Report.SQLServerConfiguration" Target="SqlDiscL!Microsoft.SQLServer.Linux.DBEngine" Accessibility="Public" Visible="true" Base="DWReport!Microsoft.SystemCenter.DataWarehouse.Report.CustomConfiguration">

  <ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="4">

    <Controls>

      <Control columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker">

        <ReportParameters>

          <ReportParameter name="TimeZone" binding="TimeZone">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.TimeZone</Prompt>

          </ReportParameter>

          <ReportParameter name="TimeZoneName" binding="TimeZoneName"/>

          <ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>

          <ReportParameter name="StartDate_BaseValue" binding="StartDate_BaseValue">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.StartDateTime</Prompt>

          </ReportParameter>

          <ReportParameter name="StartDate_OffsetType" binding="StartDate_OffsetType"/>

          <ReportParameter name="StartDate_OffsetValue" binding="StartDate_OffsetValue"/>

          <ReportParameter name="EndDate_BaseType" binding="EndDate_BaseType"/>

          <ReportParameter name="EndDate_BaseValue" binding="EndDate_BaseValue">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.EndDateTime</Prompt>

          </ReportParameter>

          <ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>

          <ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>

        </ReportParameters>

      </Control>

      <Control columnSpan="2" rowSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.MonitoringObjectXmlPicker">

        <ReportParameters>

          <ReportParameter name="ObjectList">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.ObjectList</Prompt>

          </ReportParameter>

          <ReportParameter name="ManagementGroupId" binding="GroupList"/>

        </ReportParameters>

        <Properties>

          <Property name="ContextObjectBinding">

            <Value>Containment</Value>

          </Property>

          <Property name="TypeFilter">

            <Value>Microsoft.SQLServer.Linux.DBEngine</Value>

          </Property>

        </Properties>

      </Control>

    </Controls>

  </ParameterBlock>

  <Parameters>

    <Parameter Name="Properties">

      <Value>

            &lt;Data&gt;

            &lt;Columns&gt;

              &lt;Column Visible ="true"&gt;

                &lt;ID&gt;$MPElement[Name="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Version$&lt;/ID&gt;

              &lt;/Column&gt;

              &lt;Column Visible ="true"&gt;

                &lt;ID&gt;$MPElement[Name="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Language$&lt;/ID&gt;

              &lt;/Column&gt;

              &lt;Column Visible ="true"&gt;

                &lt;ID&gt;$MPElement[Name="SqlCoreLib!Microsoft.SQLServer.Core.Database"]/DatabaseName$&lt;/ID&gt;

              &lt;/Column&gt;

              &lt;Column Visible ="false"&gt;

                &lt;ID&gt;$MPElement[Name="SqlCoreLib!Microsoft.SQLServer.Core.Database"]/DatabaseAutogrow$&lt;/ID&gt;

              &lt;/Column&gt;

              &lt;Column Visible ="false"&gt;

                &lt;ID&gt;$MPElement[Name="SqlCoreLib!Microsoft.SQLServer.Core.Database"]/LogAutogrow$&lt;/ID&gt;

              &lt;/Column&gt;

              &lt;Column Visible ="true"&gt;

                &lt;ID&gt;$MPElement[Name="SqlCoreLib!Microsoft.SQLServer.Core.Database"]/RecoveryModel$&lt;/ID&gt;

              &lt;/Column&gt;

            &lt;/Columns&gt;

            &lt;/Data&gt;

                        </Value>

    </Parameter>

  </Parameters>

</LinkedReport>