SQL 2016 DB Engine

Microsoft.SQLServer.RunAs.2016.Addendum.Engine.State.View (View)

Element properties:

Target	Microsoft.SQLServer.2016.DBEngine
Type	Microsoft.SystemCenter.StateViewType
Accessibility	Public
Visible	True
Source Code:

<View ID="Microsoft.SQLServer.RunAs.2016.Addendum.Engine.State.View" Accessibility="Public" Enabled="true" Target="SQL2016Disc!Microsoft.SQLServer.2016.DBEngine" TypeID="SC!Microsoft.SystemCenter.StateViewType" Visible="true">

  <Category>Operations</Category>

  <Criteria>

    <InMaintenanceMode>false</InMaintenanceMode>

  </Criteria>

  <Presentation>

    <ColumnInfo Index="0" SortIndex="0" Width="100" Grouped="false" Sorted="true" IsSortable="true" Visible="true" SortOrder="Descending">

      <Name>State</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine-*-046ce89d-e1e2-e18e-d891-96e004f6ed5f-*-Health</Id>

    </ColumnInfo>

    <ColumnInfo Index="1" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="true" SortOrder="Ascending">

      <Name>Maintenance Mode</Name>

      <Id>InMaintenanceMode</Id>

    </ColumnInfo>

    <ColumnInfo Index="2" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="true" SortOrder="Ascending">

      <Name>Name</Name>

      <Id>Name</Id>

    </ColumnInfo>

    <ColumnInfo Index="3" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="true" SortOrder="Ascending">

      <Name>Path</Name>

      <Id>Path</Id>

    </ColumnInfo>

    <ColumnInfo Index="4" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Display Name</Name>

      <Id>System.Entity/DisplayName</Id>

    </ColumnInfo>

    <ColumnInfo Index="5" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Instance Name</Name>

      <Id>Microsoft.SQLServer.2016.ServerRole/InstanceName</Id>

    </ColumnInfo>

    <ColumnInfo Index="6" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Instance Type</Name>

      <Id>Microsoft.SQLServer.2016.ServerRole/Type</Id>

    </ColumnInfo>

    <ColumnInfo Index="7" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Version</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/Version</Id>

    </ColumnInfo>

    <ColumnInfo Index="8" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Edition</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/Edition</Id>

    </ColumnInfo>

    <ColumnInfo Index="9" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Authentication Mode</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/AuthenticationMode</Id>

    </ColumnInfo>

    <ColumnInfo Index="10" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>SQL Server Windows Service Name</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/ServiceName</Id>

    </ColumnInfo>

    <ColumnInfo Index="11" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>SQL Server Windows Service Name If Clustered Resource</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/ServiceClusterName</Id>

    </ColumnInfo>

    <ColumnInfo Index="12" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Full Text Search Service Name</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/FullTextSearchServiceName</Id>

    </ColumnInfo>

    <ColumnInfo Index="13" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Full Text Search Service Name If Clustered Resource</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/FullTextSearchServiceClusterName</Id>

    </ColumnInfo>

    <ColumnInfo Index="14" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>SQL Server Agent Windows Service Name</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/AgentName</Id>

    </ColumnInfo>

    <ColumnInfo Index="15" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>SQL Server Agent Windows Service Name If Clustered Resource</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/AgentClusterName</Id>

    </ColumnInfo>

    <ColumnInfo Index="16" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Connection String</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/ConnectionString</Id>

    </ColumnInfo>

    <ColumnInfo Index="17" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Tcp Port</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/TcpPort</Id>

    </ColumnInfo>

    <ColumnInfo Index="18" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Master Database Location</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/MasterDatabaseLocation</Id>

    </ColumnInfo>

    <ColumnInfo Index="19" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Master Database Log Location</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/MasterDatabaseLogLocation</Id>

    </ColumnInfo>

    <ColumnInfo Index="20" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Error Log Location</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/ErrorLogLocation</Id>

    </ColumnInfo>

    <ColumnInfo Index="21" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Language</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/Language</Id>

    </ColumnInfo>

    <ColumnInfo Index="22" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Service Pack Version</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/ServicePackVersion</Id>

    </ColumnInfo>

    <ColumnInfo Index="23" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Audit Level</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/AuditLevel</Id>

    </ColumnInfo>

    <ColumnInfo Index="24" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Install Path</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/InstallPath</Id>

    </ColumnInfo>

    <ColumnInfo Index="25" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Tools Path</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/ToolsPath</Id>

    </ColumnInfo>

    <ColumnInfo Index="26" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Error Reporting Enabled</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/EnableErrorReporting</Id>

    </ColumnInfo>

    <ColumnInfo Index="27" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Replication Working Directory</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/ReplicationWorkingDirectory</Id>

    </ColumnInfo>

    <ColumnInfo Index="28" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Replication Distribution Database</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/ReplicationDistributionDatabase</Id>

    </ColumnInfo>

    <ColumnInfo Index="29" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Performance Counter Object Name</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/PerformanceCounterObject</Id>

    </ColumnInfo>

    <ColumnInfo Index="30" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Cluster</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/Cluster</Id>

    </ColumnInfo>

    <ColumnInfo Index="31" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Account Name</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/Account</Id>

    </ColumnInfo>

    <ColumnInfo Index="32" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Instance ID</Name>

      <Id>Microsoft.SQLServer.2016.DBEngine/InstanceID</Id>

    </ColumnInfo>

    <ColumnInfo Index="33" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>SQL 2016 Mirroring Witness Role</Name>

      <Id>Microsoft.SQLServer.2016.Mirroring.WitnessRole</Id>

    </ColumnInfo>

    <ColumnInfo Index="34" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>SQL Server 2016 DB</Name>

      <Id>Microsoft.SQLServer.2016.Database</Id>

    </ColumnInfo>

    <ColumnInfo Index="35" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>SQL 2016 Mirrored DB</Name>

      <Id>Microsoft.SQLServer.2016.Mirroring.Database</Id>

    </ColumnInfo>

    <ColumnInfo Index="36" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>SQL Server 2016 Resource Pool Group</Name>

      <Id>Microsoft.SQLServer.2016.ResourcePoolGroup</Id>

    </ColumnInfo>

    <ColumnInfo Index="37" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>SQL Server 2016 Agent</Name>

      <Id>Microsoft.SQLServer.2016.Agent</Id>

    </ColumnInfo>

  </Presentation>

  <Target/>

</View>