Home
  •  

AKN574239

Monitor_AKN574239 (UnitMonitor)

One or more of the local databases in the Lync Server 2013 environment is out of date

Knowledge Base article:

External

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

Element properties:

TargetMicrosoft.KnowledgeServices.Lync.2010.CsServer
Parent MonitorSystem.Health.ConfigurationState
CategoryAlert
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityHigh
Alert Auto ResolveTrue
Monitor TypeMicrosoft.KnowledgeServices.Library.PowerShellMonitorEx
RemotableTrue
AccessibilityPublic
Alert Message
One or more of the local databases in the Lync Server 2013 environment is out of date
<Details>
<Content>System Center Advisor has detected that one or more of the local databases in the Lync Server 2013 environment is out of date and needs to be updated. An out of date database version can create an unstable Lync Server 2013 environment. See the KB article for information on how to update the database.</Content>
<CollectedInformation>
<Info>
<Name>Server Name</Name>
<Value>{0}</Value>
</Info>
<Info>
<Name>Databases</Name>
<Value>{1}</Value>
</Info>
</CollectedInformation>
</Details>
RunAsMicrosoft.KnowledgeServices.ElevatedAccount
CommentSupportTopic=TBD;VersionNumber=1.0.0.0;

Source Code:

<UnitMonitor ID="Monitor_AKN574239" Comment="SupportTopic=TBD;VersionNumber=1.0.0.0;" Accessibility="Public" Enabled="true" Target="MicrosoftKnowledgeServicesLyncLibrary!Microsoft.KnowledgeServices.Lync.2010.CsServer" ParentMonitorID="Health!System.Health.ConfigurationState" Remotable="true" Priority="High" RunAs="KnowledgeServicesLibrary!Microsoft.KnowledgeServices.ElevatedAccount" TypeID="KnowledgeServicesLibrary!Microsoft.KnowledgeServices.Library.PowerShellMonitorEx" ConfirmDelivery="true">

  <Category>Alert</Category>

  <AlertSettings AlertMessage="MonitorMessagedb174198e1664c5d90d3ed521b2a9bac">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>High</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/Property[@Name='ServerName']$</AlertParameter1>

      <AlertParameter2>$Data/Context/Property[@Name='IssueDbs']$</AlertParameter2>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

    <ScriptName>AKN574239.ps1</ScriptName>

    <Parameters>

      <Parameter>

        <Name>ServerFQDN</Name>

        <Value>$Target/Property[Type="MicrosoftKnowledgeServicesLyncLibrary!Microsoft.KnowledgeServices.Lync.2010.CsServer"]/ReplicaFqdn$</Value>

      </Parameter>

    </Parameters>

    <ScriptBody><Script>PARAM($ServerFQDN)

[ScriptBlock]$mainScriptBlock = {





param($ServerFQDN)



$ErrorActionPreference = "Stop"



# Set up the arguments

$scriptargs = new-object psobject

$scriptargs | add-member NoteProperty "ServerFQDN" $ServerFQDN



# Set up the output

$global:scriptoutput = new-object psobject

$scriptoutput | add-member NoteProperty "HasIssue" $false

$scriptoutput | add-member NoteProperty "IssueDbs" ""

$scriptoutput | add-member NoteProperty "ServerName" ""

#----------------------------------------------------- 

# Environment 

#-----------------------------------------------------

$script:lyncPath = ""

if (Join-Path $Env:CommonProgramFiles "\Microsoft Lync Server 2013\Modules\Lync\Lync.psd1" | Test-Path)

{

    $script:lyncPath = Join-Path $Env:CommonProgramFiles "\Microsoft Lync Server 2013\Modules\Lync\Lync.psd1"

    $script:lyncPSVer = 2013

}

elseif (Join-Path $Env:CommonProgramFiles "\Microsoft Lync Server 2010\Modules\Lync\Lync.psd1" | Test-Path)

{

    $script:lyncPath = Join-Path $Env:CommonProgramFiles "\Microsoft Lync Server 2010\Modules\Lync\Lync.psd1"

    $script:lyncPSVer = 2010

}

$ScriptEnv = New-Object psobject

$ScriptEnv | Add-Member NoteProperty "RuntimeError" $false

$ScriptEnv | Add-Member NoteProperty "HasIssue" $false

$ScriptEnv | add-member ScriptMethod "ImportLyncPSModule" -value {

    $m = Get-Module -Name Lync

    if ($m -eq $null)

    {

       Import-Module $script:lyncPath -ErrorAction:SilentlyContinue

    }

}

$ScriptEnv | Add-Member ScriptMethod "IsCMSMaster" -Value {

    Try

    {

        $cmsStatus = Get-CsManagementStoreReplicationStatus -CentralManagementStoreStatus

        $agentHostFqdn = [System.Net.Dns]::GetHostByName([System.Net.Dns]::GetHostName()).HostName

        return $cmsStatus.ActiveMasterFqdn -ieq $agentHostFqdn

    }

    Catch [Microsoft.Rtc.Management.ADConnect.CannotGetDomainInfoException]

    {

    }

    Catch [Microsoft.Rtc.Common.Data.SqlConnectionException]

    {

    }

    Catch [System.Data.SqlClient.SqlException]

    {

    }

    return $false

}



#----------------------------------------------------- 

# MAIN CODE SECTION

#----------------------------------------------------- 



$scriptenv | Add-Member NoteProperty "IssueDbs" ""



function IsSQLNeedToBeUpdated()

{

	$tempString = ""

	$dbresults = @(Test-CsDatabase -LocalService | Where-Object {$_.SqlServerFqdn -eq "(local)"})

	$tempString = (BuildOutput $dbresults)

	

	if($tempString -ne "")

	{ 

		$scriptenv.IssueDbs = $tempString

		return $true

	}

	else

	{

		return $false

	}

}



function BuildOutput($dbresults)

{

	$tempString = ""

	foreach($db in $dbresults)

	{

		if($db.ExpectedVersion -notmatch $db.InstalledVersion)

		{

			$tempString += [string]::Format("&lt;row&gt;&lt;DB&gt;{0}&lt;/DB&gt;&lt;/row&gt;",$db.DatabaseName)

		}

	}

	return $tempString

}



# Main Function

function AdvisorRule($scriptargs, $scriptoutput)

{

	trap [Exception]

    {

        $scriptenv.RuntimeError = $true

        continue

    }



    if ($script:lyncPSVer -eq 2013)

    {

        $scriptoutput.HasIssue = $false

		

		$scriptenv.ImportLyncPSModule()

		

		if((IsSQLNeedToBeUpdated))

		{

			$scriptenv.HasIssue = $true

		}



        if($scriptenv.HasIssue -eq $true -and $scriptenv.RuntimeError -eq $false)

        {

            $scriptoutput.HasIssue = $true

			$scriptoutput.IssueDbs = $scriptenv.IssueDbs

			$scriptoutput.ServerName = $scriptargs.ServerFQDN

        }

    }

}



AdvisorRule $scriptargs $scriptoutput



}



