Home
  •  

VMMSQLVersionCheck

Monitor_VMMSQLVersionCheck (UnitMonitor)

Validates that the VMM server is using a supported SQL Server Version

Knowledge Base article:

External

http://go.microsoft.com/fwlink/?LinkId=316304

Element properties:

TargetMicrosoft.KnowledgeServices.VMM.2012.VMMServer
Parent MonitorSystem.Health.ConfigurationState
CategoryAlert
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.KnowledgeServices.Library.SchedulerMonitorEx
RemotableTrue
AccessibilityPublic
Alert Message
Unsupported SQL Server version used by VMM
<Details>
<Content>The Microsoft SQL Server instance that this VMM server is using is not running an up-to-date or supported version of SQL Server.
Upgrade to a supported SQL Server version and service pack level. See the TechNet article for more information.</Content>
<CollectedInformation>
<Info>
<Name>VMM Release</Name>
<Value>{0}</Value>
</Info>
<Info>
<Name>SQL Release</Name>
<Value>{1}</Value>
</Info>
<Info>
<Name>SQL Version</Name>
<Value>{2}</Value>
</Info>
<Info>
<Name>SQL Edition</Name>
<Value>{3}</Value>
</Info>
<Info>
<Name>SQL Product Level</Name>
<Value>{4}</Value>
</Info>
<Info>
<Name>VMM Version</Name>
<Value>{5}</Value>
</Info>
</CollectedInformation>
</Details>
RunAsDefault
CommentSupportTopic=TBD;VersionNumber=1.0.0.0;

Source Code:

<UnitMonitor ID="Monitor_VMMSQLVersionCheck" Comment="SupportTopic=TBD;VersionNumber=1.0.0.0;" Accessibility="Public" Enabled="true" Target="MicrosoftKnowledgeServicesVMM2012Library!Microsoft.KnowledgeServices.VMM.2012.VMMServer" ParentMonitorID="Health!System.Health.ConfigurationState" Remotable="true" Priority="Normal" TypeID="KnowledgeServicesLibrary!Microsoft.KnowledgeServices.Library.SchedulerMonitorEx" ConfirmDelivery="true">

  <Category>Alert</Category>

  <AlertSettings AlertMessage="MonitorMessage63e1cf238006418d8208365e04e4caf8">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type="MicrosoftKnowledgeServicesVMM2012Library!Microsoft.KnowledgeServices.VMM.2012.VMMServer"]/VMMRelease$</AlertParameter1>

      <AlertParameter2>$Target/Property[Type="MicrosoftKnowledgeServicesVMM2012Library!Microsoft.KnowledgeServices.VMM.2012.VMMServer"]/SQLRelease$</AlertParameter2>

      <AlertParameter3>$Target/Property[Type="MicrosoftKnowledgeServicesVMM2012Library!Microsoft.KnowledgeServices.VMM.2012.VMMServer"]/SQLVersion$</AlertParameter3>

      <AlertParameter4>$Target/Property[Type="MicrosoftKnowledgeServicesVMM2012Library!Microsoft.KnowledgeServices.VMM.2012.VMMServer"]/SQLEdition$</AlertParameter4>

      <AlertParameter5>$Target/Property[Type="MicrosoftKnowledgeServicesVMM2012Library!Microsoft.KnowledgeServices.VMM.2012.VMMServer"]/SQLProductLevel$</AlertParameter5>

      <AlertParameter6>$Target/Property[Type="MicrosoftKnowledgeServicesVMM2012Library!Microsoft.KnowledgeServices.VMM.2012.VMMServer"]/ProductVersion$</AlertParameter6>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Success" MonitorTypeStateID="Success" HealthState="Success"/>

    <OperationalState ID="Error" MonitorTypeStateID="Error" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <ErrorExpression>

      <SimpleExpression>

        <ValueExpression>

          <Value Type="Boolean">$Target/Property[Type="MicrosoftKnowledgeServicesVMM2012Library!Microsoft.KnowledgeServices.VMM.2012.VMMServer"]/UnsupportedSQLVersion$</Value>

        </ValueExpression>

        <Operator>Equal</Operator>

        <ValueExpression>

          <Value Type="Boolean">true</Value>

        </ValueExpression>

      </SimpleExpression>

    </ErrorExpression>

    <SuccessExpression>

      <Not>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <Value Type="Boolean">$Target/Property[Type="MicrosoftKnowledgeServicesVMM2012Library!Microsoft.KnowledgeServices.VMM.2012.VMMServer"]/UnsupportedSQLVersion$</Value>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="Boolean">true</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </Not>

    </SuccessExpression>

    <Schedule>16230</Schedule>

  </Configuration>

</UnitMonitor>