<cfquery datasource="#application.dbconnACC#" name="sitesDownQuery">
|
|
select siteid, sitename from acc_cellsupervision_list_v where severity='critical' order by sitename asc
|
|
</cfquery>
|
|
|
|
<cfquery datasource="#application.dbconnACC#" name="escInfQuery">
|
|
SELECT DISTINCT
|
|
a.resource_group,
|
|
CASE
|
|
WHEN b.text_message IS NULL THEN b.emailmessage
|
|
ELSE b.text_message
|
|
END
|
|
MESSAGE,
|
|
c.t_number siteid,
|
|
c.site,
|
|
d.create_date,
|
|
tmn.remedy_pkg.asdate(d.create_date) date_created
|
|
FROM aradmin.evt_escalationdestination a,
|
|
aradmin.evt_escalationinformationaudit b,
|
|
aradmin.evt_eventlog c,
|
|
aradmin.evt_escalationandinformation d
|
|
WHERE a.guid = b.guid AND c.status = 0 AND d.smcref = c.eventlog_id
|
|
AND b.escalationid = d.request_id
|
|
and A.RESOURCE_GROUP IS NOT NULL
|
|
and (resource_group Like '%SMC%')
|
|
order by d.create_date desc
|
|
|
|
<!---and tmn.remedy_pkg.asdate(d.create_date) >= sysdate-1--->
|
|
</cfquery>
|
|
|
|
|
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|
<html xmlns="http://www.w3.org/1999/xhtml"1>
|
|
<head>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
|
<title>Marquee</title>
|
|
<link rel="stylesheet" type="text/css" href="../common/css/default.css">
|
|
</head>
|
|
|
|
<body>
|
|
<table border="0" cellpadding="0" cellspacing="0" width="100%" style="border:1px;border-style:solid;">
|
|
<tr>
|
|
<td width="10%" nowrap><strong>Escalations (<cfoutput>#escInfQuery.RecordCount#</cfoutput>)<br></strong>
|
|
</td>
|
|
<td width="100%">
|
|
<marquee align="left" behavior="scroll" direction="left" loop="-1" scrollamount="3">
|
|
<cfset bgColor = "##EEEEEE">
|
|
<cfset count = 0>
|
|
<cfoutput query="escInfQuery">
|
|
<span style="background:#bgColor#;padding:2px 2px 2px 2px;"><strong>#count + 1#/#escInfQuery.RecordCount#:</strong> #date_created# - #resource_group# - #siteid# - #site# - #message#</span>
|
|
<cfset count = count + 1>
|
|
<cfif count mod 2 is 1>
|
|
<cfset bgColor = "##EEEEEE">
|
|
<cfelse>
|
|
<cfset bgColor = "##DDDDDD">
|
|
</cfif>
|
|
</cfoutput>
|
|
</marquee>
|
|
<br />
|
|
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td width="10%" nowrap><strong>Critical Sites down (<cfoutput>#sitesDownQuery.RecordCount#)</cfoutput></strong>
|
|
</td>
|
|
<td>
|
|
<marquee align="left" behavior="scroll" direction="left" loop="-1" scrollamount="5">
|
|
<cfset bgColor = "##FFFFFF">
|
|
<cfset count = 0>
|
|
<cfoutput query="sitesDownQuery">
|
|
<span style="background:#bgColor#;padding:2px 2px 2px 2px;"><strong>#count + 1#/#sitesDownQuery.RecordCount#:</strong> #siteid# - #sitename#</span> |
|
|
<cfset count = count + 1>
|
|
<cfif count mod 2 is 1>
|
|
<cfset bgColor = "##DDDDDD">
|
|
<cfelse>
|
|
<cfset bgColor = "##FFFFFF">
|
|
</cfif>
|
|
</cfoutput>
|
|
</marquee>
|
|
</marquee>
|
|
|
|
</td>
|
|
</table>
|
|
|
|
</body>
|
|
</html>
|
|
