Scem.Support.psm1

<#
.Synopsis
   Short description
.DESCRIPTION
   Long description
.EXAMPLE
   Example of how to use this cmdlet
.EXAMPLE
   Another example of how to use this cmdlet
#>

function Export-SCVMMInfo {
    [CmdletBinding()]
    Param(
        [parameter(Mandatory = $false,
                   Position=0)]
        [string]
        $ComputerName = $env:COMPUTERNAME
        )
    if($null -eq (Get-Module virtualmachinemanager)){
        try{
            Import-Module virtualmachinemanager -ErrorAction Stop
        }
        catch [FileNotFoundException]{
            Write-Error "This does not appear to be a System Center Virtual Machine Manager."
        }
    }

    # Get our VMM Server
    [Microsoft.SystemCenter.VirtualMachineManager.Remoting.ServerConnection]$vmmServer = $null
    $vmmServer = virtualmachinemanager\Get-SCVMMServer -ComputerName $ComputerName

    # Get the .NET Framework Version & add a property
    $dotNetFrameworkVersion = Get-DotNetFrameworkVersion -ComputerName $vmmServer.FQDN
    $vmmServer | Add-Member -NotePropertyName DotNetFrameworkVersion -NotePropertyValue $dotNetFrameworkVersion

    # Write the json to a file
    $vmmServer | ConvertTo-Json | Out-File .\vmmServer.json

    # Get VMM Host Groups & write json
    $vmmHostGroups = Get-SCVMHostGroup -VMMServer $vmmServer
    $vmmHostGroups | ConvertTo-Json | Out-File .\vmmHostGroups.json

    $vmmHostCollection = Get-SCVMHost -VMMServer $vmmServer
    $vmmHostCollection | ConvertTo-Json | Out-File .\vmmHosts.json

    if ($null -ne $vmmServer) {
        if ($vmmServer.IsConnected) {
            $vmmServer.Disconnect()
        }
        $vmmServer = $null
    }
}

<#
.Synopsis
   Exports SCOM Management Server information to json
.DESCRIPTION
   Exports SCOM Management Server information to json
.EXAMPLE
   PS C:\> Get-SCOMManagementServer | Export-SCOMManagementServerInfo
.EXAMPLE
   PS C:\> $managementServerCollection = Get-SCOMManagementServer
   PS C:\> Export-SCOMManagementServerInfo -ManagementServer $managementServerCollection
#>

function Export-SCOMManagementServerInfo
{
    [CmdletBinding()]
    [OutputType([string])]
    Param
    (
        [Parameter(Mandatory=$true,
                   ValueFromPipeline=$true,
                   Position=0)]
        [ValidateNotNull()]
        [Microsoft.EnterpriseManagement.Administration.ManagementServer[]]
        $ManagementServer
    )

    Begin{
        $jsonOutput = @()
    }
    Process{
        # This is a hack because ConvertTo-Json does not like converting ManagmentServers.
        # When you pipe to ConvertTo-Json, you get this error:
        # "ConvertTo-Json : An item with the same key has already been added."
        # The multiple pipes below seem to convert to json as currently desired.
        $tmpMgmtServer = $ManagementServer | ConvertTo-Csv | ConvertFrom-Csv

        # Get the .NET Framework version and add a new property to the Management Server object.
        $dotNetFrameworkVersion = Get-DotNetFrameworkVersion -ComputerName $tmpMgmtServer.ComputerName
        $tmpMgmtServer | Add-Member -NotePropertyName DotNetFrameworkVersion -NotePropertyValue $dotNetFrameworkVersion

        # Add the temporary object to the output array
        $jsonOutput += $tmpMgmtServer
    }
    End{
        $jsonOutput | ConvertTo-Json | Out-File .\SCOMManagementServerInfo.json
    }
}

<#
.Synopsis
   Returns the friendly version of the .NET Framework.
.DESCRIPTION
   Converts the value of 'SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full' Release to a string.
#>

function ConvertTo-DotNetFrameworkFriendlyVersionName
{
    [CmdletBinding()]
    [OutputType([string])]
    Param
    (
        [System.UInt32]$Release
    )
    [string]$FriendlyVersionValue = switch ($Release) {
        378389 { ".NET Framework 4.5" }
        378675 { ".NET Framework 4.5.1" }
        378758 { ".NET Framework 4.5.1" }
        379893 { ".NET Framework 4.5.2" }
        393295 { ".NET Framework 4.6" }
        393297 { ".NET Framework 4.6" }
        394254 { ".NET Framework 4.6.1" }
        394271 { ".NET Framework 4.6.1" }
        394802 { ".NET Framework 4.6.2" }
        394806 { ".NET Framework 4.6.2" }
        460798 { ".NET Framework 4.7" }
        460805 { ".NET Framework 4.7" }
        461308 { ".NET Framework 4.7.1" }
        461310 { ".NET Framework 4.7.1" }
        461808 { ".NET Framework 4.7.2" }
        461814 { ".NET Framework 4.7.2" }
        528040 { ".NET Framework 4.8" }
        528049 { ".NET Framework 4.8" }
        528372 { ".NET Framework 4.8" }
        default { "Unknown .NET version: $Release" }
    }

    return $FriendlyVersionValue
}
<#
.Synopsis
   Returns the .NET Framework Version
