工作常用笔记
常用sql语句记录
dingpeng 发表于2025-01-10 浏览493 评论0
历史告警导出
Select
OBJID as FSUID,
OBJNAME as FSU名称,
SUBOBJID as 设备ID,
ALARMLEVEL as 告警等级,
ALARMNAME as 告警名称,
DETAILINFO as 告警信息,
INSERTTIME as 告警开始时间,
CLEARSYSTEMTIME as 告警清除时间,
FAULTID as 工单号,
CLEARCAUSE as 告警清除方式,
STATIONID as 站址系统编码,
STATIONSTATUS as 站址状态,
MID as 信号量
from
itower.V_IF_PROV_ALARM_JSFGS
WHERE
CLEARSYSTEMTIME >= TO_DATE('2022-03-01 00:00:00','yyyy-MM-dd HH24:MI:ss') AND CLEARSYSTEMTIME < TO_DATE('2022-04-01 00:00:00','yyyy-MM-dd HH24:MI:ss')