复制selectuserid,监控name,sum(casewhensubjectlike%CPUsystime%then1end)systime,sum(casewhensubjectlike%CPUUSE%then1end)cpuuse,sum(casewhensubjectlike%DiskI%then1end)diskio,sum(casewhensubjectlike%availablememory%then1end)mem,sum(casewhensubjectlike%isunreachable%then1end)downtime,sum(casewhensubjectlike%restarted%then1end)restart,sum(casewhensubjectlike%hasbeenchanged%then1end)passchange,sum(casewhensubjectlike%Freedisk%then1end)disk,sum(casewhensubjectnotlike%CPU%andsubjectnotlike%availablememory%andsubjectnotlike%Disk%andsubjectnotlike%isunreachable%andsubjectnotlike%restart%andsubjectnotlike%hasbeenchanged%andsubjectnotlike%disk%then1end)otherfrom(selecta.userid,c.name,a.subjectfromalertsa,userscwherea.mediatypeid=6anda.clock>1392220800anda.clock<1392307200anda.userid=c.useridanda.status=1anda.subjectnotlike%OK%)atgroupbyuserid; 1.

(责任编辑：数据库)