.DESCRIPTION
   Returns the .NET Framework Version
#>

function Get-DotNetFrameworkVersion
{
    [CmdletBinding()]
    [OutputType([string])]
    Param
    (
        [parameter(Mandatory = $false)]
        [string] $ComputerName = $env:COMPUTERNAME
    )

    $arguments = @{sSubKeyName = "SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full"; sValueName ='Release'};

    # Invoke-CimMethod seems to not like FQDNs when $ComputerName is the current machine.
    # For example: assume $ComputerName -eq 'ms1.contoso.com' and $env:COMPUTERNAME -eq 'ms1'.
    # Then Invoke-CimMethod will throw this:
    ########################################################################################
    # Invoke-CimMethod : Access is denied.
    # At line:1 char:1
    # + Invoke-CimMethod -ClassName StdRegProv -MethodName GetDWORDValue -Arg ...
    # + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    # + CategoryInfo : PermissionDenied: (root\cimv2:StdRegProv:String) [Invoke-CimMethod], CimException
    # + FullyQualifiedErrorId : HRESULT 0x80070005,Microsoft.Management.Infrastructure.CimCmdlets.InvokeCimMethodCommand
    # + PSComputerName : OpsMgr-1.contoso.com
    ########################################################################################
    #
    # This split ensures we always call Invoke-CimMethod with the NetBIOS name even if
    # $ComputerName is already a NetBIOS name.
    [string]$tmpComputerName = $ComputerName.Split('.')[0]

    # https://docs.microsoft.com/en-us/previous-versions/windows/desktop/regprov/stdregprov
    $output = Invoke-CimMethod -ClassName StdRegProv -MethodName GetDWORDValue -Arguments $arguments -ComputerName $tmpComputerName

    $friendlyVersion = ConvertTo-DotNetFrameworkFriendlyVersionName $output.uValue

    return $friendlyVersion
}

<#
.Synopsis
   Gets the SQL Server Version Information
.DESCRIPTION
   This returns the T-SQL @@VERSION
.EXAMPLE
   Example of how to use this cmdlet
.EXAMPLE
   Another example of how to use this cmdlet
#>

function Get-SqlVersion
{
    [CmdletBinding()]
    [Alias()]
    [OutputType([string])]
    Param
    (
        [Parameter(Mandatory=$true,
                   Position=0)]
        [string]
        $ComputerName,
        [Parameter(Mandatory=$false,
                   Position=1)]
        [string]
        $InstanceName
    )

    $connectionStringBuilder = New-Object System.Data.SqlClient.SqlConnectionStringBuilder

    if ($InstanceName) {
        $connectionStringBuilder['Data Source'] = $ComputerName + "\" + $InstanceName
    } else {
        $connectionStringBuilder['Data Source'] = $ComputerName
    }

    $connectionStringBuilder['Initial Catalog'] = 'master'
    $connectionStringBuilder['Application Name'] = 'Scem.Support Module'
    $connectionStringBuilder['Trusted_Connection'] = $true

    [System.Data.SqlClient.SqlCommand]$sqlCommand = $null
    [System.Data.SqlClient.SqlDataReader]$sqlReader = $null
    [string]$sqlVersion = 'Unknown'

    try{
        $sqlConnection = New-Object System.Data.SqlClient.SqlConnection $connectionStringBuilder.ConnectionString
        $sqlConnection.Open()

        [System.Data.SqlClient.SqlCommand]$sqlCommand = $sqlConnection.CreateCommand()
        $sqlCommand.CommandText = 'SELECT @@VERSION'
        $sqlCommand.CommandType = [System.Data.CommandType]::Text

        [System.Data.SqlClient.SqlDataReader]$sqlReader = $sqlCommand.ExecuteReader()
        while($sqlReader.Read()){
            $sqlVersion = $sqlReader.GetString(0)
            break
        }
    }
    finally{
        if($null -ne $sqlReader){
            $sqlReader.Dispose()
        }
        if($null -ne $sqlCommand){
            $sqlCommand.Dispose()
        }
        if($null -ne $sqlConnection){
            $sqlConnection.Dispose()
        }
    }

    return $sqlVersion
}

<#
.Synopsis
   Gets the TLS Settings Information
.DESCRIPTION
   This returns the TLS Settings
.EXAMPLE
   Example of how to use this cmdlet
.EXAMPLE
   Another example of how to use this cmdlet
.OWNER
    AndyDesmond
#>

