select to_char(max(event_date),'YYYY-MM-DD HH24:MI:SS') maxdate from acc_alarm_733_list where nwtype = 'WCDMA' select substr(ne,1,350) ne,substr(alarm,1,350) alarm,substr(ref,1,350) ref,substr(arsoutage,1,350) arsoutage,substr(tmosoutage,1,350) tmosoutage,substr(resource_group,1,350) resource_group,replace(replace(ptxt,chr(10),chr(13)),chr(34),' ') ptxt,substr(engineer,1,350) engineer,substr(phone,1,350) phone from v_fma_critical SELECT siteid, sitename, bsc, ref, fault_reason, isd_ref, status, outage, last_update, inception_time, severity, update_time_exp, tmn.getpriority_text (tmn.getpriority (siteid)) priority, tmn.getxalarms (siteid) xalarms, remedy.getplanned (siteid) planned, remedy.iscoallink (siteid) coallink, remedy.is_icc (siteid) specialevent, remedy.upd_time_expired (REF) updaterequired FROM tmn.v_fma_cellstatus WHERE bsc LIKE '%#bsc#%' bsc LIKE '%#ListFirst(session.bsc)#%' or bsc LIKE '%#ListGetAt(session.bsc, Counter)#%' order by last_update,priority desc SELECT ne, substr(cmd,1,100)||'
'||substr(cmd,101,length(cmd)-100) cmd, to_char(datum,'YYYY-MM-DD HH24:MI:SS') datum, username, cmd_type FROM command.v_all_cmd WHERE SUBSTR (cmd, 1, 5) LIKE '#cmdtext#' AND SUBSTR (cmd, 6) LIKE '%#paratext#%' AND datum BETWEEN TO_DATE ('#date1#', 'yyyy-mm-dd HH24:MI:SS') AND TO_DATE ('#date2#', 'yyyy-mm-dd HH24:MI:SS') AND ne = '#ne#' AND cmd_type = '#type#' ORDER by datum desc select nodename from axe_node WHERE type not in ('SDP','BGW') order by nodename select replace(fault_work_log,chr(13),'
') fault_work_log from v_nwm_faultlog_all where ref = '#ref#' SELECT ''||REF||'
' REF FROM mtn_eventlog WHERE status = 0 AND (event LIKE '%PLANNED%' OR event_category LIKE '%PLANNED%') AND (t_number = '#siteid#') SELECT COUNT (*) COUNT FROM mtn_eventlog WHERE status = 0 AND (event LIKE '%PLANNED%' OR event_category LIKE '%PLANNED%') AND (t_number = '#siteid#') SELECT REF FROM mtn_eventlog WHERE status = 0 AND (event LIKE '%PLANNED%' OR event_category LIKE '%PLANNED%') AND (t_number = '#siteid#') SELECT round(ksink.remedy_pkg.asnumdate(sdate), 0) sdate, severity, COUNT(*) AS events FROM ( SELECT trunc(event_time, 'HH24') AS sdate, upper(perceived_severity) AS severity FROM acc_alarm_733_list WHERE event_time > sysdate - 2 ) a GROUP BY sdate, severity ORDER BY sdate, severity