# Copyright (c) 2010 Microsoft Corporation. All rights reserved. # # THIS CODE IS MADE AVAILABLE AS IS, WITHOUT WARRANTY OF ANY KIND. THE ENTIRE RISK # OF THE USE OR THE RESULTS FROM THE USE OF THIS CODE REMAINS WITH THE USER. # Requires -Version 2 # Figures out on which volume our path is residing. This is necessary # because customers mount spindles into a folder. function Get-WmiVolumeFromPath([string] $FilePath, [string] $Server) { do { $FilePath = $FilePath.Substring(0, $FilePath.LastIndexOf('\') + 1) $wmiFilter = ('Name="{0}"' -f $FilePath.Replace("\", "\\")) $volume = get-wmiobject -class win32_volume -computername $Server -filter $wmiFilter $FilePath = $FilePath.Substring(0, $FilePath.LastIndexOf('\')) } while ($volume -eq $null) return $volume } # Returns a descending list of the users generating the most log bytes for a given database # based on the output of Get-StoreUsageStatistics the list contains the MailboxGuid and the # number of bytes generated during the captured sampling periods (~ 1 hour) function Get-TopLogGenerators([string] $DatabaseIdentity) { # The Filter parameter doesn't accept complex filters, so filter on the category # and then use a where clause to filter out the Quarantined mailboxes. $topGenerators = New-Object Collections.ArrayList $global:StoreUsageStatsLB = Get-StoreUsageStatistics -Database $DatabaseIdentity ` -Filter "DigestCategory -eq 'LogBytes'" if ($global:StoreUsageStatsLB) { $stats = $global:StoreUsageStatsLB | where {$_.IsQuarantined -eq $false} ` | group MailboxGuid if ($null -ne $stats) { foreach($mailboxStats in $stats) { $total = 0 $statSummary = new-object PSObject foreach($stat in $mailboxStats.Group) { $total += $stat.LogRecordBytes } Add-Member -in $statSummary -Name TotalLogBytes -MemberType NoteProperty -Value $total Add-Member -in $statSummary -Name MailboxGuid -MemberType NoteProperty -Value $mailboxStats.Group[0].MailboxGuid # Tell PS we don't care about the return value for this function # otherwise these values will be output to the pipeline! [void]$topGenerators.Add($statSummary) } $topGenerators = Sort-Object -InputObject $topGenerators -Property TotalLogBytes -Descending } } return $topGenerators } # Returns a descending list of the users using up the most time in server for a given database # based on the output of Get-StoreUsageStatistics the list contains the MailboxGuid and the # time in server used up during the captured sampling periods (10 min) function Get-TopCpuUsers([string] $DatabaseIdentity, [int] $TimeInServerThreshold, [int] $RopLatencyThreshold, [int] $PercentSampleBelowThresholdToAlert, [int] $MinimumStoreUsageStatisticsSampleCount) { $topUsers = New-Object Collections.ArrayList $global:StoreUsageStatsTS = Get-StoreUsageStatistics -Database $DatabaseIdentity ` -Filter "DigestCategory -eq 'TimeInServer'" if ($global:StoreUsageStatsTS) { # First let's see if most users are being affected by high latency # or if it's just a small percent of users $totalCountAboveThreshold = 0 $totalPctBelowThreshold = 0 $totalCountAboveThreshold = ($global:StoreUsageStatsTS | ? {$_.TimeInServer/$_.RopCount -ge $RopLatencyThreshold} | measure).count; $totalPercentBelowThreshold = [Math]::Round(100*($global:StoreUsageStatsTS.count - $totalCountAboveThreshold)/($global:StoreUsageStatsTS.count),1); # This is a condition that requires further investigation - If we have enough samples # and if users above the totalPercentBelowThreshold are having a bad experience If ($global:StoreUsageStatsTS.count -ge $MinimumStoreUsageStatisticsSampleCount -and $totalPercentBelowThreshold -lt $PercentSampleBelowThresholdToAlert) { $stats = $global:StoreUsageStatsTS | where {$_.IsQuarantined -eq $false} ` | group MailboxGuid if ($null -ne $stats) { foreach($mailboxStats in $stats) { $statSummary = new-object PSObject $totalTimeInServer = 0 $totalROPCount = 0 # Get Total TimeInServer and ROPCount foreach($stat in $mailboxStats.Group) { $totalTimeInServer += $stat.TimeInServer $totalROPCount += $stat.ROPCount } # Calculate averages $averageTimeInServer = $totalTimeInServer / $mailboxStats.Count $averageROPCount = $totalROPCount / $mailboxStats.Count $ropLatency = $averageTimeInServer / $averageROPCount # If either TimeInServer or RopLatency is above the threshold, include that mailbox in the list if (($averageTimeInServer -ge $TimeInServerThreshold) -or ($ropLatency -ge $RopLatencyThreshold)) { Add-Member -in $statSummary -Name TotalTimeInServer -MemberType NoteProperty -Value $totalTimeInServer Add-Member -in $statSummary -Name AverageTimeInServer -MemberType NoteProperty -Value $averageTimeInServer Add-Member -in $statSummary -Name RopLatency -MemberType NoteProperty -Value $ropLatency Add-Member -in $statSummary -Name MailboxGuid -MemberType NoteProperty -Value $mailboxStats.Group[0].MailboxGuid Add-Member -in $statSummary -Name Count -MemberType NoteProperty -Value $mailboxStats.Count # Tell PS we don't care about the return value for this function # otherwise these values will be output to the pipeline! [void]$topUsers.Add($statSummary) } } $topUsers = Sort-Object -InputObject $topUsers -Property TotalTimeInServer -Descending } } } return $topUsers } function Get-RegistryValue { param( [string]$Server = ".", [Parameter(Mandatory=$true)][Microsoft.Win32.RegistryHive]$Hive, [Parameter(Mandatory=$true)][string]$KeyName, [Parameter(Mandatory=$true)][string]$ValueName, [object]$DefaultValue = $null ) try { $baseKey = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey($Hive, $Server) $key = $baseKey.OpenSubKey($KeyName, $false) if ($key -ne $null) { $key.GetValue($ValueName, $DefaultValue) } } finally { if ($key -ne $null) { $key.Close() } if ($baseKey -ne $null) { $baseKey.Close() } } } function Set-RegistryValue { param( [string]$Server = ".", [Parameter(Mandatory=$true)][Microsoft.Win32.RegistryHive]$Hive, [Parameter(Mandatory=$true)][string]$KeyName, [Parameter(Mandatory=$true)][string]$ValueName, [Parameter(Mandatory=$true)][object]$Value, [Microsoft.Win32.RegistryValueKind]$ValueKind = "Unknown" ) try { $baseKey = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey($Hive, $Server) $key = $baseKey.OpenSubKey($KeyName, $true) if ($key -eq $null) { $key = $baseKey.CreateSubKey($KeyName) } $key.SetValue($ValueName, $Value, $ValueKind) } finally { if ($key -ne $null) { $key.Close() } if ($baseKey -ne $null) { $baseKey.Close() } } } function Remove-RegistryValue { param( [string]$Server = ".", [Parameter(Mandatory=$true)][Microsoft.Win32.RegistryHive]$Hive, [Parameter(Mandatory=$true)][string]$KeyName, [Parameter(Mandatory=$true)][string]$ValueName ) try { $baseKey = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey($Hive, $Server) $key = $baseKey.OpenSubKey($KeyName, $true) if ($key -ne $null) { $key.DeleteValue($ValueName, $false) } } finally { if ($key -ne $null) { $key.Close() } if ($baseKey -ne $null) { $baseKey.Close() } } } function Remove-RegistryKey { param( [string]$Server = ".", [Parameter(Mandatory=$true)][Microsoft.Win32.RegistryHive]$Hive, [Parameter(Mandatory=$true)][string]$KeyName ) try { $baseKey = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey($Hive, $Server) $baseKey.DeleteSubKeyTree($KeyName) } finally { if ($key -ne $null) { $key.Close() } if ($baseKey -ne $null) { $baseKey.Close() } } } function Get-RegistrySubKeyNames { param( [string]$Server = ".", [Parameter(Mandatory=$true)][Microsoft.Win32.RegistryHive]$Hive, [Parameter(Mandatory=$true)][string]$KeyName ) try { $baseKey = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey($Hive, $Server) $key = $baseKey.OpenSubKey($KeyName, $false) if ($key -ne $null) { $key.GetSubKeyNames() } } finally { if ($key -ne $null) { $key.Close() } if ($baseKey -ne $null) { $baseKey.Close() } } } function Get-AverageResultForCounter($results, $counter, $instance) { #Turn strictmode off so that if we don't have cookedvalue #for a particular instance, we don't get an exception. #This way, we can get average from whatever counters are #available and continue as far as we can. Turning strict mode #off is only within the scope of this function. Set-StrictMode -off $count = 0 $total = $null $counterName = $counter if ($instance) { $counterName = $counterName.replace("*", $instance) } foreach ($sample in $results) { $cookedValue = ($sample.CounterSamples | ?{$_.Path -like "*$counterName*"}).CookedValue if ($cookedValue -ne $null) { #We want to increment the number of samples here so that #we can calculate the avg properly rather than assuming #that we got samples equal to the length of results $total += $cookedValue $count++ } } If ($total -ne $null -and $count -ne 0) { return $total/($count) } else { $failureReason = ($StoreLocStrings.FailureToGetCounter + $counterName) if ($Arguments -ne $null) { #Get the invoking scriptname so we can put in the event $script = $MyInvocation.ScriptName.Substring($MyInvocation.ScriptName.LastIndexOf('\') + 1) if ($script -ne $null) { $script = $script.Substring(0,$script.Length - 4) } else { $script = "Troubleshooter" } Log-Event ` -Arguments $Arguments ` -EventInfo $StoreLogEntries.DatabaseTroubleShooterNotRun ` -Parameters @($script, $failureReason) } throw $failureReason } } Import-LocalizedData -BindingVariable StoreLocStrings -FileName StoreTSLibrary.strings.psd1 $StoreLogEntries = @{ # # Events logged to application log and windows event (crimson) log # Information: 5100-5199; Warning: 5400-5499; Error: 5700-5799; # # Informational events # DatabaseSpaceTroubleShooterStarted=(5100,"Information", $StoreLocStrings.DatabaseSpaceTroubleShooterStarted) DatabaseSpaceTroubleShooterNoProblemDetected=(5101,"Information", $StoreLocStrings.DatabaseSpaceTroubleShooterNoProblemDetected) DatabaseLatencyTroubleShooterStarted=(5110,"Information", $StoreLocStrings.DatabaseLatencyTroubleShooterStarted) DatabaseLatencyTroubleShooterNoLatency=(5111,"Information", $StoreLocStrings.DatabaseLatencyTroubleShooterNoLatency) DatabaseLatencyTroubleShooterLowOps=(5112,"Information", $StoreLocStrings.DatabaseLatencyTroubleShooterLowOps) DatabaseTroubleShooterNotRun=(5113,"Information", $StoreLocStrings.DatabaseTroubleShooterNotRun) DatabaseLatencyTroubleShooterNotRunDatabase=(5114,"Information", $StoreLocStrings.DatabaseLatencyTroubleShooterNotRunDatabase) DatabaseLatencyTroubleShooterUniqueMailbox=(5115,"Information", $StoreLocStrings.DatabaseLatencyTroubleShooterUniqueMailbox) DatabaseLatencyTroubleShooterNoMailbox=(5116,"Information", $StoreLocStrings.DatabaseLatencyTroubleShooterNoMailbox) DatabaseSpaceTroubleShooterFoundLowSpace=(5400,"Warning", $StoreLocStrings.DatabaseSpaceTroubleShooterFoundLowSpace) DatabaseSpaceTroubleShooterFoundLowSpaceNoQuarantine=(5401,"Warning", $StoreLocStrings.DatabaseSpaceTroubleShooterFoundLowSpaceNoQuarantine) DatabaseSpaceTroubleDetectedWarningSpaceIssue=(5402,"Warning", $StoreLocStrings.DatabaseSpaceTroubleDetectedWarningSpaceIssue) DatabaseSpaceTroubleShooterQuarantineUser=(5410,"Warning", $StoreLocStrings.DatabaseSpaceTroubleShooterQuarantineUser) DatabaseLatencyTroubleShooterQuarantineUser=(5411,"Warning", $StoreLocStrings.DatabaseLatencyTroubleShooterQuarantineUser) DatabaseLatencyTroubleShooterNoQuarantine=(5412,"Warning", $StoreLocStrings.DatabaseLatencyTroubleShooterNoQuarantine) DatabaseSpaceTroubleShooterFinishedInsufficient=(5700,"Error", $StoreLocStrings.DatabaseSpaceTroubleShooterFinishedInsufficient) DatabaseSpaceTroubleDetectedAlertSpaceIssue=(5701,"Error", $StoreLocStrings.DatabaseSpaceTroubleDetectedAlertSpaceIssue) DatabaseSpaceTroubleDetectedCriticalSpaceIssue=(5702,"Error", $StoreLocStrings.DatabaseSpaceTroubleDetectedCriticalSpaceIssue) DatabaseLatencyTroubleShooterBadDiskLatencies=(5710,"Error", $StoreLocStrings.DatabaseLatencyTroubleShooterBadDiskLatencies) DatabaseLatencyTroubleShooterBadDSAccessActiveCallCount=(5711,"Error", $StoreLocStrings.DatabaseLatencyTroubleShooterBadDSAccessActiveCallCount) DatabaseLatencyTroubleShooterIneffective=(5712,"Error", $StoreLocStrings.DatabaseLatencyTroubleShooterIneffective) DatabaseLatencyTroubleShooterBadDSAccessAverageLatency=(5713,"Error", $StoreLocStrings.DatabaseLatencyTroubleShooterBadDSAccessAverageLatency) } # SIG # Begin signature block # MIIavQYJKoZIhvcNAQcCoIIarjCCGqoCAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB # gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR # AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUZBLU0SgWPq6EnyVMP0qu1JGk # VlqgghWCMIIEwzCCA6ugAwIBAgITMwAAAEyh6E3MtHR7OwAAAAAATDANBgkqhkiG # 9w0BAQUFADB3MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4G # A1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSEw # HwYDVQQDExhNaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EwHhcNMTMxMTExMjIxMTMx # WhcNMTUwMjExMjIxMTMxWjCBszELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hp # bmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jw # b3JhdGlvbjENMAsGA1UECxMETU9QUjEnMCUGA1UECxMebkNpcGhlciBEU0UgRVNO # OkMwRjQtMzA4Ni1ERUY4MSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFtcCBT # ZXJ2aWNlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAsdj6GwYrd6jk # lF18D+Z6ppLuilQdpPmEdYWXzMtcltDXdS3ZCPtb0u4tJcY3PvWrfhpT5Ve+a+i/ # ypYK3EbxWh4+AtKy4CaOAGR7vjyT+FgyeYfSGl0jvJxRxA8Q+gRYtRZ2buy8xuW+ # /K2swUHbqs559RyymUGneiUr/6t4DVg6sV5Q3mRM4MoVKt+m6f6kZi9bEAkJJiHU # Pw0vbdL4d5ADbN4UEqWM5zYf9IelsEEXb+NNdGbC/aJxRjVRzGsXUWP6FZSSml9L # KLrmFkVJ6Sy1/ouHr/ylbUPcpjD6KSjvmw0sXIPeEo1qtNtx71wUWiojKP+BcFfx # jAeaE9gqUwIDAQABo4IBCTCCAQUwHQYDVR0OBBYEFLkNrbNN9NqfGrInJlUNIETY # mOL0MB8GA1UdIwQYMBaAFCM0+NlSRnAK7UD7dvuzK7DDNbMPMFQGA1UdHwRNMEsw # SaBHoEWGQ2h0dHA6Ly9jcmwubWljcm9zb2Z0LmNvbS9wa2kvY3JsL3Byb2R1Y3Rz # L01pY3Jvc29mdFRpbWVTdGFtcFBDQS5jcmwwWAYIKwYBBQUHAQEETDBKMEgGCCsG # AQUFBzAChjxodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpL2NlcnRzL01pY3Jv # c29mdFRpbWVTdGFtcFBDQS5jcnQwEwYDVR0lBAwwCgYIKwYBBQUHAwgwDQYJKoZI # hvcNAQEFBQADggEBAAmKTgav6O2Czx0HftcqpyQLLa+aWyR/lHEMVYgkGlIVY+KQ # TQVKmEqc++GnbWhVgrkp6mmpstXjDNrR1nolN3hnHAz72ylaGpc4KjlWRvs1gbnk # PUZajuT8dTdYWUmLTts8FZ1zUkvreww6wi3Bs5tSLeA1xbnBV7PoPaE8RPIjFh4K # qlk3J9CVUl6ofz9U8IHh3Jq9ZdV49vdMObvd4NY3DpGah4xz53FkUvc+A9jGzXK4 # NDSYW4zT9Qim63jGUaANDm/0azxAGmAWLKkGUp0cE5DObwIe6nucs/b4l2DyZdHR # H4c6wXXwQo167Yxysnv7LIq0kUdU4i5pzBZUGlkwggTsMIID1KADAgECAhMzAAAA # ymzVMhI1xOFVAAEAAADKMA0GCSqGSIb3DQEBBQUAMHkxCzAJBgNVBAYTAlVTMRMw # EQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVN # aWNyb3NvZnQgQ29ycG9yYXRpb24xIzAhBgNVBAMTGk1pY3Jvc29mdCBDb2RlIFNp # Z25pbmcgUENBMB4XDTE0MDQyMjE3MzkwMFoXDTE1MDcyMjE3MzkwMFowgYMxCzAJ # BgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25k # MR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xDTALBgNVBAsTBE1PUFIx # HjAcBgNVBAMTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjCCASIwDQYJKoZIhvcNAQEB # BQADggEPADCCAQoCggEBAJZxXe0GRvqEy51bt0bHsOG0ETkDrbEVc2Cc66e2bho8 # P/9l4zTxpqUhXlaZbFjkkqEKXMLT3FIvDGWaIGFAUzGcbI8hfbr5/hNQUmCVOlu5 # WKV0YUGplOCtJk5MoZdwSSdefGfKTx5xhEa8HUu24g/FxifJB+Z6CqUXABlMcEU4 # LYG0UKrFZ9H6ebzFzKFym/QlNJj4VN8SOTgSL6RrpZp+x2LR3M/tPTT4ud81MLrs # eTKp4amsVU1Mf0xWwxMLdvEH+cxHrPuI1VKlHij6PS3Pz4SYhnFlEc+FyQlEhuFv # 57H8rEBEpamLIz+CSZ3VlllQE1kYc/9DDK0r1H8wQGcCAwEAAaOCAWAwggFcMBMG # A1UdJQQMMAoGCCsGAQUFBwMDMB0GA1UdDgQWBBQfXuJdUI1Whr5KPM8E6KeHtcu/ # gzBRBgNVHREESjBIpEYwRDENMAsGA1UECxMETU9QUjEzMDEGA1UEBRMqMzE1OTUr # YjQyMThmMTMtNmZjYS00OTBmLTljNDctM2ZjNTU3ZGZjNDQwMB8GA1UdIwQYMBaA # FMsR6MrStBZYAck3LjMWFrlMmgofMFYGA1UdHwRPME0wS6BJoEeGRWh0dHA6Ly9j # cmwubWljcm9zb2Z0LmNvbS9wa2kvY3JsL3Byb2R1Y3RzL01pY0NvZFNpZ1BDQV8w # OC0zMS0yMDEwLmNybDBaBggrBgEFBQcBAQROMEwwSgYIKwYBBQUHMAKGPmh0dHA6 # Ly93d3cubWljcm9zb2Z0LmNvbS9wa2kvY2VydHMvTWljQ29kU2lnUENBXzA4LTMx # LTIwMTAuY3J0MA0GCSqGSIb3DQEBBQUAA4IBAQB3XOvXkT3NvXuD2YWpsEOdc3wX # yQ/tNtvHtSwbXvtUBTqDcUCBCaK3cSZe1n22bDvJql9dAxgqHSd+B+nFZR+1zw23 # VMcoOFqI53vBGbZWMrrizMuT269uD11E9dSw7xvVTsGvDu8gm/Lh/idd6MX/YfYZ # 0igKIp3fzXCCnhhy2CPMeixD7v/qwODmHaqelzMAUm8HuNOIbN6kBjWnwlOGZRF3 # CY81WbnYhqgA/vgxfSz0jAWdwMHVd3Js6U1ZJoPxwrKIV5M1AHxQK7xZ/P4cKTiC # 095Sl0UpGE6WW526Xxuj8SdQ6geV6G00DThX3DcoNZU6OJzU7WqFXQ4iEV57MIIF # vDCCA6SgAwIBAgIKYTMmGgAAAAAAMTANBgkqhkiG9w0BAQUFADBfMRMwEQYKCZIm # iZPyLGQBGRYDY29tMRkwFwYKCZImiZPyLGQBGRYJbWljcm9zb2Z0MS0wKwYDVQQD # EyRNaWNyb3NvZnQgUm9vdCBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkwHhcNMTAwODMx # MjIxOTMyWhcNMjAwODMxMjIyOTMyWjB5MQswCQYDVQQGEwJVUzETMBEGA1UECBMK # V2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0 # IENvcnBvcmF0aW9uMSMwIQYDVQQDExpNaWNyb3NvZnQgQ29kZSBTaWduaW5nIFBD # QTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBALJyWVwZMGS/HZpgICBC # mXZTbD4b1m/My/Hqa/6XFhDg3zp0gxq3L6Ay7P/ewkJOI9VyANs1VwqJyq4gSfTw # aKxNS42lvXlLcZtHB9r9Jd+ddYjPqnNEf9eB2/O98jakyVxF3K+tPeAoaJcap6Vy # c1bxF5Tk/TWUcqDWdl8ed0WDhTgW0HNbBbpnUo2lsmkv2hkL/pJ0KeJ2L1TdFDBZ # +NKNYv3LyV9GMVC5JxPkQDDPcikQKCLHN049oDI9kM2hOAaFXE5WgigqBTK3S9dP # Y+fSLWLxRT3nrAgA9kahntFbjCZT6HqqSvJGzzc8OJ60d1ylF56NyxGPVjzBrAlf # A9MCAwEAAaOCAV4wggFaMA8GA1UdEwEB/wQFMAMBAf8wHQYDVR0OBBYEFMsR6MrS # tBZYAck3LjMWFrlMmgofMAsGA1UdDwQEAwIBhjASBgkrBgEEAYI3FQEEBQIDAQAB # MCMGCSsGAQQBgjcVAgQWBBT90TFO0yaKleGYYDuoMW+mPLzYLTAZBgkrBgEEAYI3 # FAIEDB4KAFMAdQBiAEMAQTAfBgNVHSMEGDAWgBQOrIJgQFYnl+UlE/wq4QpTlVnk # pDBQBgNVHR8ESTBHMEWgQ6BBhj9odHRwOi8vY3JsLm1pY3Jvc29mdC5jb20vcGtp # L2NybC9wcm9kdWN0cy9taWNyb3NvZnRyb290Y2VydC5jcmwwVAYIKwYBBQUHAQEE # SDBGMEQGCCsGAQUFBzAChjhodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpL2Nl # cnRzL01pY3Jvc29mdFJvb3RDZXJ0LmNydDANBgkqhkiG9w0BAQUFAAOCAgEAWTk+ # fyZGr+tvQLEytWrrDi9uqEn361917Uw7LddDrQv+y+ktMaMjzHxQmIAhXaw9L0y6 # oqhWnONwu7i0+Hm1SXL3PupBf8rhDBdpy6WcIC36C1DEVs0t40rSvHDnqA2iA6VW # 4LiKS1fylUKc8fPv7uOGHzQ8uFaa8FMjhSqkghyT4pQHHfLiTviMocroE6WRTsgb # 0o9ylSpxbZsa+BzwU9ZnzCL/XB3Nooy9J7J5Y1ZEolHN+emjWFbdmwJFRC9f9Nqu # 1IIybvyklRPk62nnqaIsvsgrEA5ljpnb9aL6EiYJZTiU8XofSrvR4Vbo0HiWGFzJ # NRZf3ZMdSY4tvq00RBzuEBUaAF3dNVshzpjHCe6FDoxPbQ4TTj18KUicctHzbMrB # 7HCjV5JXfZSNoBtIA1r3z6NnCnSlNu0tLxfI5nI3EvRvsTxngvlSso0zFmUeDord # EN5k9G/ORtTTF+l5xAS00/ss3x+KnqwK+xMnQK3k+eGpf0a7B2BHZWBATrBC7E7t # s3Z52Ao0CW0cgDEf4g5U3eWh++VHEK1kmP9QFi58vwUheuKVQSdpw5OPlcmN2Jsh # rg1cnPCiroZogwxqLbt2awAdlq3yFnv2FoMkuYjPaqhHMS+a3ONxPdcAfmJH0c6I # ybgY+g5yjcGjPa8CQGr/aZuW4hCoELQ3UAjWwz0wggYHMIID76ADAgECAgphFmg0 # AAAAAAAcMA0GCSqGSIb3DQEBBQUAMF8xEzARBgoJkiaJk/IsZAEZFgNjb20xGTAX # BgoJkiaJk/IsZAEZFgltaWNyb3NvZnQxLTArBgNVBAMTJE1pY3Jvc29mdCBSb290 # IENlcnRpZmljYXRlIEF1dGhvcml0eTAeFw0wNzA0MDMxMjUzMDlaFw0yMTA0MDMx # MzAzMDlaMHcxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYD # VQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xITAf # BgNVBAMTGE1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQTCCASIwDQYJKoZIhvcNAQEB # BQADggEPADCCAQoCggEBAJ+hbLHf20iSKnxrLhnhveLjxZlRI1Ctzt0YTiQP7tGn # 0UytdDAgEesH1VSVFUmUG0KSrphcMCbaAGvoe73siQcP9w4EmPCJzB/LMySHnfL0 # Zxws/HvniB3q506jocEjU8qN+kXPCdBer9CwQgSi+aZsk2fXKNxGU7CG0OUoRi4n # rIZPVVIM5AMs+2qQkDBuh/NZMJ36ftaXs+ghl3740hPzCLdTbVK0RZCfSABKR2YR # JylmqJfk0waBSqL5hKcRRxQJgp+E7VV4/gGaHVAIhQAQMEbtt94jRrvELVSfrx54 # QTF3zJvfO4OToWECtR0Nsfz3m7IBziJLVP/5BcPCIAsCAwEAAaOCAaswggGnMA8G # A1UdEwEB/wQFMAMBAf8wHQYDVR0OBBYEFCM0+NlSRnAK7UD7dvuzK7DDNbMPMAsG # A1UdDwQEAwIBhjAQBgkrBgEEAYI3FQEEAwIBADCBmAYDVR0jBIGQMIGNgBQOrIJg # QFYnl+UlE/wq4QpTlVnkpKFjpGEwXzETMBEGCgmSJomT8ixkARkWA2NvbTEZMBcG # CgmSJomT8ixkARkWCW1pY3Jvc29mdDEtMCsGA1UEAxMkTWljcm9zb2Z0IFJvb3Qg # Q2VydGlmaWNhdGUgQXV0aG9yaXR5ghB5rRahSqClrUxzWPQHEy5lMFAGA1UdHwRJ # MEcwRaBDoEGGP2h0dHA6Ly9jcmwubWljcm9zb2Z0LmNvbS9wa2kvY3JsL3Byb2R1 # Y3RzL21pY3Jvc29mdHJvb3RjZXJ0LmNybDBUBggrBgEFBQcBAQRIMEYwRAYIKwYB # BQUHMAKGOGh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2kvY2VydHMvTWljcm9z # b2Z0Um9vdENlcnQuY3J0MBMGA1UdJQQMMAoGCCsGAQUFBwMIMA0GCSqGSIb3DQEB # BQUAA4ICAQAQl4rDXANENt3ptK132855UU0BsS50cVttDBOrzr57j7gu1BKijG1i # uFcCy04gE1CZ3XpA4le7r1iaHOEdAYasu3jyi9DsOwHu4r6PCgXIjUji8FMV3U+r # kuTnjWrVgMHmlPIGL4UD6ZEqJCJw+/b85HiZLg33B+JwvBhOnY5rCnKVuKE5nGct # xVEO6mJcPxaYiyA/4gcaMvnMMUp2MT0rcgvI6nA9/4UKE9/CCmGO8Ne4F+tOi3/F # NSteo7/rvH0LQnvUU3Ih7jDKu3hlXFsBFwoUDtLaFJj1PLlmWLMtL+f5hYbMUVbo # nXCUbKw5TNT2eb+qGHpiKe+imyk0BncaYsk9Hm0fgvALxyy7z0Oz5fnsfbXjpKh0 # NbhOxXEjEiZ2CzxSjHFaRkMUvLOzsE1nyJ9C/4B5IYCeFTBm6EISXhrIniIh0EPp # K+m79EjMLNTYMoBMJipIJF9a6lbvpt6Znco6b72BJ3QGEe52Ib+bgsEnVLaxaj2J # oXZhtG6hE6a/qkfwEm/9ijJssv7fUciMI8lmvZ0dhxJkAj0tr1mPuOQh5bWwymO0 # eFQF1EEuUKyUsKV4q7OglnUa2ZKHE3UiLzKoCG6gW4wlv6DvhMoh1useT8ma7kng # 9wFlb4kLfchpyOZu6qeXzjEp/w7FW1zYTRuh2Povnj8uVRZryROj/TGCBKUwggSh # AgEBMIGQMHkxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYD # VQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xIzAh # BgNVBAMTGk1pY3Jvc29mdCBDb2RlIFNpZ25pbmcgUENBAhMzAAAAymzVMhI1xOFV # AAEAAADKMAkGBSsOAwIaBQCggb4wGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQw # HAYKKwYBBAGCNwIBCzEOMAwGCisGAQQBgjcCARUwIwYJKoZIhvcNAQkEMRYEFJwq # XewJzQK22hN1654vAFXY7RyTMF4GCisGAQQBgjcCAQwxUDBOoCaAJABTAHQAbwBy # AGUAVABTAEwAaQBiAHIAYQByAHkALgBwAHMAMaEkgCJodHRwOi8vd3d3Lm1pY3Jv # c29mdC5jb20vZXhjaGFuZ2UgMA0GCSqGSIb3DQEBAQUABIIBAJRC54tfxCjSADMH # Qn2PyBm07bNVOXofAdG1NTeYLSiYqdztiSsuKhBoOyWnBENAnPB0cwl5GSfNjVRR # UZqXm9O5Uwg0p092pwTAU4nJ4WYZb47eeSHYnQYybevM8t/6iF2Kh2BfYDlZq2Ze # 2zV0FOBWCkT0unRZSeUrrGlMGaLyeGkdYMjOmOCPQG9giN1SyslIVVPisb8fTNO5 # /G3quFo9foCGktlsKNBuXff2kXI1NOJXKiDfwLmNauarcYzL0S8W/3KG8lqcqt7j # vDKvKcPZW6wtB4/cn4u5U9Tn82lUqpfYsA8xBNYExJJgHNXXXfzQ8BJVX4wieqnI # t2w1gCmhggIoMIICJAYJKoZIhvcNAQkGMYICFTCCAhECAQEwgY4wdzELMAkGA1UE # BhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAc # BgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEhMB8GA1UEAxMYTWljcm9zb2Z0 # IFRpbWUtU3RhbXAgUENBAhMzAAAATKHoTcy0dHs7AAAAAABMMAkGBSsOAwIaBQCg # XTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0xNDA4 # MTcwNTEyMjVaMCMGCSqGSIb3DQEJBDEWBBScqUspED2TrhoaC3OCdDcjDbyZxjAN # BgkqhkiG9w0BAQUFAASCAQABQpBAruApDxCWOs+QQNwyRdkPIgR1MHRurP26jVKx # KUWGtVYWoRVfrFnzpG1QNGTkCFFlS+D4Vd8TMSkXvQ3+po4L82+CVsZKtueZLMBE # DgalFpvWsNrUaV21n1e8bP3oaVuArimFxljwUD3Bdg0WqyGDlMiGul5lsuDBiliL # +nXFl8gv+993OZ6ggzt9yPIvCCy0yLiAPN33wDDw0jumykOihPi9SyPgEpJS4Mv9 # v7+0Ab90lv1FP2m/dXQ5GK9hwXxw2CPvP28fEhiNLxSScT6cC8DAgT4EmV8dtWy6 # SPDyi90SgvxgAlv2tDmZZU704mA60+pfPiI2Nzo2Sub4 # SIG # End signature block