Note this is a SQL query (not SWQL).
This query will show alert captions that do not match their true entity captions. This is a continuing problem within many Orion environments where nodes get updated and they're left with stale alert captions that don't match. This can help you clean that mess up.
SELECT
sub1.RealCaption
,sub1.AlertCaption
FROM ( SELECT CASE
WHEN a.EntityType = 'Orion.Nodes'
THEN n.Caption
WHEN a.EntityType = 'Orion.NPM.Interfaces'
THEN i.Caption
WHEN a.EntityType = 'Orion.Volumes'
THEN v.Caption
WHEN a.EntityType = 'Orion.APM.Application'
THEN app.Name
WHEN a.EntityType = 'Orion.APM.Component'
THEN com.Name
WHEN a.EntityType = 'Orion.APIPoller.ApiPoller'
THEN api.Name
WHEN a.EntityType = 'Orion.SEUM.Transactions'
THEN t.Name
WHEN a.EntityType = 'Orion.SEUM.TransactionSteps'
THEN NULL -- need to join records for name here?
WHEN a.EntityType = 'Orion.Groups'
THEN c.Name
WHEN a.EntityType = 'Orion.Engines'
THEN e.ServerName
WHEN a.EntityType = 'Orion.F5.LTM.Server'
THEN f5s.Name
WHEN a.EntityType = 'Orion.F5.LTM.Pool'
THEN NULL -- need to join other records here?
ELSE 'Error'
END AS [RealCaption]
,a.EntityCaption AS [AlertCaption]
FROM SolarWindsOrion.dbo.AlertObjects AS a
LEFT JOIN SolarWindsOrion.dbo.NodesData AS n ON a.EntityType = 'Orion.Nodes' AND a.RelatedNodeId = n.NodeID
LEFT JOIN SolarWindsOrion.dbo.Interfaces AS i ON a.EntityType = 'Orion.NPM.Interfaces' AND a.RelatedNodeId = i.InterfaceID
LEFT JOIN SolarWindsOrion.dbo.Volumes AS v ON a.EntityType = 'Orion.Volumes' AND a.RelatedNodeId = v.VolumeID
LEFT JOIN SolarWindsOrion.dbo.SEUM_Transactions AS t ON a.EntityType = 'Orion.SEUM.Transactions' AND a.EntityNetObjectId = CONCAT('T:', t.TransactionId)
LEFT JOIN SolarWindsOrion.dbo.SEUM_TransactionSteps AS ts ON a.EntityType = 'Orion.SEUM.TransactionSteps' AND a.EntityNetObjectId = CONCAT('T:', ts.TransactionStepId)
LEFT JOIN SolarWindsOrion.dbo.Containers AS c ON a.EntityType = 'Orion.Groups' AND a.EntityNetObjectId = CONCAT('C:', c.ContainerID)
LEFT JOIN SolarWindsOrion.dbo.Engines AS e ON a.EntityType = 'Orion.Engines' AND a.EntityNetObjectId = CONCAT(':', e.EngineID)
LEFT JOIN SolarWindsOrion.dbo.APM_Application AS app ON a.EntityType = 'Orion.APM.Application' AND a.EntityNetObjectId = CONCAT('AA:', app.ID)
LEFT JOIN SolarWindsOrion.dbo.APM_Component AS com ON a.EntityType = 'Orion.APM.Component' AND a.EntityNetObjectId = CONCAT('AM:', com.ID)
LEFT JOIN SolarWindsOrion.dbo.F5_LTM_Server AS f5s ON a.EntityType = 'Orion.F5.LTM.Server' AND a.EntityNetObjectId = CONCAT('F5S:', f5s.ServerID)
LEFT JOIN SolarWindsOrion.dbo.APIPoller_ApiPoller AS api ON a.EntityType = 'Orion.APIPoller.ApiPoller' AND a.EntityNetObjectId = CONCAT('OAPI:', api.Id)
--LEFT JOIN SolarWindsOrion.dbo.F5_LTM_Server AS f5p ON a.EntityType = 'Orion.F5.LTM.Pool' AND a.EntityNetObjectId = CONCAT('F5P:', f5p.ServerID)
) AS sub1
WHERE sub1.RealCaption != sub1.AlertCaption AND sub1.RealCaption != 'Error'