dbatools

1.1.110

internal/functions/Get-SQLInstanceComponent.ps1

                                function Get-SQLInstanceComponent {

    <#

    .SYNOPSIS

        Retrieves SQL server information from a local or remote servers.

    .DESCRIPTION

        Retrieves SQL server information from a local or remote servers. Pulls all instances from a SQL server and

        detects if in a cluster or not.

    .PARAMETER ComputerName

        Local or remote systems to query for SQL information.

    .NOTES

        Tags: Install, Patching, SP, CU, Instance

        Author: Kirill Kravtsov (@nvarscar) https://nvarscar.wordpress.com/

        Based on https://github.com/adbertram/PSSqlUpdater

        The majority of this function was created by Boe Prox.

    .EXAMPLE

        Get-SQLInstanceComponent -ComputerName SQL01 -Component SSDS

        ComputerName  : BDT005-BT-SQL

        InstanceType  : Database Engine

        InstanceName  : MSSQLSERVER

        InstanceID    : MSSQL11.MSSQLSERVER

        Edition       : Enterprise Edition

        Version       : 11.1.3000.0

        Caption       : SQL Server 2012

        IsCluster     : False

        IsClusterNode : False

        ClusterName   :

        ClusterNodes  : {}

        FullName      : BDT005-BT-SQL

        Description

        -----------

        Retrieves the SQL instance information from SQL01 for component type SSDS (Database Engine).

    .EXAMPLE

        Get-SQLInstanceComponent -ComputerName SQL01

        ComputerName  : BDT005-BT-SQL

        InstanceType  : Analysis Services

        InstanceName  : MSSQLSERVER

        InstanceID    : MSAS11.MSSQLSERVER

        Edition       : Enterprise Edition

        Version       : 11.1.3000.0

        Caption       : SQL Server 2012

        IsCluster     : False

        IsClusterNode : False

        ClusterName   :

        ClusterNodes  : {}

        FullName      : BDT005-BT-SQL

        ComputerName  : BDT005-BT-SQL

        InstanceType  : Reporting Services

        InstanceName  : MSSQLSERVER

        InstanceID    : MSRS11.MSSQLSERVER

        Edition       : Enterprise Edition

        Version       : 11.1.3000.0

        Caption       : SQL Server 2012

        IsCluster     : False

        IsClusterNode : False

        ClusterName   :

        ClusterNodes  : {}

        FullName      : BDT005-BT-SQL

        Description

        -----------

        Retrieves the SQL instance information from SQL01 for all component types (SSAS, SSDS, SSRS).

    #>

    [CmdletBinding()]

    param

    (

        [Parameter(ValueFromPipeline, ValueFromPipelineByPropertyName)]

        [Alias('Computer', 'DNSHostName', 'IPAddress')]

        [DbaInstanceParameter[]]$ComputerName = $Env:COMPUTERNAME,

        [ValidateSet('SSDS', 'SSAS', 'SSRS')]

        [string[]]$Component = @('SSDS', 'SSAS', 'SSRS'),

        [pscredential]$Credential

    )

    begin {

        $regScript = {

            Param (

                $ComponentObject

            )

            $Component = $ComponentObject.Component

            $componentNameMap = @(

                [pscustomobject]@{

                    ComponentName = 'SSAS';

                    DisplayName   = 'Analysis Services';

                    RegKeyName    = "OLAP";

                },

                [pscustomobject]@{

                    ComponentName = 'SSDS';

                    DisplayName   = 'Database Engine';

                    RegKeyName    = 'SQL';

                },

                [pscustomobject]@{

                    ComponentName = 'SSRS';

                    DisplayName   = 'Reporting Services';

                    RegKeyName    = 'RS';

                }

            );

            function Get-SQLInstanceDetail {

                <#

                    .SYNOPSIS

                        The majority of this function was created by Boe Prox.

                #>

                param

                (

                    [Parameter(Mandatory, ValueFromPipeline, ValueFromPipelineByPropertyName)]

                    [string[]]$Instance,

                    [Parameter(Mandatory)]

                    [ValidateNotNullOrEmpty()]

                    [Microsoft.Win32.RegistryKey]$RegKey,

                    [Parameter(Mandatory)]

                    [ValidateNotNullOrEmpty()]

                    [Microsoft.Win32.RegistryKey]$reg,

                    [Parameter(Mandatory)]

                    [ValidateNotNullOrEmpty()]

                    [string]$RegPath

                )

                process {

                    #region Process each instance

                    foreach ($sqlInstance in $Instance) {

                        $log = @()

                        $nodes = New-Object System.Collections.ArrayList;

                        $clusterName = $null;

                        $isCluster = $false;

                        $instanceValue = $regKey.GetValue($sqlInstance);

                        $log += "Working with $regPath\$instanceValue on $computer"

                        $instanceReg = $reg.OpenSubKey("$regPath\\$instanceValue");

                        if ($instanceReg.GetSubKeyNames() -contains 'Cluster') {

                            $isCluster = $true;

                            $instanceRegCluster = $instanceReg.OpenSubKey('Cluster');

                            $clusterName = $instanceRegCluster.GetValue('ClusterName');

                            #Write-Message -Level Verbose -Message "Getting cluster node names";

                            $clusterReg = $reg.OpenSubKey("Cluster\\Nodes");

                            $clusterNodes = $clusterReg.GetSubKeyNames();

                            if ($clusterNodes) {

                                foreach ($clusterNode in $clusterNodes) {

                                    $null = $nodes.Add($clusterReg.OpenSubKey($clusterNode).GetValue("NodeName").ToUpper());

                                }

                            }

                        }

                        #region Gather additional information about SQL instance

                        $instanceRegSetup = $instanceReg.OpenSubKey("Setup")

                        #region Get SQL instance directory

                        try {

                            $instanceDir = $instanceRegSetup.GetValue("SqlProgramDir");

                            if (([System.IO.Path]::GetPathRoot($instanceDir) -ne $instanceDir) -and $instanceDir.EndsWith("\")) {

                                $instanceDir = $instanceDir.Substring(0, $instanceDir.Length - 1);

                            }

                        } catch {

                            $instanceDir = $null;

                        }

                        #endregion Get SQL instance directory

                        #region Get SQL edition

                        try {

                            $edition = $instanceRegSetup.GetValue("Edition");

                        } catch {

                            $edition = $null;

                        }

                        #endregion Get SQL edition

                        #region Get resume value

                        try {

                            $resume = [bool][int]$instanceRegSetup.GetValue("Resume");

                        } catch {

                            $resume = $false;

                        }

                        #endregion Get resume value

                        #region Get SQL version

                        $version = $null

                        try {

                            $versionHash = @{

                                '11' = 'SQLServer2012'

                                '12' = 'SQLServer2014'

                                '13' = 'SQLServer2016'

                                '14' = 'SQL2017'

                                '15' = 'SQL2019'

                            }

                            $version = $instanceRegSetup.GetValue("Version");

                            $log += "Found version $version"

                            if ($patchVersion = $instanceRegSetup.GetValue("PatchLevel")) {

                                $log += "Using patch version $patchVersion over $version"

                                $version = $patchVersion

                            }

                            # if patch version is not available - use global reg node to extract the latest patch

                            $majorVersion = $version.Split('.')[0]

                            if (!$patchVersion -and $majorVersion -and $versionHash[$majorVersion]) {

                                $verKey = $reg.OpenSubKey("SOFTWARE\\Microsoft\\Microsoft SQL Server\\$($majorVersion)0\\$($versionHash[$majorVersion])\\CurrentVersion")

                                $version = $verKey.GetValue('Version')

                                $log += "New version from the CurrentVersion key: $version"

                            }

                        } catch {

                            $log += "Failed to read one of the reg keys, found version $version so far"

                        }

                        #endregion Get SQL version

                        #region Get exe version

                        try {

                            # attempt to recover a real version of a sqlservr.exe by getting file properties from a remote machine

                            # not sure how to support SSRS/SSAS, as SSDS is the only one that has binary path in the Setup node

                            if ($binRoot = $instanceRegSetup.GetValue("SQLBinRoot")) {

                                $fileVersion = (Get-Item -Path (Join-Path $binRoot "sqlservr.exe") -ErrorAction Stop).VersionInfo.ProductVersion

                                if ($fileVersion) {

                                    $version = $fileVersion

                                    $log += "New version from the binary file: $version"

                                }

                            }

                        } catch {

                            $log += "Failed to get exe version, leaving $version as is"

                        }

                        #endregion Get exe version

                        #endregion Gather additional information about SQL instance

                        #region Generate return object

                        [pscustomobject]@{

                            ComputerName  = $computer.ToUpper();

                            InstanceName  = $sqlInstance;

                            InstanceID    = $instanceValue;

                            InstanceDir   = $instanceDir;

                            Edition       = $edition;

                            Version       = $version;

                            Caption       = {

                                switch -regex ($version) {

                                    "^11" { "SQL Server 2012"; break }

                                    "^10\.5" { "SQL Server 2008 R2"; break }

                                    "^10" { "SQL Server 2008"; break }

                                    "^9" { "SQL Server 2005"; break }

                                    "^8" { "SQL Server 2000"; break }

                                    default { "Unknown"; }

                                }

                            }.InvokeReturnAsIs();

                            IsCluster     = $isCluster;

                            IsClusterNode = ($nodes -contains $computer);

                            ClusterName   = $clusterName;

                            ClusterNodes  = ($nodes -ne $computer);

                            FullName      = {

                                if ($sqlInstance -eq "MSSQLSERVER") {

                                    $computer.ToUpper();

                                } else {

                                    "$($computer.ToUpper())\$($sqlInstance)";

                                }

                            }.InvokeReturnAsIs();

                            Log           = $log

                            Resume        = $resume

                        }

                        #endregion Generate return object

                    }

                    #endregion Process each instance

                }

            }

            $reg = [Microsoft.Win32.RegistryKey]::OpenBaseKey('LocalMachine', 'Default')

            $baseKeys = "SOFTWARE\\Microsoft\\Microsoft SQL Server", "SOFTWARE\\Wow6432Node\\Microsoft\\Microsoft SQL Server";

            if ($reg.OpenSubKey($baseKeys[0])) {

                $regPath = $baseKeys[0];

            } elseif ($reg.OpenSubKey($baseKeys[1])) {

                $regPath = $baseKeys[1];

            } else {

                throw "Failed to find any regkeys on $env:computername"

            }

            $computer = $Env:COMPUTERNAME

            $regKey = $reg.OpenSubKey("$regPath");

            if ($regKey.GetSubKeyNames() -contains "Instance Names") {

                foreach ($componentName in $Component) {

                    $componentRegKeyName = $componentNameMap |

                        Where-Object { $_.ComponentName -eq $componentName } |

                        Select-Object -ExpandProperty RegKeyName;

                    $regKey = $reg.OpenSubKey("$regPath\\Instance Names\\{0}" -f $componentRegKeyName);

                    if ($regKey) {

                        foreach ($regValueName in $regKey.GetValueNames()) {

                            if ($componentRegKeyName -eq 'RS' -and $regValueName -eq 'PBIRS') { continue } #filtering out Power BI - not supported

                            if ($componentRegKeyName -eq 'RS' -and $regValueName -eq 'SSRS') { continue }  #filtering out SSRS2017+ - not supported

                            $result = Get-SQLInstanceDetail -RegPath $regPath -Reg $reg -RegKey $regKey -Instance $regValueName;

                            $result | Add-Member -Type NoteProperty -Name InstanceType -Value ($componentNameMap | Where-Object { $_.ComponentName -eq $componentName }).DisplayName -PassThru

                        }

                    }

                }

            } elseif ($regKey.GetValueNames() -contains 'InstalledInstances') {

                $isCluster = $false;

                $regKey.GetValue('InstalledInstances') | ForEach-Object {

                    Get-SQLInstanceDetail -RegPath $regPath -Reg $reg -RegKey $regKey -Instance $_

                };

            } else {

                throw "Failed to find any instance names on $env:computername"

            }

        }

    }

    process {

        foreach ($computer in $ComputerName) {

            $arguments = @{ Component = $Component }

            $results = Invoke-Command2 -ComputerName $computer -ScriptBlock $regScript -Credential $Credential -ErrorAction Stop -Raw -ArgumentList $arguments -RequiredPSVersion 3.0

            # Log is stored in the log property, pile it all into the debug log

            foreach ($logEntry in $results.Log) {

                Write-Message -Level Debug -Message $logEntry

            }

            foreach ($result in $results) {

                # If version is unknown that component should be excluded, otherwise it would fail on conversion. We have no use for versionless components anyways.

                if (-Not $result.Version) {

                    Write-Message -Level Warning -Message "Component $($result.InstanceName) on $($result.ComputerName) has an unknown version and was ommitted from the instance list"

                    continue

                }

                # Replace first decimal of the minor build with a 0, since we're using build numbers here

                # Refer to https://sqlserverbuilds.blogspot.com/

                Write-Message -Level Debug -Message "Converting version $($result.Version) to [version]"

                $newVersion = New-Object -TypeName System.Version -ArgumentList ([string]$result.Version)

                $newVersion = New-Object -TypeName System.Version -ArgumentList ($newVersion.Major , ($newVersion.Minor - $newVersion.Minor % 10), $newVersion.Build)

                Write-Message -Level Debug -Message "Converted version $($result.Version) to $newVersion"

                # Find a proper build reference and replace Version property

                $result.Version = Get-DbaBuild -Build $newVersion -EnableException

                $result | Select-Object -ExcludeProperty Log

            }

        }

    }

}

# SIG # Begin signature block

# MIIjigYJKoZIhvcNAQcCoIIjezCCI3cCAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCAWpbTitPuok450

# fcU8XGmd6napXmMXvZFq41IW1dWpdqCCHYMwggUaMIIEAqADAgECAhADBbuGIbCh

# Y1+/3q4SBOdtMA0GCSqGSIb3DQEBCwUAMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQK

# EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNV

# BAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwHhcN

# MjAwNTEyMDAwMDAwWhcNMjMwNjA4MTIwMDAwWjBXMQswCQYDVQQGEwJVUzERMA8G

# A1UECBMIVmlyZ2luaWExDzANBgNVBAcTBlZpZW5uYTERMA8GA1UEChMIZGJhdG9v

# bHMxETAPBgNVBAMTCGRiYXRvb2xzMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIB

# CgKCAQEAvL9je6vjv74IAbaY5rXqHxaNeNJO9yV0ObDg+kC844Io2vrHKGD8U5hU

# iJp6rY32RVprnAFrA4jFVa6P+sho7F5iSVAO6A+QZTHQCn7oquOefGATo43NAadz

# W2OWRro3QprMPZah0QFYpej9WaQL9w/08lVaugIw7CWPsa0S/YjHPGKQ+bYgI/kr

# EUrk+asD7lvNwckR6pGieWAyf0fNmSoevQBTV6Cd8QiUfj+/qWvLW3UoEX9ucOGX

# 2D8vSJxL7JyEVWTHg447hr6q9PzGq+91CO/c9DWFvNMjf+1c5a71fEZ54h1mNom/

# XoWZYoKeWhKnVdv1xVT1eEimibPEfQIDAQABo4IBxTCCAcEwHwYDVR0jBBgwFoAU

# WsS5eyoKo6XqcQPAYPkt9mV1DlgwHQYDVR0OBBYEFPDAoPu2A4BDTvsJ193ferHL

# 454iMA4GA1UdDwEB/wQEAwIHgDATBgNVHSUEDDAKBggrBgEFBQcDAzB3BgNVHR8E

# cDBuMDWgM6Axhi9odHRwOi8vY3JsMy5kaWdpY2VydC5jb20vc2hhMi1hc3N1cmVk

# LWNzLWcxLmNybDA1oDOgMYYvaHR0cDovL2NybDQuZGlnaWNlcnQuY29tL3NoYTIt

# YXNzdXJlZC1jcy1nMS5jcmwwTAYDVR0gBEUwQzA3BglghkgBhv1sAwEwKjAoBggr

# BgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNlcnQuY29tL0NQUzAIBgZngQwBBAEw

# gYQGCCsGAQUFBwEBBHgwdjAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNl

# cnQuY29tME4GCCsGAQUFBzAChkJodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20v

# RGlnaUNlcnRTSEEyQXNzdXJlZElEQ29kZVNpZ25pbmdDQS5jcnQwDAYDVR0TAQH/

# BAIwADANBgkqhkiG9w0BAQsFAAOCAQEAj835cJUMH9Y2pBKspjznNJwcYmOxeBcH

# Ji+yK0y4bm+j44OGWH4gu/QJM+WjZajvkydJKoJZH5zrHI3ykM8w8HGbYS1WZfN4

# oMwi51jKPGZPw9neGS2PXrBcKjzb7rlQ6x74Iex+gyf8z1ZuRDitLJY09FEOh0BM

# LaLh+UvJ66ghmfIyjP/g3iZZvqwgBhn+01fObqrAJ+SagxJ/21xNQJchtUOWIlxR

# kuUn9KkuDYrMO70a2ekHODcAbcuHAGI8wzw4saK1iPPhVTlFijHS+7VfIt/d/18p

# MLHHArLQQqe1Z0mTfuL4M4xCUKpebkH8rI3Fva62/6osaXLD0ymERzCCBTAwggQY

# oAMCAQICEAQJGBtf1btmdVNDtW+VUAgwDQYJKoZIhvcNAQELBQAwZTELMAkGA1UE

# BhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2lj

# ZXJ0LmNvbTEkMCIGA1UEAxMbRGlnaUNlcnQgQXNzdXJlZCBJRCBSb290IENBMB4X

# DTEzMTAyMjEyMDAwMFoXDTI4MTAyMjEyMDAwMFowcjELMAkGA1UEBhMCVVMxFTAT

# BgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTEx

# MC8GA1UEAxMoRGlnaUNlcnQgU0hBMiBBc3N1cmVkIElEIENvZGUgU2lnbmluZyBD

# QTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAPjTsxx/DhGvZ3cH0wsx

# SRnP0PtFmbE620T1f+Wondsy13Hqdp0FLreP+pJDwKX5idQ3Gde2qvCchqXYJawO

# eSg6funRZ9PG+yknx9N7I5TkkSOWkHeC+aGEI2YSVDNQdLEoJrskacLCUvIUZ4qJ

# RdQtoaPpiCwgla4cSocI3wz14k1gGL6qxLKucDFmM3E+rHCiq85/6XzLkqHlOzEc

# z+ryCuRXu0q16XTmK/5sy350OTYNkO/ktU6kqepqCquE86xnTrXE94zRICUj6whk

# PlKWwfIPEvTFjg/BougsUfdzvL2FsWKDc0GCB+Q4i2pzINAPZHM8np+mM6n9Gd8l

# k9ECAwEAAaOCAc0wggHJMBIGA1UdEwEB/wQIMAYBAf8CAQAwDgYDVR0PAQH/BAQD

# AgGGMBMGA1UdJQQMMAoGCCsGAQUFBwMDMHkGCCsGAQUFBwEBBG0wazAkBggrBgEF

# BQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tMEMGCCsGAQUFBzAChjdodHRw

# Oi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0Eu

# Y3J0MIGBBgNVHR8EejB4MDqgOKA2hjRodHRwOi8vY3JsNC5kaWdpY2VydC5jb20v

# RGlnaUNlcnRBc3N1cmVkSURSb290Q0EuY3JsMDqgOKA2hjRodHRwOi8vY3JsMy5k

# aWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0EuY3JsME8GA1UdIARI

# MEYwOAYKYIZIAYb9bAACBDAqMCgGCCsGAQUFBwIBFhxodHRwczovL3d3dy5kaWdp

# Y2VydC5jb20vQ1BTMAoGCGCGSAGG/WwDMB0GA1UdDgQWBBRaxLl7KgqjpepxA8Bg

# +S32ZXUOWDAfBgNVHSMEGDAWgBRF66Kv9JLLgjEtUYunpyGd823IDzANBgkqhkiG

# 9w0BAQsFAAOCAQEAPuwNWiSz8yLRFcgsfCUpdqgdXRwtOhrE7zBh134LYP3DPQ/E

# r4v97yrfIFU3sOH20ZJ1D1G0bqWOWuJeJIFOEKTuP3GOYw4TS63XX0R58zYUBor3

# nEZOXP+QsRsHDpEV+7qvtVHCjSSuJMbHJyqhKSgaOnEoAjwukaPAJRHinBRHoXpo

# aK+bp1wgXNlxsQyPu6j4xRJon89Ay0BEpRPw5mQMJQhCMrI2iiQC/i9yfhzXSUWW

# 6Fkd6fp0ZGuy62ZD2rOwjNXpDd32ASDOmTFjPQgaGLOBm0/GkxAG/AeB+ova+YJJ

# 92JuoVP6EpQYhS6SkepobEQysmah5xikmmRR7zCCBbEwggSZoAMCAQICEAEkCvse

# OAuKFvFLcZ3008AwDQYJKoZIhvcNAQEMBQAwZTELMAkGA1UEBhMCVVMxFTATBgNV

# BAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTEkMCIG

# A1UEAxMbRGlnaUNlcnQgQXNzdXJlZCBJRCBSb290IENBMB4XDTIyMDYwOTAwMDAw

# MFoXDTMxMTEwOTIzNTk1OVowYjELMAkGA1UEBhMCVVMxFTATBgNVBAoTDERpZ2lD

# ZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTEhMB8GA1UEAxMYRGln

# aUNlcnQgVHJ1c3RlZCBSb290IEc0MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIIC

# CgKCAgEAv+aQc2jeu+RdSjwwIjBpM+zCpyUuySE98orYWcLhKac9WKt2ms2uexuE

# DcQwH/MbpDgW61bGl20dq7J58soR0uRf1gU8Ug9SH8aeFaV+vp+pVxZZVXKvaJNw

# wrK6dZlqczKU0RBEEC7fgvMHhOZ0O21x4i0MG+4g1ckgHWMpLc7sXk7Ik/ghYZs0

# 6wXGXuxbGrzryc/NrDRAX7F6Zu53yEioZldXn1RYjgwrt0+nMNlW7sp7XeOtyU9e

# 5TXnMcvak17cjo+A2raRmECQecN4x7axxLVqGDgDEI3Y1DekLgV9iPWCPhCRcKtV

# gkEy19sEcypukQF8IUzUvK4bA3VdeGbZOjFEmjNAvwjXWkmkwuapoGfdpCe8oU85

# tRFYF/ckXEaPZPfBaYh2mHY9WV1CdoeJl2l6SPDgohIbZpp0yt5LHucOY67m1O+S

# kjqePdwA5EUlibaaRBkrfsCUtNJhbesz2cXfSwQAzH0clcOP9yGyshG3u3/y1Yxw

# LEFgqrFjGESVGnZifvaAsPvoZKYz0YkH4b235kOkGLimdwHhD5QMIR2yVCkliWzl

# DlJRR3S+Jqy2QXXeeqxfjT/JvNNBERJb5RBQ6zHFynIWIgnffEx1P2PsIV/EIFFr

# b7GrhotPwtZFX50g/KEexcCPorF+CiaZ9eRpL5gdLfXZqbId5RsCAwEAAaOCAV4w

# ggFaMA8GA1UdEwEB/wQFMAMBAf8wHQYDVR0OBBYEFOzX44LScV1kTN8uZz/nupiu

# HA9PMB8GA1UdIwQYMBaAFEXroq/0ksuCMS1Ri6enIZ3zbcgPMA4GA1UdDwEB/wQE

# AwIBhjATBgNVHSUEDDAKBggrBgEFBQcDCDB5BggrBgEFBQcBAQRtMGswJAYIKwYB

# BQUHMAGGGGh0dHA6Ly9vY3NwLmRpZ2ljZXJ0LmNvbTBDBggrBgEFBQcwAoY3aHR0

# cDovL2NhY2VydHMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENB

# LmNydDBFBgNVHR8EPjA8MDqgOKA2hjRodHRwOi8vY3JsMy5kaWdpY2VydC5jb20v

# RGlnaUNlcnRBc3N1cmVkSURSb290Q0EuY3JsMCAGA1UdIAQZMBcwCAYGZ4EMAQQC

# MAsGCWCGSAGG/WwHATANBgkqhkiG9w0BAQwFAAOCAQEAmhYCpQHvgfsNtFiyeK2o

# IxnZczfaYJ5R18v4L0C5ox98QE4zPpA854kBdYXoYnsdVuBxut5exje8eVxiAE34

# SXpRTQYy88XSAConIOqJLhU54Cw++HV8LIJBYTUPI9DtNZXSiJUpQ8vgplgQfFOO

# n0XJIDcUwO0Zun53OdJUlsemEd80M/Z1UkJLHJ2NltWVbEcSFCRfJkH6Gka93rDl

# kUcDrBgIy8vbZol/K5xlv743Tr4t851Kw8zMR17IlZWt0cu7KgYg+T9y6jbrRXKS

# eil7FAM8+03WSHF6EBGKCHTNbBsEXNKKlQN2UVBT1i73SkbDrhAscUywh7YnN0Rg

# RDCCBq4wggSWoAMCAQICEAc2N7ckVHzYR6z9KGYqXlswDQYJKoZIhvcNAQELBQAw

# YjELMAkGA1UEBhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQ

# d3d3LmRpZ2ljZXJ0LmNvbTEhMB8GA1UEAxMYRGlnaUNlcnQgVHJ1c3RlZCBSb290

# IEc0MB4XDTIyMDMyMzAwMDAwMFoXDTM3MDMyMjIzNTk1OVowYzELMAkGA1UEBhMC

# VVMxFzAVBgNVBAoTDkRpZ2lDZXJ0LCBJbmMuMTswOQYDVQQDEzJEaWdpQ2VydCBU

# cnVzdGVkIEc0IFJTQTQwOTYgU0hBMjU2IFRpbWVTdGFtcGluZyBDQTCCAiIwDQYJ

# KoZIhvcNAQEBBQADggIPADCCAgoCggIBAMaGNQZJs8E9cklRVcclA8TykTepl1Gh

# 1tKD0Z5Mom2gsMyD+Vr2EaFEFUJfpIjzaPp985yJC3+dH54PMx9QEwsmc5Zt+Feo

# An39Q7SE2hHxc7Gz7iuAhIoiGN/r2j3EF3+rGSs+QtxnjupRPfDWVtTnKC3r07G1

# decfBmWNlCnT2exp39mQh0YAe9tEQYncfGpXevA3eZ9drMvohGS0UvJ2R/dhgxnd

# X7RUCyFobjchu0CsX7LeSn3O9TkSZ+8OpWNs5KbFHc02DVzV5huowWR0QKfAcsW6

# Th+xtVhNef7Xj3OTrCw54qVI1vCwMROpVymWJy71h6aPTnYVVSZwmCZ/oBpHIEPj

# Q2OAe3VuJyWQmDo4EbP29p7mO1vsgd4iFNmCKseSv6De4z6ic/rnH1pslPJSlREr

# WHRAKKtzQ87fSqEcazjFKfPKqpZzQmiftkaznTqj1QPgv/CiPMpC3BhIfxQ0z9JM

# q++bPf4OuGQq+nUoJEHtQr8FnGZJUlD0UfM2SU2LINIsVzV5K6jzRWC8I41Y99xh

# 3pP+OcD5sjClTNfpmEpYPtMDiP6zj9NeS3YSUZPJjAw7W4oiqMEmCPkUEBIDfV8j

# u2TjY+Cm4T72wnSyPx4JduyrXUZ14mCjWAkBKAAOhFTuzuldyF4wEr1GnrXTdrnS

# DmuZDNIztM2xAgMBAAGjggFdMIIBWTASBgNVHRMBAf8ECDAGAQH/AgEAMB0GA1Ud

# DgQWBBS6FtltTYUvcyl2mi91jGogj57IbzAfBgNVHSMEGDAWgBTs1+OC0nFdZEzf

# Lmc/57qYrhwPTzAOBgNVHQ8BAf8EBAMCAYYwEwYDVR0lBAwwCgYIKwYBBQUHAwgw

# dwYIKwYBBQUHAQEEazBpMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdpY2Vy

# dC5jb20wQQYIKwYBBQUHMAKGNWh0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9E

# aWdpQ2VydFRydXN0ZWRSb290RzQuY3J0MEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6

# Ly9jcmwzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydFRydXN0ZWRSb290RzQuY3JsMCAG

# A1UdIAQZMBcwCAYGZ4EMAQQCMAsGCWCGSAGG/WwHATANBgkqhkiG9w0BAQsFAAOC

# AgEAfVmOwJO2b5ipRCIBfmbW2CFC4bAYLhBNE88wU86/GPvHUF3iSyn7cIoNqilp

# /GnBzx0H6T5gyNgL5Vxb122H+oQgJTQxZ822EpZvxFBMYh0MCIKoFr2pVs8Vc40B

# IiXOlWk/R3f7cnQU1/+rT4osequFzUNf7WC2qk+RZp4snuCKrOX9jLxkJodskr2d

# fNBwCnzvqLx1T7pa96kQsl3p/yhUifDVinF2ZdrM8HKjI/rAJ4JErpknG6skHibB

# t94q6/aesXmZgaNWhqsKRcnfxI2g55j7+6adcq/Ex8HBanHZxhOACcS2n82HhyS7

# T6NJuXdmkfFynOlLAlKnN36TU6w7HQhJD5TNOXrd/yVjmScsPT9rp/Fmw0HNT7ZA

# myEhQNC3EyTN3B14OuSereU0cZLXJmvkOHOrpgFPvT87eK1MrfvElXvtCl8zOYdB

# eHo46Zzh3SP9HSjTx/no8Zhf+yvYfvJGnXUsHicsJttvFXseGYs2uJPU5vIXmVnK

# cPA3v5gA3yAWTyf7YGcWoWa63VXAOimGsJigK+2VQbc61RWYMbRiCQ8KvYHZE/6/

# pNHzV9m8BPqC3jLfBInwAM1dwvnQI38AC+R2AibZ8GV2QqYphwlHK+Z/GqSFD/yY

# lvZVVCsfgPrA8g4r5db7qS9EFUrnEw4d2zc4GqEr9u3WfPwwggbGMIIErqADAgEC

# AhAKekqInsmZQpAGYzhNhpedMA0GCSqGSIb3DQEBCwUAMGMxCzAJBgNVBAYTAlVT

# MRcwFQYDVQQKEw5EaWdpQ2VydCwgSW5jLjE7MDkGA1UEAxMyRGlnaUNlcnQgVHJ1

# c3RlZCBHNCBSU0E0MDk2IFNIQTI1NiBUaW1lU3RhbXBpbmcgQ0EwHhcNMjIwMzI5

# MDAwMDAwWhcNMzMwMzE0MjM1OTU5WjBMMQswCQYDVQQGEwJVUzEXMBUGA1UEChMO

# RGlnaUNlcnQsIEluYy4xJDAiBgNVBAMTG0RpZ2lDZXJ0IFRpbWVzdGFtcCAyMDIy

# IC0gMjCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBALkqliOmXLxf1knw

# FYIY9DPuzFxs4+AlLtIx5DxArvurxON4XX5cNur1JY1Do4HrOGP5PIhp3jzSMFEN

# MQe6Rm7po0tI6IlBfw2y1vmE8Zg+C78KhBJxbKFiJgHTzsNs/aw7ftwqHKm9MMYW

# 2Nq867Lxg9GfzQnFuUFqRUIjQVr4YNNlLD5+Xr2Wp/D8sfT0KM9CeR87x5MHaGjl

# RDRSXw9Q3tRZLER0wDJHGVvimC6P0Mo//8ZnzzyTlU6E6XYYmJkRFMUrDKAz200k

# heiClOEvA+5/hQLJhuHVGBS3BEXz4Di9or16cZjsFef9LuzSmwCKrB2NO4Bo/tBZ

# mCbO4O2ufyguwp7gC0vICNEyu4P6IzzZ/9KMu/dDI9/nw1oFYn5wLOUrsj1j6siu

# gSBrQ4nIfl+wGt0ZvZ90QQqvuY4J03ShL7BUdsGQT5TshmH/2xEvkgMwzjC3iw9d

# RLNDHSNQzZHXL537/M2xwafEDsTvQD4ZOgLUMalpoEn5deGb6GjkagyP6+SxIXuG

# Z1h+fx/oK+QUshbWgaHK2jCQa+5vdcCwNiayCDv/vb5/bBMY38ZtpHlJrYt/YYcF

# aPfUcONCleieu5tLsuK2QT3nr6caKMmtYbCgQRgZTu1Hm2GV7T4LYVrqPnqYklHN

# P8lE54CLKUJy93my3YTqJ+7+fXprAgMBAAGjggGLMIIBhzAOBgNVHQ8BAf8EBAMC

# B4AwDAYDVR0TAQH/BAIwADAWBgNVHSUBAf8EDDAKBggrBgEFBQcDCDAgBgNVHSAE

# GTAXMAgGBmeBDAEEAjALBglghkgBhv1sBwEwHwYDVR0jBBgwFoAUuhbZbU2FL3Mp

# dpovdYxqII+eyG8wHQYDVR0OBBYEFI1kt4kh/lZYRIRhp+pvHDaP3a8NMFoGA1Ud

# HwRTMFEwT6BNoEuGSWh0dHA6Ly9jcmwzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydFRy

# dXN0ZWRHNFJTQTQwOTZTSEEyNTZUaW1lU3RhbXBpbmdDQS5jcmwwgZAGCCsGAQUF

# BwEBBIGDMIGAMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdpY2VydC5jb20w

# WAYIKwYBBQUHMAKGTGh0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2Vy

# dFRydXN0ZWRHNFJTQTQwOTZTSEEyNTZUaW1lU3RhbXBpbmdDQS5jcnQwDQYJKoZI

# hvcNAQELBQADggIBAA0tI3Sm0fX46kuZPwHk9gzkrxad2bOMl4IpnENvAS2rOLVw

# Eb+EGYs/XeWGT76TOt4qOVo5TtiEWaW8G5iq6Gzv0UhpGThbz4k5HXBw2U7fIyJs

# 1d/2WcuhwupMdsqh3KErlribVakaa33R9QIJT4LWpXOIxJiA3+5JlbezzMWn7g7h

# 7x44ip/vEckxSli23zh8y/pc9+RTv24KfH7X3pjVKWWJD6KcwGX0ASJlx+pedKZb

# NZJQfPQXpodkTz5GiRZjIGvL8nvQNeNKcEiptucdYL0EIhUlcAZyqUQ7aUcR0+7p

# x6A+TxC5MDbk86ppCaiLfmSiZZQR+24y8fW7OK3NwJMR1TJ4Sks3KkzzXNy2hcC7

# cDBVeNaY/lRtf3GpSBp43UZ3Lht6wDOK+EoojBKoc88t+dMj8p4Z4A2UKKDr2xpR

# oJWCjihrpM6ddt6pc6pIallDrl/q+A8GQp3fBmiW/iqgdFtjZt5rLLh4qk1wbfAs

# 8QcVfjW05rUMopml1xVrNQ6F1uAszOAMJLh8UgsemXzvyMjFjFhpr6s94c/MfRWu

# FL+Kcd/Kl7HYR+ocheBFThIcFClYzG/Tf8u+wQ5KbyCcrtlzMlkI5y2SoRoR/jKY

# pl0rl+CL05zMbbUNrkdjOEcXW28T2moQbh9Jt0RbtAgKh1pZBHYRoad3AhMcMYIF

# XTCCBVkCAQEwgYYwcjELMAkGA1UEBhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IElu

# YzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTExMC8GA1UEAxMoRGlnaUNlcnQg

# U0hBMiBBc3N1cmVkIElEIENvZGUgU2lnbmluZyBDQQIQAwW7hiGwoWNfv96uEgTn

# bTANBglghkgBZQMEAgEFAKCBhDAYBgorBgEEAYI3AgEMMQowCKACgAChAoAAMBkG

# CSqGSIb3DQEJAzEMBgorBgEEAYI3AgEEMBwGCisGAQQBgjcCAQsxDjAMBgorBgEE

# AYI3AgEVMC8GCSqGSIb3DQEJBDEiBCBOJzfgKWSQBpyTaczfYbwcneouOrURWYrp

# 9+I21hJhoTANBgkqhkiG9w0BAQEFAASCAQCuPLsS1F/br25sNyvLuqcn5QdeNLO6

# R6S3edtpuWBFt/brxJ/BZZevmJ80DSpF+40TooJpIRtD8VWaKirrNZj52qVq58CP

# cfIP1sy97QCImuUoP4JtyYuUMCfWGHWfr0bi8K0EGRway9S+H4gnjuodKFOkyJ1Z

# iMV/G5NW8Cnprmludbgc+rp9tiPfUvwIAFigcnyi8SjDXUsjd7IkhDiUfL7hoIa0

# FkAn/rq4hl1oM20JfJZES3ARTaanthwN+wf3GgiNtBZE4W49FP0bDZpss5iQXAWH

# 9E3JG8fu2Kx9FdLAa00fCSYyr60OXfbVGGWGQ9jWrr/EKGykopZfGbw0oYIDIDCC

# AxwGCSqGSIb3DQEJBjGCAw0wggMJAgEBMHcwYzELMAkGA1UEBhMCVVMxFzAVBgNV

# BAoTDkRpZ2lDZXJ0LCBJbmMuMTswOQYDVQQDEzJEaWdpQ2VydCBUcnVzdGVkIEc0

# IFJTQTQwOTYgU0hBMjU2IFRpbWVTdGFtcGluZyBDQQIQCnpKiJ7JmUKQBmM4TYaX

# nTANBglghkgBZQMEAgEFAKBpMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJ

# KoZIhvcNAQkFMQ8XDTIyMDYzMDEyMTgzMlowLwYJKoZIhvcNAQkEMSIEIKVE068f

# 5mEewOKCNl2RsdC+pvKBjb+Q7pp1wh0aJeK6MA0GCSqGSIb3DQEBAQUABIICAHO7

# 9xcC5qNBMPVulPZr8hfwRpfeiaeievyDcv/7+OZJeucF7Fs5fW81bLyzrcLvVrbz

# nU8VX3xdeJ9/MExuIeejRUogjV9uPOk791Sg4nlkKKQ8CFHXFl4ZP+l0DPH2ddAt

# 7KnHwDOUwir7nec1gnX/idvjCKrls49DwrwHeTMr1wX5YPV/X89E4x+AdGdYJBvS

# 4cDNtW3hNGEPAZeUQHYmFtZ0kVn97xFVMi3ikD40wQVZ2298Gbx655xFoLAeQxia

# jnMxFa2sY4Ykkt6630swJDqV1QI98tfnWVZnS64wUjGIOF0VFLVFp41ydr4vetRZ

# K6hODVrykgVB3erCTlqdcI2+k+uDrNViYLSXsndGkLd0BtY5HgmSs9PlfPmIoqcG

# X2FnudnbGqBdz0sfmiNLi6gmTfjCnu4rdcgWJt2mFCnXcu8MdLlGSEPpelmOHj81

# ezmf4Y23ZXWIPnhJ92Cp3fecKb+yzs1Xdk0oh2TfBZeOzJxlEQNQENscizy4NMZs

# INrmLeevsImCk9qCotuYJjQO97uWITWIPeKivcS6gUjHkI3VWNeMZ4g/TnzRJmSh

# LCDHr0NlAv99QsmSsO1237l3UEz4owNRacj+7sMafpGyZWcvKAImnzB5WuhbkITK

# g65SytvA38TnwplUWKhnV07UxwwA9BDliDvtyMwE

# SIG # End signature block