通信人家园

标题: 基于NSN的SQL告警提取脚本 [查看完整版帖子] [打印本页]

时间: 2013-8-15 08:54

作者: laiss 标题: 基于NSN的SQL告警提取脚本

select c_bts.cell_id,
   a.alarm_time,
   a.cancel_time,
   a.dn,
   a.user_additional_info,
   a.alarm_status,
   a.alarm_number,
   a.text,
   a.alarm_type,
   a.supplementary_info
from fx_alarm a,c_bts
where a.alarm_time >= to_date('2013070908', 'yyyymmddhh24')
   and a.alarm_time <= to_date('2013070910', 'yyyymmddhh24')
   and c_bts.int_id = a.int_id

通信人家园 (https://www.txrjy.com/)