yKc1cHzm

1--
2-- Table structure for table `Test_Alarms`
3--
4
5CREATE TABLE IF NOT EXISTS `Test_Alarms` (
6  `alarmid` bigint(20) NOT NULL AUTO_INCREMENT,
7  `alarmname` varchar(125) DEFAULT NULL,
8  `occurrencedate` datetime DEFAULT NULL,
9  `description` varchar(255) DEFAULT NULL,
10  `status` varchar(255) DEFAULT NULL,
11  PRIMARY KEY (`alarmid`),
12  UNIQUE KEY `alarmid` (`alarmid`),
13  KEY `alarmsStatus` (`status`),
14  KEY `idxOccurrenceDate` (`occurrencedate`)
15) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23967 ;
16
17--
18-- Dumping data for table `Test_Alarms`
19--
20
21INSERT INTO `Test_Alarms` (`alarmid`, `alarmname`, `occurrencedate`, `description`, `status`) VALUES
22(23851, 'EF_2_Endswitch', '2018-11-03 12:51:13', 'EF-2 Damper Status Alarm', 'Clear'),
23(23859, 'EF_2_Endswitch', '2018-11-03 19:22:37', 'EF-2 Damper Status Alarm', 'Clear'),
24(23850, 'EF_2_Endswitch', '2018-11-03 12:46:28', 'EF-2 Damper Status Alarm', 'Clear'),
25(23849, 'EF_2_Endswitch', '2018-11-03 12:17:56', 'EF-2 Damper Status Alarm', 'Clear'),
26(23848, 'EF_2_Endswitch', '2018-11-03 12:13:11', 'EF-2 Damper Status Alarm', 'Clear'),
27(23847, 'Hot_Water_Pump_2_Status', '2018-11-03 12:02:37', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
28(23846, 'Hot_Water_Pump_2_Status', '2018-11-03 11:59:22', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
29(23845, 'DTS_P2_CT', '2018-11-03 11:26:08', 'Dual Temp System - Pump 2 Status Alarm', 'Clear'),
30(23757, 'Chilled_Water_Pump_3_Status', '2018-11-02 14:54:52', 'Secondary Chilled Water System - Pump 3 Status Alarm', 'Clear'),
31(23758, 'Hot_Water_Pump_4_Status', '2018-11-02 14:54:51', 'Hot Water System - Pump 4 Status Alarm', 'Clear'),
32(23759, 'Exhaust_Fan_2_Status', '2018-11-02 14:54:54', 'Exhaust Fan 2 Childcare Status Alarm', ''),
33(23760, 'Exhaust_Fan_3_Status', '2018-11-02 14:55:09', 'Exhaust Fan 3 Childcare Status Alarm', ''),
34(23761, 'Exhaust_Fan_2_Status', '2018-11-02 14:55:12', 'Lab 6th Floor - Exhaust Fan 2 Status Alarm', 'Clear'),
35(23762, 'AHU2_Supply_Air_Fan_Status', '2018-11-02 14:55:25', 'AHUs - AHU2 Supply Air Fan Status Alarm', 'Clear'),
36(23763, 'Glasswash_EF_2_Status', '2018-11-02 14:55:25', 'Glasswash EF-2 (2nd flr) Status Alarm', ''),
37(23764, 'Glasswash_EF_1_Status', '2018-11-02 14:55:46', 'Glasswash EF-1 (2nd flr) Status Alarm', ''),
38(23765, 'Exhaust_Air_Fan_Status', '2018-11-02 14:55:52', 'Lab AHU - Exhaust Air Fan Status Alarm', ''),
39(23766, 'Supply_Air_Fan_Status', '2018-11-02 14:55:52', 'MAU 260 - Supply Air Fan Status Alarm', ''),
40(23843, 'DTS_P2_CT', '2018-11-03 11:21:23', 'Dual Temp System - Pump 2 Status Alarm', 'Clear'),
41(23844, 'DTS_P2_DP', '2018-11-03 11:26:08', 'Dual Temp System - Pump 2 Flow Status Alarm', 'Clear'),
42(23842, 'DTS_P2_DP', '2018-11-03 11:21:38', 'Dual Temp System - Pump 2 Flow Status Alarm', 'Clear'),
43(23841, 'Hot_Water_Pump_2_Status', '2018-11-03 11:12:49', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
44(23840, 'Hot_Water_Pump_2_Status', '2018-11-03 11:10:04', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
45(23839, 'Hot_Water_Pump_2_Status', '2018-11-03 10:43:02', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
46(23802, 'Hot_Water_Pump_2_Status', '2018-11-03 06:01:30', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
47(23800, 'Hot_Water_Pump_2_Status', '2018-11-03 05:46:29', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
48(23801, 'Hot_Water_Pump_2_Status', '2018-11-03 05:49:30', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
49(23838, 'Hot_Water_Pump_2_Status', '2018-11-03 10:40:02', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
50(23837, 'Hot_Water_Pump_2_Status', '2018-11-03 10:28:01', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
51(23836, 'Hot_Water_Pump_2_Status', '2018-11-03 10:24:46', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
52(23835, 'Hot_Water_Pump_2_Status', '2018-11-03 10:13:00', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
53(23965, 'Chilled_Water_Pump_3_Status', '2018-11-05 10:02:56', 'Secondary Chilled Water System - Pump 3 Status Alarm', ''),
54(23964, 'Chilled_Water_Pump_3_Status', '2018-11-05 09:58:10', 'Secondary Chilled Water System - Pump 3 Status Alarm', 'Clear'),
55(23963, 'Exhaust_Fan_2_Status', '2018-11-05 07:26:04', 'Lab 6th Floor - Exhaust Fan 2 Status Alarm', ''),
56(23962, 'Exhaust_Fan_2_Status', '2018-11-05 07:21:03', 'Lab 6th Floor - Exhaust Fan 2 Status Alarm', 'Clear'),
57(23834, 'Hot_Water_Pump_2_Status', '2018-11-03 10:10:00', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
58(23961, 'Exhaust_Fan_2_Status', '2018-11-05 07:16:41', 'Lab 6th Floor - Exhaust Fan 2 Status Alarm', 'Clear'),
59(23833, 'Hot_Water_Pump_2_Status', '2018-11-03 09:58:15', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
60(23832, 'Hot_Water_Pump_2_Status', '2018-11-03 09:54:59', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
61(23831, 'Hot_Water_Pump_2_Status', '2018-11-03 09:43:14', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
62(23830, 'Hot_Water_Pump_2_Status', '2018-11-03 09:39:59', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
63(23829, 'Hot_Water_Pump_2_Status', '2018-11-03 09:28:13', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
64(23828, 'Hot_Water_Pump_2_Status', '2018-11-03 09:24:58', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
65(23827, 'Hot_Water_Pump_2_Status', '2018-11-03 09:13:12', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
66(23826, 'Hot_Water_Pump_2_Status', '2018-11-03 09:09:57', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
67(23825, 'Hot_Water_Pump_2_Status', '2018-11-03 08:58:11', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
68(23824, 'Hot_Water_Pump_2_Status', '2018-11-03 08:54:56', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
69(23823, 'Hot_Water_Pump_2_Status', '2018-11-03 08:43:10', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
70(23822, 'Hot_Water_Pump_2_Status', '2018-11-03 08:39:55', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
71(23821, 'Hot_Water_Pump_2_Status', '2018-11-03 08:27:54', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
72(23820, 'Hot_Water_Pump_2_Status', '2018-11-03 08:16:09', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
73(23819, 'Hot_Water_Pump_2_Status', '2018-11-03 08:04:23', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
74(23818, 'Hot_Water_Pump_2_Status', '2018-11-03 08:01:23', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
75(23817, 'Hot_Water_Pump_2_Status', '2018-11-03 07:49:22', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
76(23816, 'Hot_Water_Pump_2_Status', '2018-11-03 07:46:37', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
77(23815, 'Hot_Water_Pump_2_Status', '2018-11-03 07:34:36', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
78(23814, 'Hot_Water_Pump_2_Status', '2018-11-03 07:31:21', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
79(23813, 'Hot_Water_Pump_2_Status', '2018-11-03 07:19:35', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
80(23812, 'Hot_Water_Pump_2_Status', '2018-11-03 07:17:05', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
81(23793, 'Hot_Water_Pump_2_Status', '2018-11-03 02:43:48', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
82(23794, 'Hot_Water_Pump_2_Status', '2018-11-03 04:30:10', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
83(23795, 'Hot_Water_Pump_2_Status', '2018-11-03 04:33:10', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
84(23796, 'Hot_Water_Pump_2_Status', '2018-11-03 05:01:27', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
85(23797, 'Hot_Water_Pump_2_Status', '2018-11-03 05:04:27', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
86(23798, 'Hot_Water_Pump_2_Status', '2018-11-03 05:31:13', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
87(23799, 'Hot_Water_Pump_2_Status', '2018-11-03 05:34:29', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
88(23811, 'Hot_Water_Pump_2_Status', '2018-11-03 07:04:34', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
89(23810, 'Hot_Water_Pump_2_Status', '2018-11-03 07:01:19', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
90(23809, 'Hot_Water_Pump_2_Status', '2018-11-03 06:49:33', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
91(23808, 'Hot_Water_Pump_2_Status', '2018-11-03 06:46:18', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
92(23807, 'Hot_Water_Pump_2_Status', '2018-11-03 06:34:32', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
93(23806, 'Hot_Water_Pump_2_Status', '2018-11-03 06:31:17', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
94(23960, 'AHU2_Supply_Air_Fan_Status', '2018-11-05 07:14:32', 'AHUs - AHU2 Supply Air Fan Status Alarm', ''),
95(23791, 'Hot_Water_Pump_2_Status', '2018-11-03 01:58:46', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
96(23792, 'Hot_Water_Pump_2_Status', '2018-11-03 02:40:48', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
97(23790, 'Hot_Water_Pump_2_Status', '2018-11-03 01:55:30', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
98(23789, 'Hot_Water_Pump_2_Status', '2018-11-03 01:28:44', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
99(23788, 'Hot_Water_Pump_2_Status', '2018-11-03 01:25:29', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
100(23786, 'Hot_Water_Pump_2_Status', '2018-11-03 00:52:41', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
101(23787, 'Hot_Water_Pump_2_Status', '2018-11-03 00:55:57', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
102(23784, 'Hot_Water_Pump_2_Status', '2018-11-03 00:22:40', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
103(23785, 'Hot_Water_Pump_2_Status', '2018-11-03 00:25:55', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
104(23783, 'Supply_Air_Fan_Status', '2018-11-03 00:01:27', 'AHU-1 - Supply Air Fan Status Alarm', 'Clear'),
105(23782, 'Hot_Water_Pump_2_Status', '2018-11-02 23:55:53', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
106(23781, 'Hot_Water_Pump_2_Status', '2018-11-02 23:52:38', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
107(23769, 'Hot_Water_Pump_4_Status', '2018-11-02 19:14:37', 'Hot Water System - Pump 4 Status Alarm', ''),
108(23770, 'EF_2_Endswitch', '2018-11-02 19:22:09', 'EF-2 Damper Status Alarm', 'Clear'),
109(23771, 'EF_2_Endswitch', '2018-11-02 19:27:25', 'EF-2 Damper Status Alarm', 'Clear'),
110(23772, 'Chilled_Water_Pump_5_Status', '2018-11-02 20:43:59', 'Secondary Chilled Water System - Pump 5 Status Alarm', 'Clear'),
111(23773, 'Chilled_Water_Pump_5_Status', '2018-11-02 20:48:58', 'Secondary Chilled Water System - Pump 5 Status Alarm', 'Clear'),
112(23774, 'Hot_Water_Pump_2_Status', '2018-11-02 22:53:04', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
113(23775, 'Hot_Water_Pump_2_Status', '2018-11-02 22:56:05', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
114(23776, 'Supply_Air_Fan_Status', '2018-11-02 23:03:23', 'AHU-1 - Supply Air Fan Status Alarm', 'Clear'),
115(23777, 'Hot_Water_Pump_2_Status', '2018-11-02 23:07:50', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
116(23778, 'Hot_Water_Pump_2_Status', '2018-11-02 23:10:50', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
117(23779, 'Hot_Water_Pump_2_Status', '2018-11-02 23:22:36', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
118(23780, 'Hot_Water_Pump_2_Status', '2018-11-02 23:25:51', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
119(23959, 'EF_2_Endswitch', '2018-11-05 07:13:20', 'EF-2 Damper Status Alarm', ''),
120(23958, 'Filter_Status', '2018-11-05 07:12:49', 'AHU - Filter Alarm', ''),
121(23957, 'Filter_Status', '2018-11-05 07:09:16', 'AHU - Filter Alarm', 'Clear'),
122(23956, 'EF_2_Endswitch', '2018-11-05 07:08:50', 'EF-2 Damper Status Alarm', 'Clear'),
123(23955, 'Filter_Status', '2018-11-05 07:08:59', 'AHU - Filter Alarm', 'Clear'),
124(23954, 'Filter_Status', '2018-11-05 07:02:23', 'AHU - Filter Alarm', 'Clear'),
125(23953, 'AHU2_Supply_Air_Fan_Status', '2018-11-05 07:01:25', 'AHUs - AHU2 Supply Air Fan Status Alarm', 'Clear'),
126(23768, 'Hot_Water_Pump_4_Status', '2018-11-02 19:09:51', 'Hot Water System - Pump 4 Status Alarm', 'Clear'),
127(23952, 'Exhaust_Fan_2_Status', '2018-11-05 07:01:27', 'Lab 6th Floor - Exhaust Fan 2 Status Alarm', 'Clear'),
128(23951, 'AHU2_Supply_Air_Fan_Status', '2018-11-05 05:47:55', 'AHUs - AHU2 Supply Air Fan Status Alarm', 'Clear'),
129(23767, 'Supply_Air_Fan_Status', '2018-11-02 14:56:12', 'AH2 - Supply Air Fan Status Alarm', ''),
130(23950, 'Exhaust_Fan_2_Status', '2018-11-05 05:47:52', 'Lab 6th Floor - Exhaust Fan 2 Status Alarm', 'Clear'),
131(23949, 'Filter_Status', '2018-11-05 05:46:24', 'AHU - Filter Alarm', 'Clear'),
132(23948, 'Filter_Status', '2018-11-05 05:39:54', 'AHU - Filter Alarm', 'Clear'),
133(23947, 'AHU2_Supply_Air_Fan_Status', '2018-11-05 05:33:47', 'AHUs - AHU2 Supply Air Fan Status Alarm', 'Clear'),
134(23918, 'DTS_P1_DP', '2018-11-04 10:16:50', 'Dual Temp System - Pump 1 Flow Status Alarm', 'Cleared'),
135(23917, 'DTS_P2_CT', '2018-11-04 10:14:15', 'Dual Temp System - Pump 2 Status Alarm', 'Cleared'),
136(23916, 'DTS_P2_DP', '2018-11-04 10:14:00', 'Dual Temp System - Pump 2 Flow Status Alarm', 'Cleared'),
137(23915, 'Hot_Water_Pump_2_Status', '2018-11-04 09:42:59', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
138(23914, 'Hot_Water_Pump_2_Status', '2018-11-04 09:39:44', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
139(23913, 'Hot_Water_Pump_2_Status', '2018-11-04 09:27:59', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
140(23912, 'Hot_Water_Pump_2_Status', '2018-11-04 09:24:43', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
141(23946, 'Filter_Status', '2018-11-05 05:33:46', 'AHU - Filter Alarm', 'Clear'),
142(23911, 'Hot_Water_Pump_2_Status', '2018-11-04 09:12:58', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
143(23910, 'Hot_Water_Pump_2_Status', '2018-11-04 09:09:42', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
144(23909, 'Hot_Water_Pump_2_Status', '2018-11-04 08:57:56', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
145(23908, 'Hot_Water_Pump_2_Status', '2018-11-04 08:54:42', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
146(23907, 'Hot_Water_Pump_2_Status', '2018-11-04 08:42:56', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
147(23906, 'Hot_Water_Pump_2_Status', '2018-11-04 08:39:56', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
148(23905, 'Hot_Water_Pump_2_Status', '2018-11-04 08:27:55', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
149(23904, 'Hot_Water_Pump_2_Status', '2018-11-04 08:24:25', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
150(23903, 'Hot_Water_Pump_2_Status', '2018-11-04 08:12:24', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
151(23902, 'DTS_P2_CT', '2018-11-04 07:43:39', 'Dual Temp System - Pump 2 Status Alarm', ''),
152(23901, 'DTS_P2_DP', '2018-11-04 07:43:39', 'Dual Temp System - Pump 2 Flow Status Alarm', ''),
153(23900, 'DTS_P2_CT', '2018-11-04 07:38:54', 'Dual Temp System - Pump 2 Status Alarm', 'Clear'),
154(23945, 'Exhaust_Fan_2_Status', '2018-11-05 05:33:36', 'Lab 6th Floor - Exhaust Fan 2 Status Alarm', 'Clear'),
155(23944, 'Exhaust_Fan_2_Status', '2018-11-05 04:33:34', 'Lab 6th Floor - Exhaust Fan 2 Status Alarm', 'Clear'),
156(23943, 'Filter_Status', '2018-11-05 04:31:55', 'AHU - Filter Alarm', 'Clear'),
157(23899, 'DTS_P2_DP', '2018-11-04 07:38:53', 'Dual Temp System - Pump 2 Flow Status Alarm', 'Clear'),
158(23942, 'Filter_Status', '2018-11-05 04:28:23', 'AHU - Filter Alarm', 'Clear'),
159(23941, 'Exhaust_Fan_2_Status', '2018-11-05 04:28:10', 'Lab 6th Floor - Exhaust Fan 2 Status Alarm', 'Clear'),
160(23898, 'Hot_Water_Pump_2_Status', '2018-11-04 06:26:32', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
161(23897, 'Hot_Water_Pump_2_Status', '2018-11-04 06:14:32', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
162(23896, 'Chilled_Water_Pump_3_Status', '2018-11-04 05:50:45', 'Secondary Chilled Water System - Pump 3 Status Alarm', 'Clear'),
163(23895, 'Chilled_Water_Pump_5_Status', '2018-11-04 05:50:30', 'Secondary Chilled Water System - Pump 5 Status Alarm', 'Clear'),
164(23894, 'Chilled_Water_Pump_3_Status', '2018-11-04 05:45:44', 'Secondary Chilled Water System - Pump 3 Status Alarm', 'Clear'),
165(23893, 'Chilled_Water_Pump_5_Status', '2018-11-04 05:45:44', 'Secondary Chilled Water System - Pump 5 Status Alarm', 'Clear'),
166(23892, 'Chilled_Water_Pump_3_Status', '2018-11-04 01:55:45', 'Secondary Chilled Water System - Pump 3 Status Alarm', 'Clear'),
167(23891, 'Chilled_Water_Pump_5_Status', '2018-11-04 01:55:45', 'Secondary Chilled Water System - Pump 5 Status Alarm', 'Clear'),
168(23890, 'Chilled_Water_Pump_3_Status', '2018-11-04 01:51:00', 'Secondary Chilled Water System - Pump 3 Status Alarm', 'Clear'),
169(23889, 'Chilled_Water_Pump_5_Status', '2018-11-04 01:51:00', 'Secondary Chilled Water System - Pump 5 Status Alarm', 'Clear'),
170(23888, 'Chilled_Water_Pump_3_Status', '2018-11-04 00:39:22', 'Secondary Chilled Water System - Pump 3 Status Alarm', 'Clear'),
171(23940, 'Exhaust_Fan_2_Status', '2018-11-05 03:53:13', 'Lab 6th Floor - Exhaust Fan 2 Status Alarm', 'Clear'),
172(23887, 'Chilled_Water_Pump_5_Status', '2018-11-04 00:39:07', 'Secondary Chilled Water System - Pump 5 Status Alarm', 'Clear'),
173(23886, 'Chilled_Water_Pump_3_Status', '2018-11-04 00:34:22', 'Secondary Chilled Water System - Pump 3 Status Alarm', 'Clear'),
174(23885, 'Chilled_Water_Pump_5_Status', '2018-11-04 00:34:22', 'Secondary Chilled Water System - Pump 5 Status Alarm', 'Clear'),
175(23884, 'DTS_P2_DP', '2018-11-04 00:20:26', 'Dual Temp System - Pump 2 Flow Status Alarm', 'Clear'),
176(23883, 'DTS_P2_DP', '2018-11-04 00:15:40', 'Dual Temp System - Pump 2 Flow Status Alarm', 'Clear'),
177(23882, 'Supply_Air_Fan_Status', '2018-11-04 00:01:08', 'AHU-1 - Supply Air Fan Status Alarm', 'Clear'),
178(23881, 'PROG2_STATUS', '2018-11-03 23:35:19', 'AHU-226 - SPL Program 2 - DASP - Status', 'Clear'),
179(23880, 'PROG2_STATUS', '2018-11-03 23:32:33', 'AHU-226 - SPL Program 2 - DASP - Status', 'Clear'),
180(23879, 'Hot_Water_Pump_2_Status', '2018-11-03 23:25:48', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
181(23938, 'Filter_Status', '2018-11-05 03:51:20', 'AHU - Filter Alarm', 'Clear'),
182(23929, 'Supply_Air_Fan_Status', '2018-11-04 23:03:19', 'AHU-1 - Supply Air Fan Status Alarm', ''),
183(23878, 'Hot_Water_Pump_2_Status', '2018-11-03 23:13:48', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
184(23939, 'AHU2_Supply_Air_Fan_Status', '2018-11-05 03:52:44', 'AHUs - AHU2 Supply Air Fan Status Alarm', 'Clear'),
185(23937, 'Filter_Status', '2018-11-05 03:44:33', 'AHU - Filter Alarm', 'Clear'),
186(23877, 'Supply_Air_Fan_Status', '2018-11-03 23:03:20', 'AHU-1 - Supply Air Fan Status Alarm', 'Clear'),
187(23930, 'Supply_Air_Fan_Status', '2018-11-05 00:01:08', 'AHU-1 - Supply Air Fan Status Alarm', 'Cleared'),
188(23931, 'CT2_Alarm_Flag', '2018-11-05 00:15:08', 'Quad Tower 2 - Alarm Flag', ''),
189(23876, 'Hot_Water_Pump_2_Status', '2018-11-03 22:19:15', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
190(23936, 'AHU2_Supply_Air_Fan_Status', '2018-11-05 03:43:51', 'AHUs - AHU2 Supply Air Fan Status Alarm', 'Clear'),
191(23935, 'Exhaust_Fan_2_Status', '2018-11-05 03:43:53', 'Lab 6th Floor - Exhaust Fan 2 Status Alarm', 'Clear'),
192(23934, 'PROG2_STATUS', '2018-11-05 02:52:29', 'AHU-226 - SPL Program 2 - DASP - Status', ''),
193(23933, 'PROG2_STATUS', '2018-11-05 02:49:46', 'AHU-226 - SPL Program 2 - DASP - Status', 'Clear'),
194(23932, 'CT2_Alarm_Flag', '2018-11-05 00:22:08', 'Quad Tower 2 - Alarm Flag', 'Cleared'),
195(23928, 'Chilled_Water_Pump_3_Status', '2018-11-04 21:41:26', 'Secondary Chilled Water System - Pump 3 Status Alarm', 'Clear'),
196(23875, 'Hot_Water_Pump_2_Status', '2018-11-03 22:07:14', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
197(23927, 'Chilled_Water_Pump_5_Status', '2018-11-04 21:41:26', 'Secondary Chilled Water System - Pump 5 Status Alarm', ''),
198(23926, 'Chilled_Water_Pump_3_Status', '2018-11-04 21:36:41', 'Secondary Chilled Water System - Pump 3 Status Alarm', 'Clear'),
199(23925, 'Chilled_Water_Pump_5_Status', '2018-11-04 21:36:41', 'Secondary Chilled Water System - Pump 5 Status Alarm', 'Clear'),
200(23924, 'Hot_Water_Pump_2_Status', '2018-11-04 20:21:38', 'Hot Water System - Pump 2 Status Alarm', 'Cleared'),
201(23805, 'Hot_Water_Pump_2_Status', '2018-11-03 06:19:31', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
202(23804, 'Hot_Water_Pump_2_Status', '2018-11-03 06:16:31', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
203(23803, 'Hot_Water_Pump_2_Status', '2018-11-03 06:04:31', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
204(23874, 'Hot_Water_Pump_2_Status', '2018-11-03 22:04:13', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
205(23873, 'Hot_Water_Pump_2_Status', '2018-11-03 21:52:13', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
206(23872, 'Hot_Water_Pump_2_Status', '2018-11-03 21:49:12', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
207(23871, 'Hot_Water_Pump_2_Status', '2018-11-03 21:37:12', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
208(23870, 'Hot_Water_Pump_2_Status', '2018-11-03 21:33:56', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
209(23869, 'Hot_Water_Pump_2_Status', '2018-11-03 21:22:11', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
210(23868, 'Hot_Water_Pump_2_Status', '2018-11-03 21:09:10', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
211(23867, 'Hot_Water_Pump_2_Status', '2018-11-03 20:57:25', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
212(23866, 'Hot_Water_Pump_2_Status', '2018-11-03 20:54:10', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
213(23865, 'Hot_Water_Pump_2_Status', '2018-11-03 20:42:23', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
214(23864, 'Hot_Water_Pump_2_Status', '2018-11-03 20:39:23', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
215(23863, 'Hot_Water_Pump_2_Status', '2018-11-03 20:27:23', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
216(23862, 'Hot_Water_Pump_2_Status', '2018-11-03 20:24:07', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
217(23861, 'Hot_Water_Pump_2_Status', '2018-11-03 19:57:21', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
218(23860, 'Hot_Water_Pump_2_Status', '2018-11-03 19:53:35', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
219(23858, 'EF_2_Endswitch', '2018-11-03 19:17:37', 'EF-2 Damper Status Alarm', 'Clear'),
220(23923, 'Hot_Water_Pump_2_Status', '2018-11-04 20:18:23', 'Hot Water System - Pump 2 Status Alarm', ''),
221(23922, 'EF_2_Endswitch', '2018-11-04 14:30:50', 'EF-2 Damper Status Alarm', 'Clear'),
222(23857, 'Hot_Water_Pump_2_Status', '2018-11-03 19:07:18', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
223(23856, 'Hot_Water_Pump_2_Status', '2018-11-03 19:04:18', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
224(23855, 'Hot_Water_Pump_2_Status', '2018-11-03 14:42:02', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
225(23854, 'Hot_Water_Pump_2_Status', '2018-11-03 14:39:01', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
226(23921, 'EF_2_Endswitch', '2018-11-04 14:25:50', 'EF-2 Damper Status Alarm', 'Clear'),
227(23920, 'EF_2_Endswitch', '2018-11-04 12:36:13', 'EF-2 Damper Status Alarm', 'Clear'),
228(23919, 'EF_2_Endswitch', '2018-11-04 12:28:28', 'EF-2 Damper Status Alarm', 'Clear'),
229(23853, 'Hot_Water_Pump_2_Status', '2018-11-03 14:12:00', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
230(23852, 'Hot_Water_Pump_2_Status', '2018-11-03 14:08:45', 'Hot Water System - Pump 2 Status Alarm', 'Clear'),
231(23966, 'PROG2_STATUS', '2018-11-05 10:31:42', 'AHU-226 - SPL Program 2 - DASP - Status', 'Cleared');