Various Alerts related

Copy-Alerts.ps1

# quick fix for  Copy-DbaAgentAlert not copying categories (and  Copy-DbaAgentAlertCategories not existing)
param ([string] $Source, $Destination)
 Get-DbaAgentAlertCategory -SqlInstance $Source | % { New-DbaAgentAlertCategory -SqlInstance $Destination -Category $_.Name};
 Copy-DbaAgentAlert -Source $Source -Destination $Destination;

get-enabled-alerts.sql

SELECT
	M1.message_id, M1.severity, M1.[text]
,	1 AS is_error_alert, 0 AS is_severity_alert 
FROM	dbo.sysalerts AS A1
JOIN	sys.messages AS M1
  ON	A1.message_id = M1.message_id
WHERE	M1.language_id = 1033
  AND	A1.[enabled] = 1
UNION ALL
SELECT
	M1.message_id, M1.severity, M1.[text]
,	0 AS is_error_alert, 1 AS is_severity_alert 
FROM	dbo.sysalerts AS A1
JOIN	sys.messages AS M1
  ON	A1.severity = M1.severity
WHERE	M1.language_id = 1033
  AND	A1.[enabled] = 1