SELECT
av.LastModified,
av.AlertStringName,
av.Severity,
av.MonitoringObjectPath,
MonitoringObjectDisplayName,
mp.MPName AS ManagementPack
FROM
opdb.dbo.AlertView (NOLOCK) av
LEFT JOIN
opdb.dbo.RuleView (NOLOCK) Rv
ON av.MonitoringRuleId = rv.Id
JOIN opdb.dbo.ManagementPack mp
ON rv.ManagementPackId = mp.ManagementPackId
where av.ResolutionState = 0
and MonitoringObjectpath in ('hostname','hostname2')
UNION
SELECT
av.LastModified,
av.AlertStringName,
av.Severity,
av.MonitoringObjectPath,
MonitoringObjectDisplayName,
mp.MPName AS ManagementPack
FROM
opdb.dbo.AlertView (NOLOCK) av JOIN opdb.dbo.MonitorView (NOLOCK) Mv
ON av.MonitoringRuleId = Mv.Id
JOIN opdb.dbo.ManagementPack mp
ON mv.ManagementPackId = mp.ManagementPackId
where av.ResolutionState = 0 and MonitoringObjectpath in ('hostname','hostname2')