function Get-TLSSetting {
    [CmdletBinding()]
    Param(
        [parameter(Mandatory = $false,Position=0)]
        [string]$ComputerName = $env:COMPUTERNAME
    )

    $ProtocolList = @("SSL 2.0", "SSL 3.0", "TLS 1.0", "TLS 1.1", "TLS 1.2")
    $ProtocolSubKeyList = @("Client", "Server")

    #Initialize the results set
    $TLSSetting = [Ordered]@{}
    # Invoke-CimMethod seems to not like FQDNs when $ComputerName is the current machine.
    # For example: assume $ComputerName -eq 'ms1.contoso.com' and $env:COMPUTERNAME -eq 'ms1'.
    # Then Invoke-CimMethod will throw this:
    ########################################################################################
    # Invoke-CimMethod : Access is denied.
    # At line:1 char:1
    # + Invoke-CimMethod -ClassName StdRegProv -MethodName GetDWORDValue -Arg ...
    # + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    # + CategoryInfo : PermissionDenied: (root\cimv2:StdRegProv:String) [Invoke-CimMethod], CimException
    # + FullyQualifiedErrorId : HRESULT 0x80070005,Microsoft.Management.Infrastructure.CimCmdlets.InvokeCimMethodCommand
    # + PSComputerName : OpsMgr-1.contoso.com
    ########################################################################################
    #
    # This split ensures we always call Invoke-CimMethod with the NetBIOS name even if
    # $ComputerName is already a NetBIOS name.
    [string]$Target = $ComputerName.Split('.')[0]
    $Protocols = @{}
    ForEach ($Protocol in $ProtocolList) {
        ForEach ($ProtocolSubKey in $ProtocolSubKeyList) {
            $sSubKeyName = "SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\$($Protocol)\$($ProtocolSubKey)"
            $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetDWORDValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "DisabledByDefault" }
            $Protocols.add("$Protocol.$ProtocolSubKey", $CIMMethod)
        }
    }
    $TLSSetting.Add($Target, $Protocols)

    Return (ConvertTo-Json $TLSSetting)
}

<#
.Synopsis
   Gets the Registry Keys from System Center Product
.DESCRIPTION
   This gets the Registry Keys from System Center Product
.EXAMPLE
   Example of how to use this cmdlet
.EXAMPLE
   Another example of how to use this cmdlet
.OWNER
    blakedrumm
#>

