functions/Find-DbaDbDuplicateIndex.ps1
function Find-DbaDbDuplicateIndex { <# .SYNOPSIS Find duplicate and overlapping indexes. .DESCRIPTION This command will help you to find duplicate and overlapping indexes on a database or a list of databases. On SQL Server 2008 and higher, the IsFiltered property will also be checked Only supports CLUSTERED and NONCLUSTERED indexes. Output: TableName IndexName KeyColumns IncludedColumns IndexSizeMB IndexType CompressionDescription (When 2008+) [RowCount] IsDisabled IsFiltered (When 2008+) .PARAMETER SqlInstance The target SQL Server instance or instances. .PARAMETER SqlCredential Login to the target instance using alternative credentials. Accepts PowerShell credentials (Get-Credential). Windows Authentication, SQL Server Authentication, Active Directory - Password, and Active Directory - Integrated are all supported. For MFA support, please use Connect-DbaInstance. .PARAMETER Database The database(s) to process. Options for this list are auto-populated from the server. If unspecified, all databases will be processed. .PARAMETER IncludeOverlapping If this switch is enabled, indexes which are partially duplicated will be returned. Example: If the first key column is the same between two indexes, but one has included columns and the other not, this will be shown. .PARAMETER EnableException By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message. This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting. Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch. .NOTES Tags: Index, Lookup Author: Claudio Silva (@ClaudioESSilva) Website: https://dbatools.io Copyright: (c) 2018 by dbatools, licensed under MIT License: MIT https://opensource.org/licenses/MIT .LINK https://dbatools.io/Find-DbaDbDuplicateIndex .EXAMPLE PS C:\> Find-DbaDbDuplicateIndex -SqlInstance sql2005 Returns duplicate indexes found on sql2005 .EXAMPLE PS C:\> Find-DbaDbDuplicateIndex -SqlInstance sql2017 -SqlCredential sqladmin Finds exact duplicate indexes on all user databases present on sql2017, using SQL authentication. .EXAMPLE PS C:\> Find-DbaDbDuplicateIndex -SqlInstance sql2017 -Database db1, db2 Finds exact duplicate indexes on the db1 and db2 databases. .EXAMPLE PS C:\> Find-DbaDbDuplicateIndex -SqlInstance sql2017 -IncludeOverlapping Finds both duplicate and overlapping indexes on all user databases. #> [CmdletBinding()] param ( [parameter(Mandatory, ValueFromPipeline)] [DbaInstanceParameter[]]$SqlInstance, [PSCredential]$SqlCredential, [object[]]$Database, [switch]$IncludeOverlapping, [switch]$EnableException ) begin { $exactDuplicateQuery2005 = " WITH CTE_IndexCols AS ( SELECT i.[object_id] ,i.index_id ,OBJECT_SCHEMA_NAME(i.[object_id]) AS SchemaName ,OBJECT_NAME(i.[object_id]) AS TableName ,NAME AS IndexName ,ISNULL(STUFF(( SELECT ', ' + col.NAME + ' ' + CASE WHEN idxCol.is_descending_key = 1 THEN 'DESC' ELSE 'ASC' END -- Include column order (ASC / DESC) FROM sys.index_columns idxCol INNER JOIN sys.columns col ON idxCol.[object_id] = col.[object_id] AND idxCol.column_id = col.column_id WHERE i.[object_id] = idxCol.[object_id] AND i.index_id = idxCol.index_id AND idxCol.is_included_column = 0 ORDER BY idxCol.key_ordinal FOR XML PATH('') ), 1, 2, ''), '') AS KeyColumns ,ISNULL(STUFF(( SELECT ', ' + col.NAME + ' ' + CASE WHEN idxCol.is_descending_key = 1 THEN 'DESC' ELSE 'ASC' END -- Include column order (ASC / DESC) FROM sys.index_columns idxCol INNER JOIN sys.columns col ON idxCol.[object_id] = col.[object_id] AND idxCol.column_id = col.column_id WHERE i.[object_id] = idxCol.[object_id] AND i.index_id = idxCol.index_id AND idxCol.is_included_column = 1 ORDER BY idxCol.key_ordinal FOR XML PATH('') ), 1, 2, ''), '') AS IncludedColumns ,i.[type_desc] AS IndexType ,i.is_disabled AS IsDisabled ,i.is_unique AS IsUnique FROM sys.indexes AS i WHERE i.index_id > 0 -- Exclude HEAPS AND i.[type_desc] IN ( 'CLUSTERED' ,'NONCLUSTERED' ) AND OBJECT_SCHEMA_NAME(i.[object_id]) <> 'sys' ) ,CTE_IndexSpace AS ( SELECT s.[object_id] ,s.index_id ,SUM(s.[used_page_count]) * 8 / 1024.0 AS IndexSizeMB ,SUM(p.[rows]) AS [RowCount] FROM sys.dm_db_partition_stats AS s INNER JOIN sys.partitions p WITH (NOLOCK) ON s.[partition_id] = p.[partition_id] AND s.[object_id] = p.[object_id] AND s.index_id = p.index_id WHERE s.index_id > 0 -- Exclude HEAPS AND OBJECT_SCHEMA_NAME(s.[object_id]) <> 'sys' GROUP BY s.[object_id] ,s.index_id ) SELECT DB_NAME() AS DatabaseName ,CI1.SchemaName + '.' + CI1.TableName AS 'TableName' ,CI1.IndexName ,CI1.KeyColumns ,CI1.IncludedColumns ,CI1.IndexType ,COALESCE(CSPC.IndexSizeMB,0) AS 'IndexSizeMB' ,COALESCE(CSPC.[RowCount],0) AS 'RowCount' ,CI1.IsDisabled ,CI1.IsUnique FROM CTE_IndexCols AS CI1 LEFT JOIN CTE_IndexSpace AS CSPC ON CI1.[object_id] = CSPC.[object_id] AND CI1.index_id = CSPC.index_id WHERE EXISTS ( SELECT 1 FROM CTE_IndexCols CI2 WHERE CI1.SchemaName = CI2.SchemaName AND CI1.TableName = CI2.TableName AND CI1.KeyColumns = CI2.KeyColumns AND CI1.IncludedColumns = CI2.IncludedColumns AND CI1.IndexName <> CI2.IndexName )" $overlappingQuery2005 = " WITH CTE_IndexCols AS ( SELECT i.[object_id] ,i.index_id ,OBJECT_SCHEMA_NAME(i.[object_id]) AS SchemaName ,OBJECT_NAME(i.[object_id]) AS TableName ,NAME AS IndexName ,ISNULL(STUFF(( SELECT ', ' + col.NAME + ' ' + CASE WHEN idxCol.is_descending_key = 1 THEN 'DESC' ELSE 'ASC' END -- Include column order (ASC / DESC) FROM sys.index_columns idxCol INNER JOIN sys.columns col ON idxCol.[object_id] = col.[object_id] AND idxCol.column_id = col.column_id WHERE i.[object_id] = idxCol.[object_id] AND i.index_id = idxCol.index_id AND idxCol.is_included_column = 0 ORDER BY idxCol.key_ordinal FOR XML PATH('') ), 1, 2, ''), '') AS KeyColumns ,ISNULL(STUFF(( SELECT ', ' + col.NAME + ' ' + CASE WHEN idxCol.is_descending_key = 1 THEN 'DESC' ELSE 'ASC' END -- Include column order (ASC / DESC) FROM sys.index_columns idxCol INNER JOIN sys.columns col ON idxCol.[object_id] = col.[object_id] AND idxCol.column_id = col.column_id WHERE i.[object_id] = idxCol.[object_id] AND i.index_id = idxCol.index_id AND idxCol.is_included_column = 1 ORDER BY idxCol.key_ordinal FOR XML PATH('') ), 1, 2, ''), '') AS IncludedColumns ,i.[type_desc] AS IndexType ,i.is_disabled AS IsDisabled ,i.is_unique AS IsUnique FROM sys.indexes AS i WHERE i.index_id > 0 -- Exclude HEAPS AND i.[type_desc] IN ( 'CLUSTERED' ,'NONCLUSTERED' ) AND OBJECT_SCHEMA_NAME(i.[object_id]) <> 'sys' ) ,CTE_IndexSpace AS ( SELECT s.[object_id] ,s.index_id ,SUM(s.[used_page_count]) * 8 / 1024.0 AS IndexSizeMB ,SUM(p.[rows]) AS [RowCount] FROM sys.dm_db_partition_stats AS s INNER JOIN sys.partitions p WITH (NOLOCK) ON s.[partition_id] = p.[partition_id] AND s.[object_id] = p.[object_id] AND s.index_id = p.index_id WHERE s.index_id > 0 -- Exclude HEAPS AND OBJECT_SCHEMA_NAME(s.[object_id]) <> 'sys' GROUP BY s.[object_id] ,s.index_id ) SELECT DB_NAME() AS DatabaseName ,CI1.SchemaName + '.' + CI1.TableName AS 'TableName' ,CI1.IndexName ,CI1.KeyColumns ,CI1.IncludedColumns ,CI1.IndexType ,COALESCE(CSPC.IndexSizeMB,0) AS 'IndexSizeMB' ,COALESCE(CSPC.[RowCount],0) AS 'RowCount' ,CI1.IsDisabled ,CI1.IsUnique FROM CTE_IndexCols AS CI1 LEFT JOIN CTE_IndexSpace AS CSPC ON CI1.[object_id] = CSPC.[object_id] AND CI1.index_id = CSPC.index_id WHERE EXISTS ( SELECT 1 FROM CTE_IndexCols CI2 WHERE CI1.SchemaName = CI2.SchemaName AND CI1.TableName = CI2.TableName AND ( ( CI1.KeyColumns LIKE CI2.KeyColumns + '%' AND SUBSTRING(CI1.KeyColumns, LEN(CI2.KeyColumns) + 1, 1) = ' ' ) OR ( CI2.KeyColumns LIKE CI1.KeyColumns + '%' AND SUBSTRING(CI2.KeyColumns, LEN(CI1.KeyColumns) + 1, 1) = ' ' ) ) AND CI1.IndexName <> CI2.IndexName )" # Support Compression 2008+ $exactDuplicateQuery = " WITH CTE_IndexCols AS ( SELECT i.[object_id] ,i.index_id ,OBJECT_SCHEMA_NAME(i.[object_id]) AS SchemaName ,OBJECT_NAME(i.[object_id]) AS TableName ,NAME AS IndexName ,ISNULL(STUFF(( SELECT ', ' + col.NAME + ' ' + CASE WHEN idxCol.is_descending_key = 1 THEN 'DESC' ELSE 'ASC' END -- Include column order (ASC / DESC) FROM sys.index_columns idxCol INNER JOIN sys.columns col ON idxCol.[object_id] = col.[object_id] AND idxCol.column_id = col.column_id WHERE i.[object_id] = idxCol.[object_id] AND i.index_id = idxCol.index_id AND idxCol.is_included_column = 0 ORDER BY idxCol.key_ordinal FOR XML PATH('') ), 1, 2, ''), '') AS KeyColumns ,ISNULL(STUFF(( SELECT ', ' + col.NAME + ' ' + CASE WHEN idxCol.is_descending_key = 1 THEN 'DESC' ELSE 'ASC' END -- Include column order (ASC / DESC) FROM sys.index_columns idxCol INNER JOIN sys.columns col ON idxCol.[object_id] = col.[object_id] AND idxCol.column_id = col.column_id WHERE i.[object_id] = idxCol.[object_id] AND i.index_id = idxCol.index_id AND idxCol.is_included_column = 1 ORDER BY idxCol.key_ordinal FOR XML PATH('') ), 1, 2, ''), '') AS IncludedColumns ,i.[type_desc] AS IndexType ,i.is_disabled AS IsDisabled ,i.has_filter AS IsFiltered ,i.is_unique AS IsUnique FROM sys.indexes AS i WHERE i.index_id > 0 -- Exclude HEAPS AND i.[type_desc] IN ( 'CLUSTERED' ,'NONCLUSTERED' ) AND OBJECT_SCHEMA_NAME(i.[object_id]) <> 'sys' ) ,CTE_IndexSpace AS ( SELECT s.[object_id] ,s.index_id ,SUM(s.[used_page_count]) * 8 / 1024.0 AS IndexSizeMB ,SUM(p.[rows]) AS [RowCount] ,p.data_compression_desc AS CompressionDescription FROM sys.dm_db_partition_stats AS s INNER JOIN sys.partitions p WITH (NOLOCK) ON s.[partition_id] = p.[partition_id] AND s.[object_id] = p.[object_id] AND s.index_id = p.index_id WHERE s.index_id > 0 -- Exclude HEAPS AND OBJECT_SCHEMA_NAME(s.[object_id]) <> 'sys' GROUP BY s.[object_id] ,s.index_id ,p.data_compression_desc ) SELECT DB_NAME() AS DatabaseName ,CI1.SchemaName + '.' + CI1.TableName AS 'TableName' ,CI1.IndexName ,CI1.KeyColumns ,CI1.IncludedColumns ,CI1.IndexType ,COALESCE(CSPC.IndexSizeMB,0) AS 'IndexSizeMB' ,COALESCE(CSPC.CompressionDescription, 'NONE') AS 'CompressionDescription' ,COALESCE(CSPC.[RowCount],0) AS 'RowCount' ,CI1.IsDisabled ,CI1.IsFiltered ,CI1.IsUnique FROM CTE_IndexCols AS CI1 LEFT JOIN CTE_IndexSpace AS CSPC ON CI1.[object_id] = CSPC.[object_id] AND CI1.index_id = CSPC.index_id WHERE EXISTS ( SELECT 1 FROM CTE_IndexCols CI2 WHERE CI1.SchemaName = CI2.SchemaName AND CI1.TableName = CI2.TableName AND CI1.KeyColumns = CI2.KeyColumns AND CI1.IncludedColumns = CI2.IncludedColumns AND CI1.IsFiltered = CI2.IsFiltered AND CI1.IndexName <> CI2.IndexName )" $overlappingQuery = " WITH CTE_IndexCols AS ( SELECT i.[object_id] ,i.index_id ,OBJECT_SCHEMA_NAME(i.[object_id]) AS SchemaName ,OBJECT_NAME(i.[object_id]) AS TableName ,Name AS IndexName ,ISNULL(STUFF((SELECT ', ' + col.NAME + ' ' + CASE WHEN idxCol.is_descending_key = 1 THEN 'DESC' ELSE 'ASC' END -- Include column order (ASC / DESC) FROM sys.index_columns idxCol INNER JOIN sys.columns col ON idxCol.[object_id] = col.[object_id] AND idxCol.column_id = col.column_id WHERE i.[object_id] = idxCol.[object_id] AND i.index_id = idxCol.index_id AND idxCol.is_included_column = 0 ORDER BY idxCol.key_ordinal FOR XML PATH('')), 1, 2, ''), '') AS KeyColumns ,ISNULL(STUFF((SELECT ', ' + col.NAME + ' ' + CASE WHEN idxCol.is_descending_key = 1 THEN 'DESC' ELSE 'ASC' END -- Include column order (ASC / DESC) FROM sys.index_columns idxCol INNER JOIN sys.columns col ON idxCol.[object_id] = col.[object_id] AND idxCol.column_id = col.column_id WHERE i.[object_id] = idxCol.[object_id] AND i.index_id = idxCol.index_id AND idxCol.is_included_column = 1 ORDER BY idxCol.key_ordinal FOR XML PATH('')), 1, 2, ''), '') AS IncludedColumns ,i.[type_desc] AS IndexType ,i.is_disabled AS IsDisabled ,i.has_filter AS IsFiltered ,i.is_unique AS IsUnique FROM sys.indexes AS i WHERE i.index_id > 0 -- Exclude HEAPS AND i.[type_desc] IN ('CLUSTERED', 'NONCLUSTERED') AND OBJECT_SCHEMA_NAME(i.[object_id]) <> 'sys' ), CTE_IndexSpace AS ( SELECT s.[object_id] ,s.index_id ,SUM(s.[used_page_count]) * 8 / 1024.0 AS IndexSizeMB ,SUM(p.[rows]) AS [RowCount] ,p.data_compression_desc AS CompressionDescription FROM sys.dm_db_partition_stats AS s INNER JOIN sys.partitions p WITH (NOLOCK) ON s.[partition_id] = p.[partition_id] AND s.[object_id] = p.[object_id] AND s.index_id = p.index_id WHERE s.index_id > 0 -- Exclude HEAPS AND OBJECT_SCHEMA_NAME(s.[object_id]) <> 'sys' GROUP BY s.[object_id], s.index_id, p.data_compression_desc ) SELECT DB_NAME() AS DatabaseName ,CI1.SchemaName + '.' + CI1.TableName AS 'TableName' ,CI1.IndexName ,CI1.KeyColumns ,CI1.IncludedColumns ,CI1.IndexType ,COALESCE(CSPC.IndexSizeMB,0) AS 'IndexSizeMB' ,COALESCE(CSPC.CompressionDescription, 'NONE') AS 'CompressionDescription' ,COALESCE(CSPC.[RowCount],0) AS 'RowCount' ,CI1.IsDisabled ,CI1.IsFiltered ,CI1.IsUnique FROM CTE_IndexCols AS CI1 LEFT JOIN CTE_IndexSpace AS CSPC ON CI1.[object_id] = CSPC.[object_id] AND CI1.index_id = CSPC.index_id WHERE EXISTS (SELECT 1 FROM CTE_IndexCols CI2 WHERE CI1.SchemaName = CI2.SchemaName AND CI1.TableName = CI2.TableName AND ( (CI1.KeyColumns like CI2.KeyColumns + '%' and SUBSTRING(CI1.KeyColumns,LEN(CI2.KeyColumns)+1,1) = ' ') OR (CI2.KeyColumns like CI1.KeyColumns + '%' and SUBSTRING(CI2.KeyColumns,LEN(CI1.KeyColumns)+1,1) = ' ') ) AND CI1.IsFiltered = CI2.IsFiltered AND CI1.IndexName <> CI2.IndexName )" } process { if (Test-FunctionInterrupt) { return } foreach ($instance in $SqlInstance) { try { $server = Connect-DbaInstance -SqlInstance $instance -SqlCredential $SqlCredential -MinimumVersion 9 } catch { Stop-Function -Message "Failure" -Category ConnectionError -ErrorRecord $_ -Target $instance -Continue } if ($database) { $databases = $server.Databases | Where-Object Name -in $database } else { $databases = $server.Databases | Where-Object IsAccessible -eq $true } foreach ($db in $databases) { try { Write-Message -Level Verbose -Message "Getting indexes from database '$db'." $query = if ($server.versionMajor -eq 9) { if ($IncludeOverlapping) { $overlappingQuery2005 } else { $exactDuplicateQuery2005 } } else { if ($IncludeOverlapping) { $overlappingQuery } else { $exactDuplicateQuery } } $db.Query($query) } catch { Stop-Function -Message "Query failure" -Target $db } } } } } # SIG # Begin signature block # MIIjigYJKoZIhvcNAQcCoIIjezCCI3cCAQExDzANBglghkgBZQMEAgEFADB5Bgor # BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG # KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCCYSduPHrCSbgt7 # ak9izxG7pcNbnHtZrvPbGUUy9jcTEqCCHYMwggUaMIIEAqADAgECAhADBbuGIbCh # 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 # AYI3AgEVMC8GCSqGSIb3DQEJBDEiBCAr0V34TRuDJwkGzxYDoA/aq4xAYWc1WOuV # Vdl2BUq8WzANBgkqhkiG9w0BAQEFAASCAQCAaI6ghQb8LhcaYzyiWEnBJVFuWvC9 # s+FxEZ+N9oQcDdXaHZLn6cO5umbugpLActNKvIHUAgYTdE5BCbiyZdveLkAFs52c # KJazq38kXonIjpJM1+EzZd3VflZpX08KT3XwEXN+edHrz98RbF6GFzrD1zyIpBbv # R5hM8kj7ogPEIJSbMsZ6vxNTM1YaryInottkv0Cd7RQ4yhrovgI+Qr6E3BiGtZfC # P5RouoxzDfEMSeT72aB1Hed4ohRAJfWqc84ux4+1vBaLsHxjERXVOFngHL+OavUH # hvjBQXquiY7sxVZ97p0XI1WXiiyK1Y+5eTFE89AWgsA/LYYNzAiJ2eofoYIDIDCC # AxwGCSqGSIb3DQEJBjGCAw0wggMJAgEBMHcwYzELMAkGA1UEBhMCVVMxFzAVBgNV # BAoTDkRpZ2lDZXJ0LCBJbmMuMTswOQYDVQQDEzJEaWdpQ2VydCBUcnVzdGVkIEc0 # IFJTQTQwOTYgU0hBMjU2IFRpbWVTdGFtcGluZyBDQQIQCnpKiJ7JmUKQBmM4TYaX # nTANBglghkgBZQMEAgEFAKBpMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJ # KoZIhvcNAQkFMQ8XDTIyMDYzMDEyMTY0NFowLwYJKoZIhvcNAQkEMSIEIGNN28tX # 4luxyVClZisra6MIhwai19DgO2l4cw12+1URMA0GCSqGSIb3DQEBAQUABIICADP5 # AACfjAk9FdFUzm7awKLfg87RkEIlTPUM5rVRS17qzuK4WUje53ID0w4/U9qvgFFq # pn5ZcqifhmL1+VZQ/EJQgYAoEv2PlHtyDVQMvbKUPCpOwG7Iw4/zvFGZl9iVMbK2 # GCj1aHM6G0PoZ1MDjUAhwPZUQtsLKNEqRUrf9aDKxpcU3e1c/bMZtUb83Fe2TOuT # Qw4cJ0VMElYQ+hHBXFm0fj09HLZW9C/BsrwaNGLsEcRgojwEbQ/i9oobbjwG1g3l # 3YlBdcy/JrVzbGrvN3nEtJ1XBUe8ebx1GLNT9qwUGZvcg3EW/Xt4n1aI9AMB+vVB # i+iGEreB7kAqETDGAnRzKciAxrMBngE49P0Hi1DsjTWvsGEStaEGJ1SmSfXRmYdx # Kb8hEKMvZd3xVD6IqHavmR4w2pvXu2ixMwj517uFkaSm5zbEukV7MZFAcJlV/oRc # E6tqpUhx76rHLd1UEYDDpm1bjBdTu3WBHOP3bh26JrGXhqFnd2N63v6DlshFzBlS # Y0940KduO6EMBkJqTgkrf08EkcUhthU+F+7dLGH/AynB21PCFlOWyEBYR4HdK6kC # dk+MrADuqylSxhnxav6HsOB/ceefhGG6LDnJWuxk++olLG+xmnYfFgXKbSFvukMo # oUzagQVQFezbAuDBZNDHs1IjrJKA5yohWAoHCPys # SIG # End signature block |