sqmSQLTool

1.7.4.0

Public/category-map.ps1

                                # =============================================================================

# category-map.ps1 - Funktion -> Kategorie (fuer Show-sqmToolGui / Doku)

# Automatisch generiert aus Docs\sqmSQLTool_Functions.md + manueller Zuordnung.

# Bei neuen Funktionen hier ergaenzen; unbekannte landen in der GUI unter "Sonstige".

# =============================================================================

$categoryMap = @{

    'Add-sqmDatabaseToAG'                 = 'Always On & Availability Groups'

    'Add-sqmDatabaseToDistributedAg'      = 'Always On & Availability Groups'

    'Compare-sqmAlwaysOnLogins'           = 'Always On & Availability Groups'

    'Compare-sqmServerConfiguration'      = 'Configuration Management'

    'Complete-sqmListenerMigration'       = 'Always On & Availability Groups'

    'Copy-sqmLogins'                      = 'Login & User Security'

    'Copy-sqmNTFSPermissions'             = 'Storage & Disk Management'

    'Copy-sqmToCentralPath'               = 'Script Execution & Deployment'

    'Enable-sqmMonitoringAccess'          = 'Monitoring & Registry'

    'Enable-sqmServiceBroker'             = 'Service Broker'

    'Export-sqmAlwaysOnConfiguration'     = 'Always On & Availability Groups'

    'Export-sqmDatabaseDocumentation'     = 'Reporting & Analysis'

    'Export-sqmServerConfiguration'       = 'Configuration Management'

    'Find-sqmDatabaseObject'              = 'Database Maintenance'

    'Get-sqmADAccountStatus'              = 'Login & User Security'

    'Get-sqmADGroupMembers'               = 'Login & User Security'

    'Get-sqmADGroupMembersRecursive'      = 'Active Directory Integration'

    'Get-sqmADMemberGroups'               = 'Active Directory Integration'

    'Get-sqmAgentJobHistory'              = 'SQL Agent & Proxy Jobs'

    'Get-sqmAgentJobScheduleReport'       = 'SQL Agent & Proxy Jobs'

    'Get-sqmAlwaysOnFailoverHistory'      = 'Always On & Availability Groups'

    'Get-sqmAlwaysOnHealthReport'         = 'Always On & Availability Groups'

    'Get-sqmAutoGrowthReport'             = 'Reporting & Analysis'

    'Get-sqmBlockingReport'               = 'Monitoring & Health Checks'

    'Get-sqmCertificateReport'            = 'Certificates & TLS Security'

    'Get-sqmClusterInfo'                  = 'Server Configuration Testing'

    'Get-sqmConfig'                       = 'Configuration Management'

    'Get-sqmConnectionStats'              = 'Monitoring & Health Checks'

    'Get-sqmDatabaseHealth'               = 'Monitoring & Health Checks'

    'Get-sqmDeadlockReport'               = 'Extended Events & Diagnostics'

    'Get-sqmDiskBlockSize'                = 'Storage & Disk Management'

    'Get-sqmDiskInfoByDriveLetter'        = 'Storage & Disk Management'

    'Get-sqmDiskPartitionMap'             = 'Storage & Disk Management'

    'Get-sqmDiskSpaceReport'              = 'Storage & Disk Management'

    'Get-sqmDistributedAgHealth'          = 'Always On & Availability Groups'

    'Get-sqmHpuAllowGroup'                = 'Active Directory Integration'

    'Get-sqmIndexFragmentation'           = 'Performance Analysis & Optimization'

    'Get-sqmLinkedServerUsage'            = 'Reporting & Analysis'

    'Get-sqmLoginSettings'                = 'Login & User Security'

    'Get-sqmLongRunningQueries'           = 'Monitoring & Health Checks'

    'Get-sqmMissingIndexes'               = 'Performance Analysis & Optimization'

    'Get-sqmOperationStatus'              = 'Backup & Recovery'

    'Get-sqmOrphanedFiles'                = 'Storage & Disk Management'

    'Get-sqmPerfCounters'                 = 'Server Configuration Testing'

    'Get-sqmServerHardwareReport'         = 'Reporting & Analysis'

    'Get-sqmServerSetting'                = 'Monitoring & Health Checks'

    'Get-sqmServiceBrokerHealth'          = 'Service Broker'

    'Get-sqmSpnReport'                    = 'Server Configuration Testing'

    'Get-sqmSQLInstanceCheck'             = 'Monitoring & Health Checks'

    'Get-sqmSysadminAccounts'             = 'Login & User Security'

    'Get-sqmTempDbRecommendation'         = 'Performance Analysis & Optimization'

    'Get-sqmTlsStatus'                    = 'Certificates & TLS Security'

    'Get-sqmTsmConfiguration'             = 'External Systems Integration'

    'Get-sqmWaitStatistics'               = 'Performance Analysis & Optimization'

    'Install-sqmAdModule'                 = 'Module & Update Management'

    'Install-sqmCertificate'              = 'Certificates & TLS Security'

    'Install-sqmCertificateToStore'       = 'Certificates & TLS Security'

    'Install-sqmDb2Driver'                = 'SQL Drivers & Tools Installation'

    'Install-sqmJdbcDriver'               = 'SQL Drivers & Tools Installation'

    'Install-sqmOdbcDriver'               = 'SQL Drivers & Tools Installation'

    'Install-sqmOlaMaintenanceSolution'   = 'Database Maintenance'

    'Install-sqmSsrsReportServer'         = 'SSRS Configuration'

    'Invoke-sqmAlwaysOnSetup'             = 'Always On & Availability Groups'

    'Invoke-sqmCollationChange'           = 'Configuration Management'

    'Invoke-sqmConfigRollback'            = 'Configuration Management'

    'Invoke-sqmDeployScripts'             = 'Script Execution & Deployment'

    'Invoke-sqmDistributedFailover'       = 'Always On & Availability Groups'

    'Invoke-sqmExtendedEvents'            = 'Extended Events & Diagnostics'

    'Invoke-sqmFailover'                  = 'Always On & Availability Groups'

    'Invoke-sqmFormatDrive64k'            = 'Storage & Disk Management'

    'Invoke-sqmInstanceInventory'         = 'Reporting & Analysis'

    'Invoke-sqmListenerMigrationPrep'     = 'Always On & Availability Groups'

    'Invoke-sqmLoginAudit'                = 'Monitoring & Health Checks'

    'Invoke-sqmLogShrink'                 = 'Database Maintenance'

    'Invoke-sqmMonitoringKey'             = 'Monitoring & Registry'

    'Invoke-sqmNtfsSetup'                 = 'Storage & Disk Management'

    'Invoke-sqmPatchAnalysis'             = 'Monitoring & Registry'

    'Invoke-sqmPerfBaseline'              = 'Performance Analysis & Optimization'

    'Invoke-sqmQueryStore'                = 'Performance Analysis & Optimization'

    'Invoke-sqmRestoreDatabase'           = 'Backup & Recovery'

    'Invoke-sqmSaObfuscation'             = 'Login & User Security'

    'Invoke-sqmServiceBrokerAlwaysOn'     = 'Service Broker'

    'Invoke-sqmSetDatabaseRecoveryMode'   = 'Database Maintenance'

    'Invoke-sqmSetupReport'               = 'Reporting & Analysis'

    'Invoke-sqmSignModule'                = 'Script Execution & Deployment'

    'Invoke-sqmSplunkConfiguration'       = 'External Systems Integration'

    'Invoke-sqmSqlAlwaysOnAutoseeding'    = 'Always On & Availability Groups'

    'Invoke-sqmSsisConfiguration'         = 'SSIS Configuration'

    'Invoke-sqmTsmConfiguration'          = 'External Systems Integration'

    'Invoke-sqmUpdateStatistics'          = 'Database Maintenance'

    'Invoke-sqmUserDatabaseBackup'        = 'Backup & Recovery'

    'Move-sqmAlwaysOnListener'            = 'Always On & Availability Groups'

    'New-sqmAgentProxy'                   = 'SQL Agent & Proxy Jobs'

    'New-sqmAlwaysOnRepairJob'            = 'SQL Agent & Proxy Jobs'

    'New-sqmAutoLoginSyncJob'             = 'SQL Agent & Proxy Jobs'

    'New-sqmAvailabilityGroup'            = 'Always On & Availability Groups'

    'New-sqmBackupMaintenanceJob'         = 'Backup & Recovery'

    'New-sqmCertificateRequest'           = 'Certificates & TLS Security'

    'New-sqmDistributedAvailabilityGroup' = 'Always On & Availability Groups'

    'New-sqmOlaMaintenanceJobs'           = 'Backup & Recovery'

    'New-sqmOlaSysDbBackupJob'            = 'Backup & Recovery'

    'New-sqmOlaUsrDbBackupJob'            = 'Backup & Recovery'

    'New-sqmRandomSaPassword'             = 'Login & User Security'

    'New-sqmSetupReport'                  = 'Reporting & Analysis'

    'New-sqmSqlCertificate'               = 'Certificates & TLS Security'

    'Remove-sqmAdOrphanLogin'             = 'Login & User Security'

    'Remove-sqmDatabaseFromAG'            = 'Always On & Availability Groups'

    'Register-sqmBackupExcludeTrigger'    = 'Backup & Recovery'

    'Repair-sqmAlwaysOnDatabases'         = 'Always On & Availability Groups'

    'Set-sqmBackupExcludePermission'      = 'Backup & Recovery'

    'Show-sqmBackupExcludeForm'           = 'Backup & Recovery'

    'Set-sqmConfig'                       = 'Configuration Management'

    'Set-sqmDatabaseOwner'                = 'Database Maintenance'

    'Set-sqmMaxDop'                       = 'Configuration Management'

    'Set-sqmMaxMemory'                    = 'Configuration Management'

    'Set-sqmSqlPolicyState'               = 'Login & User Security'

    'Set-sqmSqlTlsCertificate'            = 'Certificates & TLS Security'

    'Set-sqmSsrsConfiguration'            = 'SSRS Configuration'

    'Set-sqmSsrsHttpsCertificate'         = 'Certificates & TLS Security'

    'Set-sqmTcpPort'                      = 'Configuration Management'

    'Show-sqmToolGui'                     = 'Module & Update Management'

    'Sync-sqmAgNode'                      = 'Always On & Availability Groups'

    'Sync-sqmBackupExcludeTable'          = 'Backup & Recovery'

    'Sync-sqmLoginsToAlwaysOn'            = 'Always On & Availability Groups'

    'Test-InternetConnectivity'           = 'Module & Update Management'

    'Test-sqmBackupIntegrity'             = 'Backup & Recovery'

    'Test-sqmCostThreshold'               = 'Performance Analysis & Optimization'

    'Test-sqmDistributedAgReadiness'      = 'Always On & Availability Groups'

    'Test-sqmDriverInstalled'             = 'SQL Drivers & Tools Installation'

    'Test-sqmMaxDop'                      = 'Performance Analysis & Optimization'

    'Test-sqmMaxMemory'                   = 'Performance Analysis & Optimization'

    'Test-sqmOlaInstallation'             = 'Database Maintenance'

    'Test-sqmSQLFirewall'                 = 'Server Configuration Testing'

    'Test-sqmSqlInstanceInstalled'        = 'Server Configuration Testing'

    'Test-sqmSsasDirectoryPermissions'    = 'Analysis Services (SSAS)'

    'Test-sqmSSISPackageCompatibility'    = 'SSIS Configuration'

    'Test-sqmTempDbFileCount'             = 'Performance Analysis & Optimization'

    'Test-sqmTsmConnection'               = 'External Systems Integration'

    'Uninstall-sqmDb2Driver'              = 'SQL Drivers & Tools Installation'

    'Uninstall-sqmJdbcDriver'             = 'SQL Drivers & Tools Installation'

    'Uninstall-sqmOdbcDriver'             = 'SQL Drivers & Tools Installation'

    'Write-sqmSetupEvent'                 = 'Reporting & Analysis'

}