function Get-SystemCenterSetupRegKeyInfo
{
    [CmdletBinding()]
    [OutputType([Microsoft.EnterpriseManagement.Support.Common.SystemCenterSetupRegKeyInfo])]
    Param(
    [parameter(Mandatory = $false,Position=0)]
    [string]$ComputerName = $env:COMPUTERNAME
    )

    # This split ensures we always call Invoke-CimMethod with the NetBIOS name even if
    # $ComputerName is already a NetBIOS name.
    [string]$Target = $ComputerName.Split('.')[0]
    $sSubKeyName = "SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Setup"
    # construct a new object
    $setuplocation = New-Object -TypeName Microsoft.EnterpriseManagement.Support.Common.SystemCenterSetupRegKeyInfo
    #set the object values from the registry key
    $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetStringValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "CurrentVersion" }
    $setuplocation.CurrentVersion = $CIMMethod.sValue

    $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetStringValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "DatabaseName" }
    $setuplocation.DatabaseName = $CIMMethod.sValue

    $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetStringValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "DatabaseServerName" }
    $setuplocation.DatabaseServerName = $CIMMethod.sValue

    $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetStringValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "DatabaseVersion" }
    $setuplocation.DatabaseVersion = $CIMMethod.sValue

    $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetStringValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "DataWarehouseDBName" }
    $setuplocation.DataWarehouseDBName = $CIMMethod.sValue

    $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetStringValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "DataWarehouseDBServerName" }
    $setuplocation.DataWarehouseDBServerName = $CIMMethod.sValue

    $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetStringValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "InstallDirectory" }
    $setuplocation.InstallDirectory = $CIMMethod.sValue

    $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetStringValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "InstalledOn" }
    $setuplocation.InstalledOn = $CIMMethod.sValue

    $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetStringValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "ManagementServerPort" }
    $setuplocation.ManagementServerPort = $CIMMethod.sValue

    $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetStringValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "Product" }
    $setuplocation.Product = $CIMMethod.sValue

    $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetStringValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "ServerVersion" }
    $setuplocation.ServerVersion = $CIMMethod.sValue

    $CIMMethod = Invoke-CimMethod -ClassName 'StdRegProv' -MethodName GetStringValue -ComputerName $Target -Arguments @{sSubKeyName = $sSubKeyName; sValueName = "UIVersion" }
    $setuplocation.UIVersion = $CIMMethod.sValue

    return $setuplocation
}
# SIG # Begin signature block
# MIInuwYJKoZIhvcNAQcCoIInrDCCJ6gCAQExDzANBglghkgBZQMEAgEFADB5Bgor
# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG
# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCD8EtezqrtswqCP
# FILlP0Zo4aktsray3ZDEzrHnVAgDWqCCDYUwggYDMIID66ADAgECAhMzAAACU+OD
# 3pbexW7MAAAAAAJTMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD
# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy
# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p
# bmcgUENBIDIwMTEwHhcNMjEwOTAyMTgzMzAwWhcNMjIwOTAxMTgzMzAwWjB0MQsw
# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u
# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy
# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB
# AQDLhxHwq3OhH+4J+SX4qS/VQG8HybccH7tnG+BUqrXubfGuDFYPZ29uCuHfQlO1
# lygLgMpJ4Geh6/6poQ5VkDKfVssn6aA1PCzIh8iOPMQ9Mju3sLF9Sn+Pzuaie4BN
# rp0MuZLDEXgVYx2WNjmzqcxC7dY9SC3znOh5qUy2vnmWygC7b9kj0d3JrGtjc5q5
# 0WfV3WLXAQHkeRROsJFBZfXFGoSvRljFFUAjU/zdhP92P+1JiRRRikVy/sqIhMDY
# +7tVdzlE2fwnKOv9LShgKeyEevgMl0B1Fq7E2YeBZKF6KlhmYi9CE1350cnTUoU4
# YpQSnZo0YAnaenREDLfFGKTdAgMBAAGjggGCMIIBfjAfBgNVHSUEGDAWBgorBgEE
# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQUlZpLWIccXoxessA/DRbe26glhEMw
# VAYDVR0RBE0wS6RJMEcxLTArBgNVBAsTJE1pY3Jvc29mdCBJcmVsYW5kIE9wZXJh
# dGlvbnMgTGltaXRlZDEWMBQGA1UEBRMNMjMwMDEyKzQ2NzU5ODAfBgNVHSMEGDAW
# gBRIbmTlUAXTgqoXNzcitW2oynUClTBUBgNVHR8ETTBLMEmgR6BFhkNodHRwOi8v
# d3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NybC9NaWNDb2RTaWdQQ0EyMDExXzIw
# MTEtMDctMDguY3JsMGEGCCsGAQUFBwEBBFUwUzBRBggrBgEFBQcwAoZFaHR0cDov
# L3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9jZXJ0cy9NaWNDb2RTaWdQQ0EyMDEx
# XzIwMTEtMDctMDguY3J0MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQELBQADggIB
# AKVY+yKcJVVxf9W2vNkL5ufjOpqcvVOOOdVyjy1dmsO4O8khWhqrecdVZp09adOZ
# 8kcMtQ0U+oKx484Jg11cc4Ck0FyOBnp+YIFbOxYCqzaqMcaRAgy48n1tbz/EFYiF
# zJmMiGnlgWFCStONPvQOBD2y/Ej3qBRnGy9EZS1EDlRN/8l5Rs3HX2lZhd9WuukR
# bUk83U99TPJyo12cU0Mb3n1HJv/JZpwSyqb3O0o4HExVJSkwN1m42fSVIVtXVVSa
# YZiVpv32GoD/dyAS/gyplfR6FI3RnCOomzlycSqoz0zBCPFiCMhVhQ6qn+J0GhgR
# BJvGKizw+5lTfnBFoqKZJDROz+uGDl9tw6JvnVqAZKGrWv/CsYaegaPePFrAVSxA
# yUwOFTkAqtNC8uAee+rv2V5xLw8FfpKJ5yKiMKnCKrIaFQDr5AZ7f2ejGGDf+8Tz
# OiK1AgBvOW3iTEEa/at8Z4+s1CmnEAkAi0cLjB72CJedU1LAswdOCWM2MDIZVo9j
# 0T74OkJLTjPd3WNEyw0rBXTyhlbYQsYt7ElT2l2TTlF5EmpVixGtj4ChNjWoKr9y
# TAqtadd2Ym5FNB792GzwNwa631BPCgBJmcRpFKXt0VEQq7UXVNYBiBRd+x4yvjqq
# 5aF7XC5nXCgjbCk7IXwmOphNuNDNiRq83Ejjnc7mxrJGMIIHejCCBWKgAwIBAgIK
# YQ6Q0gAAAAAAAzANBgkqhkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNV
# BAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jv
# c29mdCBDb3Jwb3JhdGlvbjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlm
# aWNhdGUgQXV0aG9yaXR5IDIwMTEwHhcNMTEwNzA4MjA1OTA5WhcNMjYwNzA4MjEw
# OTA5WjB+MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UE
# BxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSgwJgYD
# VQQDEx9NaWNyb3NvZnQgQ29kZSBTaWduaW5nIFBDQSAyMDExMIICIjANBgkqhkiG
# 9w0BAQEFAAOCAg8AMIICCgKCAgEAq/D6chAcLq3YbqqCEE00uvK2WCGfQhsqa+la
# UKq4BjgaBEm6f8MMHt03a8YS2AvwOMKZBrDIOdUBFDFC04kNeWSHfpRgJGyvnkmc
# 6Whe0t+bU7IKLMOv2akrrnoJr9eWWcpgGgXpZnboMlImEi/nqwhQz7NEt13YxC4D
# dato88tt8zpcoRb0RrrgOGSsbmQ1eKagYw8t00CT+OPeBw3VXHmlSSnnDb6gE3e+
# lD3v++MrWhAfTVYoonpy4BI6t0le2O3tQ5GD2Xuye4Yb2T6xjF3oiU+EGvKhL1nk
# kDstrjNYxbc+/jLTswM9sbKvkjh+0p2ALPVOVpEhNSXDOW5kf1O6nA+tGSOEy/S6
# A4aN91/w0FK/jJSHvMAhdCVfGCi2zCcoOCWYOUo2z3yxkq4cI6epZuxhH2rhKEmd
# X4jiJV3TIUs+UsS1Vz8kA/DRelsv1SPjcF0PUUZ3s/gA4bysAoJf28AVs70b1FVL
# 5zmhD+kjSbwYuER8ReTBw3J64HLnJN+/RpnF78IcV9uDjexNSTCnq47f7Fufr/zd
# sGbiwZeBe+3W7UvnSSmnEyimp31ngOaKYnhfsi+E11ecXL93KCjx7W3DKI8sj0A3
# T8HhhUSJxAlMxdSlQy90lfdu+HggWCwTXWCVmj5PM4TasIgX3p5O9JawvEagbJjS
# 4NaIjAsCAwEAAaOCAe0wggHpMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBRI
# bmTlUAXTgqoXNzcitW2oynUClTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTAL
# BgNVHQ8EBAMCAYYwDwYDVR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBRyLToCMZBD
# uRQFTuHqp8cx0SOJNDBaBgNVHR8EUzBRME+gTaBLhklodHRwOi8vY3JsLm1pY3Jv
# c29mdC5jb20vcGtpL2NybC9wcm9kdWN0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFf
# MDNfMjIuY3JsMF4GCCsGAQUFBwEBBFIwUDBOBggrBgEFBQcwAoZCaHR0cDovL3d3
# dy5taWNyb3NvZnQuY29tL3BraS9jZXJ0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFf
# MDNfMjIuY3J0MIGfBgNVHSAEgZcwgZQwgZEGCSsGAQQBgjcuAzCBgzA/BggrBgEF
# BQcCARYzaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9kb2NzL3ByaW1h
# cnljcHMuaHRtMEAGCCsGAQUFBwICMDQeMiAdAEwAZQBnAGEAbABfAHAAbwBsAGkA
# YwB5AF8AcwB0AGEAdABlAG0AZQBuAHQALiAdMA0GCSqGSIb3DQEBCwUAA4ICAQBn
# 8oalmOBUeRou09h0ZyKbC5YR4WOSmUKWfdJ5DJDBZV8uLD74w3LRbYP+vj/oCso7
# v0epo/Np22O/IjWll11lhJB9i0ZQVdgMknzSGksc8zxCi1LQsP1r4z4HLimb5j0b
# pdS1HXeUOeLpZMlEPXh6I/MTfaaQdION9MsmAkYqwooQu6SpBQyb7Wj6aC6VoCo/
# KmtYSWMfCWluWpiW5IP0wI/zRive/DvQvTXvbiWu5a8n7dDd8w6vmSiXmE0OPQvy
# CInWH8MyGOLwxS3OW560STkKxgrCxq2u5bLZ2xWIUUVYODJxJxp/sfQn+N4sOiBp
# mLJZiWhub6e3dMNABQamASooPoI/E01mC8CzTfXhj38cbxV9Rad25UAqZaPDXVJi
# hsMdYzaXht/a8/jyFqGaJ+HNpZfQ7l1jQeNbB5yHPgZ3BtEGsXUfFL5hYbXw3MYb
# BL7fQccOKO7eZS/sl/ahXJbYANahRr1Z85elCUtIEJmAH9AAKcWxm6U/RXceNcbS
# oqKfenoi+kiVH6v7RyOA9Z74v2u3S5fi63V4GuzqN5l5GEv/1rMjaHXmr/r8i+sL
# gOppO6/8MO0ETI7f33VtY5E90Z1WTk+/gFcioXgRMiF670EKsT/7qMykXcGhiJtX
# cVZOSEXAQsmbdlsKgEhr/Xmfwb1tbWrJUnMTDXpQzTGCGYwwghmIAgEBMIGVMH4x
# CzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRt
# b25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01p
# Y3Jvc29mdCBDb2RlIFNpZ25pbmcgUENBIDIwMTECEzMAAAJT44Pelt7FbswAAAAA
# AlMwDQYJYIZIAWUDBAIBBQCgga4wGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQw
# HAYKKwYBBAGCNwIBCzEOMAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkEMSIEIDCm
# 9kqPy7gSeRgyRVnyOOIY8NWo7ynd/kPKxt8NIGIbMEIGCisGAQQBgjcCAQwxNDAy
# oBSAEgBNAGkAYwByAG8AcwBvAGYAdKEagBhodHRwOi8vd3d3Lm1pY3Jvc29mdC5j
# b20wDQYJKoZIhvcNAQEBBQAEggEAVIWFMJqL3SfrpZEeDc5oSxoNYWnI6WzbIlN7
# bW2CSGOHmtTzP0+fR+J2kaQ4zOWHbCqPDLlOHS3vJsjvvvzE4qWDoanwIlEhfMw1
# Hlg/LOo0uImm+/l+TmEtB0Z+HOkFDswEBl0Gg174pv/Fhw9/5xXtWGvYKNiQ1ug9
# jcJkleVv0fGLvfqbqWzbZidtBnK69qww6S2D9zIRiaTxJzZnQijFiDk0Nm9NnnxU
# QdKx/CiOQjbO2YFrqvy4vRxD1ah775AbtpgvoGGkLonUAd4JgJ1cjQcaHkofiwrF
# i7o40kEAuaCrsdbvYdlCz5N6voJ4LLKCYbz+TfI+LUMFB8n11aGCFxYwghcSBgor
# BgEEAYI3AwMBMYIXAjCCFv4GCSqGSIb3DQEHAqCCFu8wghbrAgEDMQ8wDQYJYIZI
# AWUDBAIBBQAwggFZBgsqhkiG9w0BCRABBKCCAUgEggFEMIIBQAIBAQYKKwYBBAGE
# WQoDATAxMA0GCWCGSAFlAwQCAQUABCDzzwYWdh3WSTcZjiiTSFC0KSJNEnj1yUmM
# 3JmRkaeG9gIGYhe3O2W1GBMyMDIyMDQxNDE5NDgwNi4zNzZaMASAAgH0oIHYpIHV
# MIHSMQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMH
# UmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMS0wKwYDVQQL
# EyRNaWNyb3NvZnQgSXJlbGFuZCBPcGVyYXRpb25zIExpbWl0ZWQxJjAkBgNVBAsT
# HVRoYWxlcyBUU1MgRVNOOjJBRDQtNEI5Mi1GQTAxMSUwIwYDVQQDExxNaWNyb3Nv
# ZnQgVGltZS1TdGFtcCBTZXJ2aWNloIIRZTCCBxQwggT8oAMCAQICEzMAAAGGeOUZ
# ifgkS8wAAQAAAYYwDQYJKoZIhvcNAQELBQAwfDELMAkGA1UEBhMCVVMxEzARBgNV
# BAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jv
# c29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAg
# UENBIDIwMTAwHhcNMjExMDI4MTkyNzM5WhcNMjMwMTI2MTkyNzM5WjCB0jELMAkG
# A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx
# HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9z
# b2Z0IElyZWxhbmQgT3BlcmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMg
# VFNTIEVTTjoyQUQ0LTRCOTItRkEwMTElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUt
# U3RhbXAgU2VydmljZTCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAMCN
# xtlqb+geCIwH64HyaZ3Tzj2DtWHfPr5X6CMTFt4HQg0/syG2n4NeKTrtLdHpFEMe
# tKez2nR+Do56jSBNaupXR/Z7Y9YCHZeB6uK3RB02eiRXRNuA0m1aKqkfkeCMOMNx
# j233NkN5H8shco/gzoZglsPxWYk1U5U+G3Xo8gFuq/yZ+H698S4274SE2ra9+lcs
# s4ENGOFq+9x94FHC42LtKoh7rQw2+vqfsgwRpihc5zlvMFbew/rtlRCaBOiZStBK
# VS2brHUs4XnLlMCV8W9rsoAGV5bGv3x5cFvWJ5QajByfopvR7iuV+MfP+QeXZLiK
# F+ZVhoxTGw9gOi7vz5lAeIStAheRtWGlLQazBO9wwCpMqZO0hJtwZSV8GPxq1aF1
# mFBhB8n65C5MLNEaBDKaCBIHm2TSqo0cp0SYEeHzwiqxIcBIk0wHOA1xnIuBxzpu
# uBENYP0gxzBaiClUsaFG5Bm3SjSh4ZmobiKwMuMHvbO62SbJL3mWGYg5rQLQbf4E
# KI8W2dbzvQtdUrYZK5pJEzC0H/XA85VRAXruiph19ks3uoIJ3tyOHMv+SFC5x2d6
# zOGaSXNLNiqRix2laxEMuMf5gJ+MmmH4Hh9zBAFpFY8v6kw4enAwhf4Ms902kA7b
# xZwCu9C6rWxLwT3QaXghv4ZPZdJWmM8IsshmPx6jAgMBAAGjggE2MIIBMjAdBgNV
# HQ4EFgQUGbajRQPvZnRLv4d91IRzDesIXC4wHwYDVR0jBBgwFoAUn6cVXQBeYl2D
# 9OXSZacbUzUZ6XIwXwYDVR0fBFgwVjBUoFKgUIZOaHR0cDovL3d3dy5taWNyb3Nv
# ZnQuY29tL3BraW9wcy9jcmwvTWljcm9zb2Z0JTIwVGltZS1TdGFtcCUyMFBDQSUy
# MDIwMTAoMSkuY3JsMGwGCCsGAQUFBwEBBGAwXjBcBggrBgEFBQcwAoZQaHR0cDov
# L3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9jZXJ0cy9NaWNyb3NvZnQlMjBUaW1l
# LVN0YW1wJTIwUENBJTIwMjAxMCgxKS5jcnQwDAYDVR0TAQH/BAIwADATBgNVHSUE
# DDAKBggrBgEFBQcDCDANBgkqhkiG9w0BAQsFAAOCAgEAw+5noSWN30xyguIY/sAV
# gfOeOLmiYjDCB54SvTjUzO1a2k2M8dFP03CyeoMcNbUczObrvJLMCTZRzae0XnbA
# IsL4lUGVfQC/CG2USyU8DXoQsJPgVXGNoId2RmZsfLmrT2a0bnsoYU0w9j7xVS63
# 8IdpYgxv3RDzSB0yo+/Q5RHDyFqDglKe6dDkTMEPeZFWom6V/Pab44T5dhZtAgTt
# 6V1yYNG8naUOXQw07/6m9PlmBf7zVRFPzKDBEKpVFlrlxAk6sek2sibiyerlOyuU
# Mk5EP5duCIRow83+QBGTqyDWM5FlcjX1DqSMZyrFkwTdoo6Wf07p+aq5qPbzSA09
# JaG4J7pWntezWhDvaIhCSR9bUN+d3YbkYvgNND0e/NYmJcxeSVNQ6xHxMjcfAloB
# EYvdCyrGIIWQQg40Nw4iY31GS6jjXh6yX3Joc+f235vPmgGlD6WRXj9INCKJ3elz
# ZOGImG1jxaKH3NC8HKkgC7biAMs+n93flGmWbKeNVOIQiKBo+oaAyLlPN/W6P5mf
# wIBEsBsSF7NIGVOgPtqiFHutEHQPevcFks7nCjorJ4PRwkmSxdXanN0FGsK9AtFO
# Ne/OCqPb3JABt2pMGLlRnLOoTP0qhIaHvYx8HuF6fNQq0wdZffhCHbpAmz9JMs8d
# Fmc7Xnogzea3YokEfZgSbpYwggdxMIIFWaADAgECAhMzAAAAFcXna54Cm0mZAAAA
# AAAVMA0GCSqGSIb3DQEBCwUAMIGIMQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2Fz
# aGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENv
# cnBvcmF0aW9uMTIwMAYDVQQDEylNaWNyb3NvZnQgUm9vdCBDZXJ0aWZpY2F0ZSBB
# dXRob3JpdHkgMjAxMDAeFw0yMTA5MzAxODIyMjVaFw0zMDA5MzAxODMyMjVaMHwx
# CzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRt
# b25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1p
# Y3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwMIICIjANBgkqhkiG9w0BAQEFAAOC
# Ag8AMIICCgKCAgEA5OGmTOe0ciELeaLL1yR5vQ7VgtP97pwHB9KpbE51yMo1V/YB
# f2xK4OK9uT4XYDP/XE/HZveVU3Fa4n5KWv64NmeFRiMMtY0Tz3cywBAY6GB9alKD
# RLemjkZrBxTzxXb1hlDcwUTIcVxRMTegCjhuje3XD9gmU3w5YQJ6xKr9cmmvHaus
# 9ja+NSZk2pg7uhp7M62AW36MEBydUv626GIl3GoPz130/o5Tz9bshVZN7928jaTj
# kY+yOSxRnOlwaQ3KNi1wjjHINSi947SHJMPgyY9+tVSP3PoFVZhtaDuaRr3tpK56
# KTesy+uDRedGbsoy1cCGMFxPLOJiss254o2I5JasAUq7vnGpF1tnYN74kpEeHT39
# IM9zfUGaRnXNxF803RKJ1v2lIH1+/NmeRd+2ci/bfV+AutuqfjbsNkz2K26oElHo
# vwUDo9Fzpk03dJQcNIIP8BDyt0cY7afomXw/TNuvXsLz1dhzPUNOwTM5TI4CvEJo
# LhDqhFFG4tG9ahhaYQFzymeiXtcodgLiMxhy16cg8ML6EgrXY28MyTZki1ugpoMh
# XV8wdJGUlNi5UPkLiWHzNgY1GIRH29wb0f2y1BzFa/ZcUlFdEtsluq9QBXpsxREd
# cu+N+VLEhReTwDwV2xo3xwgVGD94q0W29R6HXtqPnhZyacaue7e3PmriLq0CAwEA
# AaOCAd0wggHZMBIGCSsGAQQBgjcVAQQFAgMBAAEwIwYJKwYBBAGCNxUCBBYEFCqn
# Uv5kxJq+gpE8RjUpzxD/LwTuMB0GA1UdDgQWBBSfpxVdAF5iXYP05dJlpxtTNRnp
# cjBcBgNVHSAEVTBTMFEGDCsGAQQBgjdMg30BATBBMD8GCCsGAQUFBwIBFjNodHRw
# Oi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL0RvY3MvUmVwb3NpdG9yeS5odG0w
# EwYDVR0lBAwwCgYIKwYBBQUHAwgwGQYJKwYBBAGCNxQCBAweCgBTAHUAYgBDAEEw
# CwYDVR0PBAQDAgGGMA8GA1UdEwEB/wQFMAMBAf8wHwYDVR0jBBgwFoAU1fZWy4/o
# olxiaNE9lJBb186aGMQwVgYDVR0fBE8wTTBLoEmgR4ZFaHR0cDovL2NybC5taWNy
# b3NvZnQuY29tL3BraS9jcmwvcHJvZHVjdHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYt
# MjMuY3JsMFoGCCsGAQUFBwEBBE4wTDBKBggrBgEFBQcwAoY+aHR0cDovL3d3dy5t
# aWNyb3NvZnQuY29tL3BraS9jZXJ0cy9NaWNSb29DZXJBdXRfMjAxMC0wNi0yMy5j
# cnQwDQYJKoZIhvcNAQELBQADggIBAJ1VffwqreEsH2cBMSRb4Z5yS/ypb+pcFLY+
# TkdkeLEGk5c9MTO1OdfCcTY/2mRsfNB1OW27DzHkwo/7bNGhlBgi7ulmZzpTTd2Y
# urYeeNg2LpypglYAA7AFvonoaeC6Ce5732pvvinLbtg/SHUB2RjebYIM9W0jVOR4
# U3UkV7ndn/OOPcbzaN9l9qRWqveVtihVJ9AkvUCgvxm2EhIRXT0n4ECWOKz3+SmJ
# w7wXsFSFQrP8DJ6LGYnn8AtqgcKBGUIZUnWKNsIdw2FzLixre24/LAl4FOmRsqlb
# 30mjdAy87JGA0j3mSj5mO0+7hvoyGtmW9I/2kQH2zsZ0/fZMcm8Qq3UwxTSwethQ
# /gpY3UA8x1RtnWN0SCyxTkctwRQEcb9k+SS+c23Kjgm9swFXSVRk2XPXfx5bRAGO
# WhmRaw2fpCjcZxkoJLo4S5pu+yFUa2pFEUep8beuyOiJXk+d0tBMdrVXVAmxaQFE
# fnyhYWxz/gq77EFmPWn9y8FBSX5+k77L+DvktxW/tM4+pTFRhLy/AsGConsXHRWJ
# jXD+57XQKBqJC4822rpM+Zv/Cuk0+CQ1ZyvgDbjmjJnW4SLq8CdCPSWU5nR0W2rR
# nj7tfqAxM328y+l7vzhwRNGQ8cirOoo6CGJ/2XBjU02N7oJtpQUQwXEGahC0HVUz
# WLOhcGbyoYIC1DCCAj0CAQEwggEAoYHYpIHVMIHSMQswCQYDVQQGEwJVUzETMBEG
# A1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWlj
# cm9zb2Z0IENvcnBvcmF0aW9uMS0wKwYDVQQLEyRNaWNyb3NvZnQgSXJlbGFuZCBP
# cGVyYXRpb25zIExpbWl0ZWQxJjAkBgNVBAsTHVRoYWxlcyBUU1MgRVNOOjJBRDQt
# NEI5Mi1GQTAxMSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFtcCBTZXJ2aWNl
# oiMKAQEwBwYFKw4DAhoDFQABrtg0c1pCpY5l8kl9ZKKxy+HzJ6CBgzCBgKR+MHwx
# CzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRt
# b25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1p
# Y3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwMA0GCSqGSIb3DQEBBQUAAgUA5gLN
# FDAiGA8yMDIyMDQxNTAwNDA1MloYDzIwMjIwNDE2MDA0MDUyWjB0MDoGCisGAQQB
# hFkKBAExLDAqMAoCBQDmAs0UAgEAMAcCAQACAhj0MAcCAQACAhOnMAoCBQDmBB6U
# AgEAMDYGCisGAQQBhFkKBAIxKDAmMAwGCisGAQQBhFkKAwKgCjAIAgEAAgMHoSCh
# CjAIAgEAAgMBhqAwDQYJKoZIhvcNAQEFBQADgYEAPXUSJ9JFqWbPfWjDgO6NsWOb
# D8KHIT6sX9NRetflS4jq8Hx1eDrdbqGmAjMGB662YsYoU8dfLupHlU9H0FHa/7LM
# eU6xt6S/HDz8T03U4R0W3jzlf3XtX2KjLlSCn6krPPkF0fNjd465z04/xEOV5Nn3
# wx9INlAAfHQtCmQ0LksxggQNMIIECQIBATCBkzB8MQswCQYDVQQGEwJVUzETMBEG
# A1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWlj
# cm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFt
# cCBQQ0EgMjAxMAITMwAAAYZ45RmJ+CRLzAABAAABhjANBglghkgBZQMEAgEFAKCC
# AUowGgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJEAEEMC8GCSqGSIb3DQEJBDEiBCBj
# Btj6XIN9m0BgsiSEgF+hafqkoAvHYltnk3dBcsJF/TCB+gYLKoZIhvcNAQkQAi8x
# geowgecwgeQwgb0EIBqZiOCyLAhUxomMn0QEe5uxWtoLsVTSMNe5nAIqvEJ+MIGY
# MIGApH4wfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNV
# BAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQG
# A1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTACEzMAAAGGeOUZifgk
# S8wAAQAAAYYwIgQgOfHfwAiEL09Ex/IthDAndRWwXjTJD18LGTK53e7Z5l8wDQYJ
# KoZIhvcNAQELBQAEggIACKPVRjSymkrxVsU+xgCQ1wYxONfh1M/pIMm1LjeTm6JY
# i1blBffbncLPPfZgOQsyzeSoC9bpS8VoPl4PwqarJPyPtXoSF/g2DgLz5DsBgyTl
# 6Bzzoy/2xh/xDCK/AJiRtkApsE7snTyxn+jHCLC9JeqhXjthqKyP/jQrnO++SqHn
# j1T/8e2+VoluiNTI547zCySPhfcI6DKzCI7NF0BYpsy6lEjaegCfHhDDIiQrEwF2
# lEG5prA1vb0uo7pjR5I2ejOTDhSUKtsdv5wwrUcTEuUdFwRTuh1eGayCOFjS2Cfh
# xkV1zj4XnJI38GmmrEhM6M8xE95qRNcmrl+dSIswWpry3BmeKrcuLA+xDXA8PC9s
# t0C1ueYHc/oMXz2eAFksY1oMubJCD8XW6X4Tog9+hjmlJzZRrFmCEpVVN+OMoaBt
# esK8EqBFsMnJ6b9qDf9lVg8iDnc5GlqZo0OUHR2e7ZzjmVGP7xV6YzPCgYGR8fRH
# TIJ/O/o0vmK4Tf4ecVRB8U47pdttFwq2UXBKV36a+0VvXGcUx0kL80YZ4EtVPhj9
# Ar9ZEBVRhhMz6FFed9qtnaP3rpFV94xD9fMgHfmy5KY912BWRgTr6BDZSUmTOV4i
# Pw8GQu4ynUumvBuPLs+Be3hPEbytuC4V18wZwHOqvjv+mHedDhKcvpQD2lYFEmU=
# SIG # End signature block