odbtools/odbctest/mql/test/cachenormal/3select.mql

-- select class,id,name,day,vtime,status,duration from /cache/nalerts_status order by vtime
-- /**
--     output()
-- **/
-- ;


SELECT
 max(type) as "最大值", min(type) as "最小值", avg(type), sum(type), count(*)
FROM
  /cache/nalerts_status
-- where agent='huawei mttrapd #48' and node='222.129.134.178'
/**
    output()
**/
;


select class, id, day, vtime, node, type from /cache/nalerts_status
--  where type = null
/**
    output()
**/
;


-- select count(*),min(vtime) as minvtime,max(vtime),sum(vtime),avg(vtime),day,node,status from /cache/nalerts_status
--  where status>100 and status <300 and node!='node:node:192.168.0.11'
--  group by day
--  order by node desc
-- /**
--     output()
-- **/
-- ;