邮件筛选sql:
select userid,name, sum(case when subject like '%CPU systime%' then 1 end) systime, sum(case when subject like '%CPU USE%' then 1 end) cpuuse, sum(case when subject like '%Disk I%' then 1 end) diskio, sum(case when subject like '%available memory%' then 1 end) mem, sum(case when subject like '%is unreachable%' then 1 end) downtime, sum(case when subject like '%restarted%' then 1 end) restart, sum(case when subject like '%has been changed%' then 1 end) passchange, sum(case when subject like '%Free disk%' then 1 end) disk, sum(case when subject not like '%CPU%' and subject not like '%available memory%' and subject not like '%Disk%' and subject not like '%is unreachable%' and subject not like '%restart%' and subject not like '%has been changed%' and subject not like '%disk%' then 1 end) other from (select a.userid,c.name,a.subject from alerts a,users c where a.mediatypeid='6' and a.clock>'1392220800' and a.clock'1392220800' and a.clock