| |
|
Line 104
|
Parallel
|
Line 104
|
Parallel
|
| 104 |
a.alarmid as alarmid,e.eventtype as eventtype, e.eventtypeid as eventtypeid,s.severity as severity,s.severity as severityname, |
104 |
a.alarmid as alarmid,e.eventtype as eventtype, e.eventtypeid as eventtypeid,s.severity as severity,s.severity as severityname, |
| 105 |
rd.resourceid as resourceid, rd.resourcename as qf_resourcename,a.source as qf_source, rd.resourcename as resourcename,a.source as source, a.createdtime as createdtime,a.updatedtime as updatedtime, |
105 |
rd.resourceid as resourceid, rd.resourcename as qf_resourcename,a.source as qf_source, rd.resourcename as resourcename,a.source as source, a.createdtime as createdtime,a.updatedtime as updatedtime, |
| 106 |
a.acktime as acktime,a.clearedtime as clrdtime,a.owner as owner,a.ackstatus as ack, |
106 |
a.acktime as acktime,a.clearedtime as clrdtime,a.owner as owner,a.ackstatus as ack, |
| 107 |
a.message as msg,a.remedy as remedy,a.optionalfield as optionalfield,a.category as category,a.version as version,rc.component_index as compindex, |
107 |
a.message as msg,a.remedy as remedy,a.category as category,a.version as version,rc.component_index as compindex, |
| 108 |
cd.colorname as color,a.severityid as severityid |
108 |
cd.colorname as color,s.severityid as severityid |
| 109 |
FROM |
109 |
FROM |
| 110 |
SEVERITY s, EVENTTYPE e, COLORDETAILS cd, RESOURCEDETAILS rd, ALARMARCHIVE a left join |
110 |
SEVERITY s, EVENTTYPE e, COLORDETAILS cd, RESOURCEDETAILS rd, ALARMARCHIVE a left join |
| 111 |
RESOURCECOMPONENT rc on rc.componentid = a.componentid |
111 |
RESOURCECOMPONENT rc on rc.componentid = a.componentid |
| 112 |
WHERE |
112 |
WHERE |
| 113 |
(s.severitycolorid = cd.colorid and a.severityid = s.severityid and |
113 |
(s.severitycolorid = cd.colorid and a.severity = s.severity and |
| 114 |
a.eventtypeid = e.eventtypeid and rd.resourceid = a.resourceid) |
114 |
a.eventtype = e.eventtype and rd.resourcename = a.resourcename) |
| 115 |
/~alarmid: a.alarmid {alarmid}~/ |
115 |
/~alarmid: a.alarmid {alarmid}~/ |
| 116 |
/~eventtype: upper(e.eventtype) {eventtype}~/ |
116 |
/~eventtype: upper(e.eventtype) {eventtype}~/ |
| 117 |
/~eventtypeid: upper(e.eventtypeid) {eventtypeid}~/ |
117 |
/~eventtypeid: upper(e.eventtypeid) {eventtypeid}~/ |
| |
| |
|
Line 130
|
Parallel
|
Line 130
|
Parallel
|
| 130 |
/~ack: upper(a.ackstatus) {ack}~/ |
130 |
/~ack: upper(a.ackstatus) {ack}~/ |
| 131 |
/~msg: upper(a.message) {msg}~/ |
131 |
/~msg: upper(a.message) {msg}~/ |
| 132 |
/~remedy: upper(CASE WHEN a.remedy is null THEN ' ' ELSE a.remedy END) {remedy}~/ |
132 |
/~remedy: upper(CASE WHEN a.remedy is null THEN ' ' ELSE a.remedy END) {remedy}~/ |
| 133 |
/~optionalfield: upper(CASE WHEN a.optionalfield is null THEN ' ' ELSE a.optionalfield END) {optionalfield}~/ |
|
|
| 134 |
/~category: upper(a.category) {category}~/ |
133 |
/~category: upper(a.category) {category}~/ |
| 135 |
/~version: upper(a.version) {version}~/ |
134 |
/~version: upper(a.version) {version}~/ |
| 136 |
/~SORT_COLUMN: ORDER BY [SORT_COLUMN] [SORT_DIRECTION]~/" /> |
135 |
/~SORT_COLUMN: ORDER BY [SORT_COLUMN] [SORT_DIRECTION]~/" /> |
| |
| |
|
Line 295
|
Parallel
|
Line 294
|
Parallel
|
| 295 |
<query id="LogViewer" value="select |
294 |
<query id="LogViewer" value="select |
| 296 |
el.eventid as id, et.eventtype as type, st.severity as severity,rd.resourcename as qf_resourcename,el.source as qf_source, |
295 |
el.eventid as id, et.eventtype as type, st.severity as severity,rd.resourcename as qf_resourcename,el.source as qf_source, |
| 297 |
rd.resourcename as resourcename,el.source as source, el.eventtime as eventtime, el.message as message, |
296 |
rd.resourcename as resourcename,el.source as source, el.eventtime as eventtime, el.message as message, |
| 298 |
el.remedy as remedy, el.optionalfield as optionalfield, el.category as category, rc.component_index as compindex, cd.colorname as color |
297 |
el.remedy as remedy, el.category as category, rc.component_index as compindex, cd.colorname as color |
| 299 |
FROM |
298 |
FROM |
| 300 |
EVENTTYPE et, SEVERITY st, COLORDETAILS cd, RESOURCEDETAILS rd, |
299 |
EVENTTYPE et, SEVERITY st, COLORDETAILS cd, RESOURCEDETAILS rd, |
| 301 |
LOGARCHIVE el left join RESOURCECOMPONENT rc on rc.componentid = el.componentid |
300 |
LOGARCHIVE el left join RESOURCECOMPONENT rc on rc.componentid = el.componentid |
| 302 |
WHERE |
301 |
WHERE |
| 303 |
(st.severitycolorid = cd.colorid and el.eventtypeid != 4 and et.eventtypeid = el.eventtypeid |
302 |
(st.severitycolorid = cd.colorid and el.eventtype != 'SYSLOG' and et.eventtype = el.eventtype |
| 304 |
and el.severityid=st.severityid and rd.resourceid = el.resourceid) |
303 |
and el.severity=st.severity and rd.resourcename = el.resourcename) |
| 305 |
/~id: (el.eventid) {id}~/ |
304 |
/~id: (el.eventid) {id}~/ |
| 306 |
/~type: upper(et.eventtype) {type}~/ |
305 |
/~type: upper(et.eventtype) {type}~/ |
| 307 |
/~severity: upper( st.severity) {severity}~/ |
306 |
/~severity: upper( st.severity) {severity}~/ |
| |
| |
|
Line 312
|
Parallel
|
Line 311
|
Parallel
|
| 312 |
/~eventtime: (el.eventtime ) {eventtime}~/ |
311 |
/~eventtime: (el.eventtime ) {eventtime}~/ |
| 313 |
/~message: upper(el.message ) {message}~/ |
312 |
/~message: upper(el.message ) {message}~/ |
| 314 |
/~remedy: upper(CASE WHEN el.remedy is null THEN ' ' ELSE el.remedy END) {remedy}~/ |
313 |
/~remedy: upper(CASE WHEN el.remedy is null THEN ' ' ELSE el.remedy END) {remedy}~/ |
| 315 |
/~optionalfield: upper(CASE WHEN el.optionalfield is null THEN ' ' ELSE el.optionalfield END) {optionalfield}~/ |
|
|
| 316 |
/~category: upper(el.category ) {category}~/ |
314 |
/~category: upper(el.category ) {category}~/ |
| 317 |
/~version: upper(el.version ) {version}~/ |
315 |
/~version: upper(el.version ) {version}~/ |
| 318 |
/~SORT_COLUMN: ORDER BY [SORT_COLUMN] [SORT_DIRECTION]~/" /> |
316 |
/~SORT_COLUMN: ORDER BY [SORT_COLUMN] [SORT_DIRECTION]~/" /> |
| |