17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT
A.SEVERITY,
A.FIRSTOCCUR
FROM
(
SELECT
*
FROM
FM_ACTIVE_EVENT
WHERE
EVENTSOURCE = 'Polling'
AND FIRSTOCCUR < '1466587800'
AND FIRSTOCCUR > '1466555400'
AND EXTEND15 = 291
UNION
SELECT
*
FROM
FM_HIST_EVENT
WHERE
EVENTSOURCE = 'Polling'
AND FIRSTOCCUR < '1466587800'
AND FIRSTOCCUR > '1466555400'
AND EXTEND15 = 291
) A
ORDER BY
A.FIRSTOCCUR DESC