No property "port" in SQL 2017+ Management Pack

peterwsvensson · December 3, 2018, 2:48pm

Hi

We are missing the property “Port” on the DB Engine Class in SQL 2017+ Management Pack. Anyone else that can verify this?

SQL 2017+ MP version is: 7.0.7.0

rubenz · December 3, 2018, 11:57pm

Hi Peter,

I can confirm your finding. Here in XML.

Class for DBEngine in SQL 2008 / 2012 in MP 7.0.7

<ClassType ID="Microsoft.SQLServer.DBEngine" Accessibility="Public" Abstract="false" Base="Microsoft.SQLServer.ServerRole" Hosted="true" Singleton="false" Extension="false">
  <Property ID="Version" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="Edition" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="AuthenticationMode" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="ServiceName" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="ServiceClusterName" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="FullTextSearchServiceName" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="FullTextSearchServiceClusterName" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="AgentName" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="AgentClusterName" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="ConnectionString" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="MasterDatabaseLocation" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="260" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="MasterDatabaseLogLocation" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="260" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="ErrorLogLocation" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="260" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="Language" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="ServicePackVersion" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="AuditLevel" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="InstallPath" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="260" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="ToolsPath" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="260" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="EnableErrorReporting" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="ReplicationWorkingDirectory" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="260" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="ReplicationDistributionDatabase" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="PerformanceCounterObject" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="Cluster" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="Account" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="InstanceID" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="TcpPort" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  </ClassType>

Class for DBEngine in SQL 20117 in MP 7.0.7

- <ClassType ID="Microsoft.SQLServer.Core.DBEngine" Accessibility="Public" Abstract="true" Base="System!System.Entity" Hosted="false" Singleton="false" Extension="false">
  <Property ID="MachineName" Type="string" AutoIncrement="false" Key="true" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="InstanceName" Type="string" AutoIncrement="false" Key="true" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="ConnectionString" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="Edition" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="Language" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="Version" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="ServiceName" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="ServiceClusterName" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="Cluster" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="PerformanceCounterObject" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="AgentName" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" /> 
  <Property ID="Type" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" DefaultValue="DB Engine" /> 
  </ClassType>

I even checked the whole MP and could not find the word “port” at all.

How do you think about creating a suggestion on ‘UserVoice’ ? https://systemcenterom.uservoice.com/forums/293064-general-operations-manager-feedback

As far I know MS reads it from time to time.

Kind regards

Ruben

peterwsvensson · December 6, 2018, 8:10am

Got an answer from Microsoft:

“Regarding the TCPPort property, it became unnecessary even in SQL 2008-2016 MPs many releases ago. But SCOM doesn’t require to remove properties when you don’t need them, so we kept it in these MPs. There’s also one problem with this property—you can’t rely on its value in some cases. That’s why we stopped using it in the old MPs and don’t have it in the MP.”

In our case we used it for a custom Script. According to MS its not necessary to use the port when connecting to the instance. So for our part it’s resolved.

peterwsvensson · December 4, 2018, 6:26am

Thanks Ruben.
I will open up a case against Microsoft and see what they say about it. Seems like a flaw in the MP Design.