Function Test-NeedPSRemoting

{

    $script:lyncPSVer = 0

    if (Join-Path $Env:CommonProgramFiles "\Microsoft Lync Server 2013\Modules\Lync\Lync.psd1" | Test-Path)

    {

        $script:lyncPSVer = 2013

    }

    elseif (Join-Path $Env:CommonProgramFiles "\Microsoft Lync Server 2010\Modules\Lync\Lync.psd1" | Test-Path)

    {

        $script:lyncPSVer = 2010

    }

    $PSCLRVersion = [System.String]::Format("{0}.{1}", $PSVersionTable.CLRVersion.Major, $PSVersionTable.CLRVersion.Minor)

    if (($PSCLRVersion -ieq "2.0") -and ($script:lyncPSVer -ieq 2013))

    {

        return $true

    }

    return $false

}



if ((Test-NeedPSRemoting))

{

    [bool]$script:psRemotingEnabled = $false

    # Enable PowerShell Remoting need elevated BUILTIN\Administrators privilege

    $winRMService = (Get-Service WinRM -ErrorAction SilentlyContinue)

    if ($winRMService -ne $null)

    {

        if ($winRMService.Status -ieq [System.ServiceProcess.ServiceControllerStatus]::Stopped)

        {

            $winRMService.Start()

            $winRMService.WaitForStatus([System.ServiceProcess.ServiceControllerStatus]::Running, [System.TimeSpan]::FromSeconds(15))

        }

        $psSessionConfiguration = (Get-PSSessionConfiguration -Name "Microsoft.PowerShell" -ErrorAction SilentlyContinue)

        if ($psSessionConfiguration.Permission.Contains("BUILTIN\Administrators AccessAllowed"))

        {

            $script:psRemotingEnabled = $true

        }

    }



    # Call remote PS session when PSRemoting is enabled.

    if ($script:psRemotingEnabled -eq $true)

    {

        $session = New-PSSession

        Invoke-Command -Session $session -ScriptBlock $mainScriptBlock -ArgumentList @($ServerFQDN)

        $global:scriptoutput = Invoke-Command -Session $session -ScriptBlock {$global:scriptoutput}

        Remove-PSSession -Session $session

    }

}

else

{

    &amp; $mainScriptBlock $ServerFQDN

}



# set the output

$mom = new-object -comobject "MOM.ScriptAPI"

$bag = $mom.CreatePropertyBag()



if ($scriptoutput.HasIssue -ne $null)

{

	$bag.AddValue("HasIssue", $scriptoutput.HasIssue)

}



if ($scriptoutput.IssueDbs -ne $null)

{

	$bag.AddValue("IssueDbs", $scriptoutput.IssueDbs)

}



if ($scriptoutput.ServerName -ne $null)

{

	$bag.AddValue("ServerName", $scriptoutput.ServerName)

}



$bag



</Script></ScriptBody>

    <SnapIns/>

    <TimeoutSeconds>300</TimeoutSeconds>

    <Schedule>14400</Schedule>

    <ErrorExpression>

      <SimpleExpression>

        <ValueExpression>

          <XPathQuery Type="Boolean">Property[@Name='HasIssue']</XPathQuery>

        </ValueExpression>

        <Operator>Equal</Operator>

        <ValueExpression>

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

        </ValueExpression>

      </SimpleExpression>

    </ErrorExpression>

    <SuccessExpression>

      <Not>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="Boolean">Property[@Name='HasIssue']</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </Not>

    </SuccessExpression>

  </Configuration>

</UnitMonitor>