SQLServerConfiguration For Custom Configuration Report
How does this report work?
The SQL Server Configuration report displays these discovered properties:
Version
Service Pack Version
Language
Authentication Mode
Cluster
Master Database Location
Master Database Log Location
Error Log Location
Audit Level
Enable Error Reporting
Replication Working Directory
Replication Distribution Database
The report finds data, if the objects supplied are of type
SQL DB Engine
Search for objects with the contents and the Instance name (e.g. “Instance1”)
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 the type of the displayed objects. Make sure you select objects of «SQL DB Engine» type.
When run from the Monitoring space:
Create a state view or performance view by choosing «SQL 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 for
Base | Microsoft.SystemCenter.DataWarehouse.Report.CustomConfiguration |
Target | Microsoft.SQLServer.2012.DBEngine |
Accessibility | Public |
Visible | True |
<LinkedReport ID="Report.SQLServer.2012.SQLServerConfiguration" Target="SQL2012Core!Microsoft.SQLServer.2012.DBEngine" Accessibility="Public" Visible="true" Base="ReportLibrary!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.2012.DBEngine</Value>
</Property>
</Properties>
</Control>
</Controls>
</ParameterBlock>
<Parameters>
<Parameter Name="Properties">
<Value>
<Data>
<Columns>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/Version$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/ServicePackVersion$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/Language$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/AuthenticationMode$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/Cluster$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/MasterDatabaseLocation$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/MasterDatabaseLogLocation$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/ErrorLogLocation$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/AuditLevel$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/EnableErrorReporting$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/ReplicationWorkingDirectory$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/ReplicationDistributionDatabase$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.Database"]/DatabaseName$</ID>
</Column>
<Column Visible ="false">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.Database"]/DatabaseAutogrow$</ID>
</Column>
<Column Visible ="false">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.Database"]/LogAutogrow$</ID>
</Column>
<Column Visible ="true">
<ID>$MPElement[Name="SQL!Microsoft.SQLServer.Database"]/RecoveryModel$</ID>
</Column>
</Columns>
</Data>
</Value>
</Parameter>
</Parameters>
</LinkedReport>