select siteid, sitename from acc_cellsupervision_list_v where severity='critical' order by sitename asc 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

Escalations (#escInfQuery.RecordCount#)	#count + 1#/#escInfQuery.RecordCount#: #date_created# - #resource_group# - #siteid# - #site# - #message#
Critical Sites down (#sitesDownQuery.RecordCount#)	#count + 1#/#sitesDownQuery.RecordCount#: #siteid# - #sitename# |