我正在尝试查看防病毒事件,这些事件将显示24小时内反病毒和防火墙的事件数。基本上,我尝试在不同的条件下对同一列求和。我曾尝试在SUM函数中使用CASE WHEN语句,但它不返回任何结果。
SELECT
events.arc_sourceHostName,
SUM(CASE WHEN events.arc_deviceEventClassId="fw" THEN events.arc_baseEventCount ELSE 0 END) AS "FWCount",
SUM(CASE WHEN events.arc_deviceEventClassId="av" THEN events.arc_baseEventCount ELSE 0 END) AS "AVCount"
FROM events
WHERE
events.arc_deviceVendor = "BitDefender"
AND
(events.arc_deviceEventClassId="fw"
OR
events.arc_deviceEventClassId="av")
GROUP BY
events.arc_sourceHostName
ORDER BY FWCount DESC更多细节
期望看到主机名,然后是AV事件数,然后是防火墙事件数。
Hostname AVCount FWCount
Host1 5 4
Host2 3 5发布于 2016-08-26 01:46:34
这个查询做的是你想要的吗?
SELECT e.arc_sourceHostName,
SUM(CASE WHEN e.arc_deviceEventClassId = 'fw' THEN e.arc_baseEventCount ELSE 0 END) AS FWCount,
SUM(CASE WHEN e.arc_deviceEventClassId = 'av' THEN e.arc_baseEventCount ELSE 0 END) AS AVCount
FROM events e
WHERE e.arc_deviceVendor = 'BitDefender' AND
e.deviceEventClassId IN ('fw', 'av')
GROUP BY e.arc_sourceHostName
ORDER BY FWCount DESC;如果这不起作用,那么可能没有满足WHERE条件的行。
https://stackoverflow.com/questions/39151592
复制相似问题