the following is my sql TRAFFIC chart. The columns are id, tdate, ttime, SourceI
ID: 3939602 • Letter: T
Question
the following is my sql TRAFFIC chart. The columns are id, tdate, ttime, SourceIP, Protocol, WEBSERVER_IP, packetsize
There's two queries to write number one is...Find the frequency of the connections to each protocol type. (ratio=(number of connections to a protocol)/(the total number of connections)- HINT: You need to use a subquery for this question. (the output it is supposed to have is all the way at the bottom of the page)
'1', '2015-03-25', '01:00:15', '176.49.66.6', 'POP3', '10.0.0.45', '7.6'
'2', '2015-03-25', '18:32:39', '179.59.63.10', 'HTTP', '192.168.1.50', '3.4'
'3', '2015-03-25', '09:01:46', '172.75.68.3', 'HTTPS', '10.0.0.45', '2.2'
'4', '2015-03-25', '02:12:54', '177.31.58.21', 'HTTPS', '10.0.0.45', '0'
'5', '2015-03-25', '20:19:35', '174.54.64.7', 'HTTPS', '192.168.1.50', '5.4'
'6', '2015-03-25', '06:27:04', '177.34.38.6', 'POP3', '10.0.0.45', '0.1'
'7', '2015-03-25', '07:29:08', '180.61.35.20', 'TELNET', '10.0.0.45', '9.4'
'8', '2015-03-25', '20:12:54', '172.42.40.24', 'POP3', '192.168.1.50', '5.2'
'9', '2015-03-25', '16:55:52', '176.86.42.21', 'POP3', '192.168.1.50', '5.2'
'10', '2015-03-25', '03:02:15', '178.84.54.25', 'POP3', '10.0.0.45', '3.1'
'11', '2015-03-25', '08:39:50', '176.42.62.8', 'HTTPS', '10.0.0.45', '0.9'
'12', '2015-03-25', '15:59:06', '180.56.50.25', 'HTTPS', '192.168.1.50', '9.6'
'13', '2015-03-25', '21:10:39', '180.76.53.12', 'HTTPS', '10.0.0.45', '4.5'
'14', '2015-03-25', '21:05:42', '172.88.35.4', 'HTTPS', '10.0.0.45', '2.6'
'15', '2015-03-25', '17:31:45', '176.63.31.15', 'POP3', '10.0.0.45', '9.4'
'16', '2015-03-25', '18:19:05', '180.30.70.23', 'HTTPS', '192.168.1.50', '2.6'
'17', '2015-03-25', '08:49:46', '175.33.30.3', 'POP3', '192.168.1.50', '9.2'
'18', '2015-03-25', '14:04:23', '180.72.38.4', 'HTTPS', '192.168.1.50', '6.1'
'19', '2015-03-25', '11:17:31', '180.61.54.14', 'TELNET', '10.0.0.45', '6.7'
'20', '2015-03-25', '14:20:28', '174.61.38.14', 'FTP', '192.168.1.50', '9.5'
'21', '2015-03-25', '03:00:57', '178.54.62.24', 'FTP', '10.0.0.45', '3.2'
'22', '2015-03-25', '19:36:09', '177.53.55.19', 'HTTPS', '10.0.0.45', '8.2'
'23', '2015-03-25', '04:01:17', '177.80.36.22', 'POP3', '192.168.1.50', '6.7'
'24', '2015-03-25', '09:49:47', '174.61.64.3', 'HTTP', '10.0.0.45', '8.6'
'25', '2015-03-25', '04:46:17', '174.73.30.15', 'HTTPS', '192.168.1.50', '0.3'
'26', '2015-03-25', '05:50:34', '175.77.38.12', 'POP3', '10.0.0.45', '9.8'
'27', '2015-03-25', '10:53:17', '177.41.53.10', 'POP3', '192.168.1.39', '8.4'
'28', '2015-03-25', '03:36:08', '177.81.56.20', 'HTTPS', '192.168.1.50', '8.5'
'29', '2015-03-25', '18:38:44', '180.66.51.5', 'SFTP', '10.0.0.100', '0.7'
'30', '2015-03-25', '06:03:57', '176.77.57.20', 'HTTPS', '10.0.0.45', '4.8'
'31', '2015-03-25', '20:12:03', '179.74.49.6', 'HTTPS', '192.168.1.50', '0.1'
'32', '2015-03-25', '00:33:07', '175.52.32.13', 'HTTPS', '10.0.0.45', '7.7'
'33', '2015-03-25', '15:03:53', '179.82.57.19', 'POP3', '10.0.0.45', '8.1'
'34', '2015-03-25', '01:35:42', '180.61.66.25', 'HTTPS', '10.0.0.45', '10'
'35', '2015-03-25', '06:29:39', '173.30.31.22', 'POP3', '10.0.0.45', '6.8'
'36', '2015-03-25', '11:42:12', '179.78.48.25', 'TELNET', '10.0.0.45', '5.2'
'37', '2015-03-25', '07:16:46', '176.53.58.3', 'HTTPS', '10.0.0.45', '2'
'38', '2015-03-25', '22:11:21', '179.35.49.15', 'POP3', '10.0.0.45', '6'
'39', '2015-03-25', '14:57:54', '172.31.34.18', 'POP3', '10.0.0.45', '3.7'
'40', '2015-03-25', '14:35:42', '176.52.43.13', 'POP3', '10.0.0.100', '1.6'
'41', '2015-03-25', '13:40:22', '175.66.41.10', 'POP3', '10.0.0.45', '4.7'
'42', '2015-03-25', '18:40:25', '178.75.42.13', 'HTTPS', '10.0.0.45', '5.6'
'43', '2015-03-25', '02:07:43', '177.63.44.7', 'HTTPS', '10.0.0.45', '5.8'
'44', '2015-03-25', '05:18:31', '175.42.36.13', 'HTTPS', '192.168.1.50', '7.1'
'45', '2015-03-25', '15:27:59', '179.59.67.4', 'POP3', '10.0.0.100', '4.3'
'46', '2015-03-25', '17:31:30', '176.37.66.5', 'HTTPS', '10.0.0.45', '1.7'
'47', '2015-03-25', '11:38:17', '172.80.40.19', 'HTTP', '192.168.1.50', '4.5'
'48', '2015-03-25', '01:13:09', '177.41.55.13', 'POP3', '10.0.0.45', '7.1'
'49', '2015-03-25', '22:47:38', '180.56.65.25', 'POP3', '10.0.0.45', '7.8'
'50', '2015-03-25', '17:14:59', '176.70.37.25', 'POP3', '10.0.0.45', '9'
'51', '2015-03-25', '23:41:08', '172.30.30.12', 'TELNET', '10.0.0.45', '6.4'
'52', '2015-03-25', '19:04:49', '178.55.51.23', 'POP3', '192.168.1.50', '4.9'
'53', '2015-03-25', '13:19:11', '173.53.61.12', 'POP3', '192.168.1.50', '4.2'
'54', '2015-03-25', '17:23:25', '173.90.55.18', 'HTTPS', '10.0.0.45', '2.4'
'55', '2015-03-25', '11:23:44', '172.63.66.21', 'POP3', '192.168.1.50', '7.5'
'56', '2015-03-25', '18:40:22', '176.34.56.22', 'SFTP', '10.0.0.45', '8.8'
'57', '2015-03-25', '12:17:13', '174.68.37.19', 'POP3', '192.168.1.50', '9.7'
'58', '2015-03-25', '10:49:00', '175.68.32.8', 'POP3', '10.0.0.45', '5.2'
'59', '2015-03-25', '18:27:41', '172.88.33.3', 'HTTPS', '10.0.0.45', '0.7'
'60', '2015-03-25', '19:07:17', '173.86.60.20', 'POP3', '192.168.1.50', '8.4'
'61', '2015-03-25', '19:18:20', '178.84.30.7', 'POP3', '10.0.0.45', '2.8'
'62', '2015-03-25', '04:01:44', '178.58.67.3', 'TELNET', '10.0.0.45', '4'
'63', '2015-03-25', '04:42:47', '176.37.30.14', 'POP3', '192.168.1.50', '9.5'
'64', '2015-03-25', '14:18:33', '175.75.63.11', 'HTTPS', '10.0.0.45', '1.1'
'65', '2015-03-25', '02:01:02', '179.68.47.19', 'POP3', '10.0.0.45', '7.9'
'66', '2015-03-25', '01:16:34', '175.78.69.15', 'TELNET', '10.0.0.45', '6.4'
'67', '2015-03-25', '21:26:09', '177.77.32.22', 'POP3', '192.168.1.50', '7.7'
'68', '2015-03-25', '17:47:33', '177.61.44.17', 'POP3', '10.0.0.45', '3.1'
'69', '2015-03-25', '11:12:01', '173.47.39.21', 'HTTPS', '10.0.0.45', '2.4'
'70', '2015-03-25', '02:46:35', '172.85.33.6', 'HTTPS', '192.168.1.50', '9.2'
'71', '2015-03-25', '01:25:19', '176.47.67.7', 'HTTPS', '10.0.0.45', '3.7'
'72', '2015-03-25', '12:28:06', '172.49.32.24', 'HTTPS', '10.0.0.45', '2.7'
'73', '2015-03-25', '11:45:18', '174.83.69.18', 'HTTPS', '10.0.0.45', '5.1'
'74', '2015-03-25', '03:40:36', '179.59.48.10', 'HTTPS', '10.0.0.45', '0.2'
'75', '2015-03-25', '23:55:20', '179.69.40.13', 'POP3', '10.0.0.45', '0.9'
'76', '2015-03-25', '04:05:43', '175.78.36.6', 'POP3', '10.0.0.45', '8.1'
'77', '2015-03-25', '09:21:09', '175.75.54.10', 'POP3', '10.0.0.45', '8.2'
'78', '2015-03-25', '18:21:24', '173.80.55.13', 'TELNET', '192.168.1.50', '0.9'
'79', '2015-03-25', '06:55:24', '180.90.45.17', 'HTTPS', '10.0.0.45', '0.5'
'80', '2015-03-25', '08:16:21', '178.52.34.13', 'SFTP', '10.0.0.45', '9.2'
'81', '2015-03-25', '03:00:59', '180.62.55.17', 'POP3', '192.168.1.50', '5.6'
'82', '2015-03-25', '03:32:46', '173.37.33.14', 'HTTPS', '10.0.0.45', '6'
'83', '2015-03-25', '00:36:45', '180.39.58.21', 'POP3', '10.0.0.45', '3.1'
'84', '2015-03-25', '01:31:39', '178.48.69.11', 'HTTPS', '192.168.1.50', '3.2'
'85', '2015-03-25', '03:37:48', '175.73.61.25', 'HTTPS', '10.0.0.45', '1.1'
'86', '2015-03-25', '17:31:59', '177.30.45.13', 'HTTPS', '10.0.0.45', '3.3'
'87', '2015-03-25', '07:12:07', '174.31.68.25', 'POP3', '10.0.0.45', '5.8'
'88', '2015-03-25', '01:55:33', '175.73.56.21', 'SFTP', '10.0.0.100', '7.2'
'89', '2015-03-25', '13:41:10', '173.77.67.6', 'POP3', '192.168.1.50', '4.6'
'90', '2015-03-25', '01:17:09', '178.60.54.10', 'HTTPS', '192.168.1.50', '7.9'
'91', '2015-03-25', '00:13:29', '172.35.46.18', 'POP3', '10.0.0.45', '5.3'
'92', '2015-03-25', '06:24:21', '180.61.38.14', 'POP3', '10.0.0.45', '5.1'
'93', '2015-03-25', '09:02:23', '173.64.67.13', 'TELNET', '10.0.0.45', '8.5'
'94', '2015-03-25', '03:44:05', '173.69.60.17', 'POP3', '192.168.1.50', '7.7'
'95', '2015-03-25', '02:08:06', '177.71.58.16', 'SFTP', '10.0.0.45', '5.3'
'96', '2015-03-25', '21:19:44', '176.86.38.20', 'POP3', '10.0.0.45', '2.6'
'97', '2015-03-25', '10:25:02', '180.90.33.18', 'HTTPS', '192.168.1.39', '3.9'
'98', '2015-03-25', '05:08:55', '176.90.62.8', 'POP3', '192.168.1.50', '1'
'99', '2015-03-25', '12:39:33', '174.79.35.18', 'POP3', '192.168.1.50', '1.5'
'100', '2015-03-25', '13:38:54', '172.41.39.20', 'TELNET', '192.168.1.50', '0'
'101', '2015-03-25', '05:11:07', '175.51.62.14', 'HTTPS', '10.0.0.45', '9.2'
'102', '2015-03-25', '07:38:58', '178.40.67.25', 'HTTPS', '10.0.0.45', '0.5'
'103', '2015-03-25', '15:23:45', '173.36.64.18', 'TELNET', '192.168.1.50', '1.7'
'104', '2015-03-25', '08:53:05', '176.44.41.11', 'TELNET', '10.0.0.45', '1.4'
'105', '2015-03-25', '08:31:16', '179.54.66.9', 'TELNET', '192.168.1.50', '7.4'
'106', '2015-03-25', '12:29:22', '174.86.67.24', 'POP3', '192.168.1.50', '3.8'
'107', '2015-03-25', '20:26:15', '177.62.34.8', 'TELNET', '192.168.1.50', '2.8'
'108', '2015-03-25', '13:48:33', '180.31.35.25', 'HTTPS', '192.168.1.50', '8.2'
'109', '2015-03-25', '19:01:58', '172.69.36.8', 'POP3', '10.0.0.45', '9.6'
'110', '2015-03-25', '03:30:52', '177.35.58.25', 'HTTPS', '10.0.0.45', '6.8'
'111', '2015-03-25', '09:03:24', '172.69.57.24', 'POP3', '10.0.0.45', '9.6'
'112', '2015-03-25', '01:39:22', '177.41.37.23', 'HTTP', '10.0.0.45', '8.8'
'113', '2015-03-25', '12:59:54', '175.88.45.13', 'TELNET', '192.168.1.50', '1'
'114', '2015-03-25', '22:15:54', '173.88.53.11', 'HTTPS', '10.0.0.45', '1.4'
'115', '2015-03-25', '04:18:05', '173.55.36.4', 'POP3', '10.0.0.45', '1.4'
'116', '2015-03-25', '20:15:42', '173.70.46.23', 'HTTPS', '192.168.1.50', '5.2'
'117', '2015-03-25', '21:26:14', '178.63.46.20', 'TELNET', '10.0.0.45', '4.2'
'118', '2015-03-25', '14:22:11', '174.84.35.13', 'HTTPS', '192.168.1.50', '8.3'
'119', '2015-03-25', '07:14:51', '177.69.43.21', 'SFTP', '10.0.0.45', '1.2'
'120', '2015-03-25', '12:57:55', '174.64.65.9', 'HTTPS', '192.168.1.50', '1.7'
'121', '2015-03-25', '00:24:12', '177.64.64.18', 'HTTPS', '10.0.0.45', '1.7'
'122', '2015-03-25', '11:02:42', '180.80.42.10', 'POP3', '192.168.1.50', '9.2'
'123', '2015-03-25', '17:06:55', '179.87.42.8', 'TELNET', '10.0.0.45', '3.4'
'124', '2015-03-25', '16:39:45', '177.38.48.22', 'HTTPS', '192.168.1.50', '0.8'
'125', '2015-03-25', '00:42:39', '179.89.57.13', 'HTTPS', '10.0.0.45', '5.7'
'126', '2015-03-25', '09:31:59', '180.58.61.20', 'POP3', '10.0.0.45', '1.3'
'127', '2015-03-25', '06:38:00', '176.88.57.22', 'POP3', '10.0.0.45', '6.5'
'128', '2015-03-25', '07:39:58', '179.64.38.15', 'HTTPS', '10.0.0.45', '4.2'
'129', '2015-03-25', '23:53:46', '173.66.49.22', 'POP3', '192.168.1.39', '7.9'
'130', '2015-03-25', '00:35:14', '180.36.32.25', 'POP3', '10.0.0.45', '7.4'
'131', '2015-03-25', '22:53:25', '174.65.38.5', 'TELNET', '10.0.0.45', '2.7'
'132', '2015-03-25', '08:51:19', '176.40.42.18', 'POP3', '10.0.0.45', '3.3'
'133', '2015-03-25', '03:23:02', '178.57.57.21', 'POP3', '10.0.0.100', '0.8'
'134', '2015-03-25', '16:07:26', '179.59.48.20', 'POP3', '10.0.0.45', '2'
'135', '2015-03-25', '09:08:50', '172.41.49.25', 'HTTPS', '10.0.0.45', '5.7'
'136', '2015-03-25', '16:29:53', '178.42.52.24', 'POP3', '10.0.0.45', '1.4'
'137', '2015-03-25', '16:01:04', '173.75.44.8', 'POP3', '10.0.0.45', '7.2'
'138', '2015-03-26', '22:15:53', '179.52.44.20', 'HTTPS', '10.0.0.45', '7.1'
'139', '2015-03-26', '10:13:52', '179.62.31.14', 'POP3', '192.168.1.50', '9.9'
'140', '2015-03-26', '12:10:30', '179.72.66.13', 'HTTPS', '192.168.1.50', '9.2'
'141', '2015-03-26', '12:03:14', '177.60.33.24', 'HTTP', '10.0.0.45', '1.8'
'142', '2015-03-26', '18:19:42', '172.87.66.5', 'HTTPS', '192.168.1.50', '7.4'
'143', '2015-03-26', '20:02:18', '172.44.52.16', 'TELNET', '192.168.1.50', '5.8'
'144', '2015-03-26', '11:25:07', '173.82.45.13', 'HTTPS', '10.0.0.45', '6.7'
'145', '2015-03-26', '00:34:08', '174.65.43.6', 'POP3', '10.0.0.45', '5.8'
'146', '2015-03-26', '18:37:39', '178.56.68.7', 'POP3', '10.0.0.45', '8.6'
'147', '2015-03-26', '07:36:22', '180.77.51.3', 'POP3', '192.168.1.50', '4.5'
'148', '2015-03-26', '17:05:35', '173.30.70.20', 'POP3', '10.0.0.100', '2.8'
'149', '2015-03-27', '10:00:05', '179.72.69.22', 'HTTPS', '192.168.1.50', '3.1'
'150', '2015-03-27', '06:39:00', '178.50.66.23', 'HTTPS', '10.0.0.100', '3.9'
'151', '2015-03-27', '07:31:16', '179.40.42.7', 'POP3', '10.0.0.45', '0.9'
'152', '2015-03-27', '03:26:40', '172.76.61.20', 'POP3', '192.168.1.39', '9.5'
'153', '2015-03-27', '16:08:51', '178.57.69.5', 'POP3', '192.168.1.50', '9'
'154', '2015-03-27', '17:29:05', '177.90.37.25', 'TELNET', '192.168.1.50', '0.9'
'155', '2015-03-27', '17:33:25', '176.82.36.10', 'POP3', '10.0.0.45', '6.5'
'156', '2015-03-27', '20:01:46', '175.67.70.11', 'HTTPS', '10.0.0.45', '2.8'
'157', '2015-03-27', '20:24:07', '179.67.46.7', 'SFTP', '10.0.0.45', '8.1'
'158', '2015-03-27', '18:16:02', '179.86.42.20', 'POP3', '10.0.0.45', '6.8'
'159', '2015-03-27', '22:20:23', '174.72.54.14', 'POP3', '10.0.0.45', '1.3'
'160', '2015-03-27', '04:07:59', '179.30.49.13', 'POP3', '10.0.0.45', '6.1'
'161', '2015-03-27', '01:48:23', '178.86.42.5', 'HTTPS', '10.0.0.45', '0.2'
'162', '2015-03-27', '13:19:08', '174.47.67.21', 'POP3', '10.0.0.45', '3'
'163', '2015-03-27', '02:35:19', '174.33.39.7', 'POP3', '192.168.1.50', '2.1'
'164', '2015-03-27', '16:25:29', '180.54.36.22', 'SFTP', '10.0.0.45', '5.3'
'165', '2015-03-27', '01:28:15', '173.54.52.11', 'HTTP', '10.0.0.45', '7.2'
'166', '2015-03-27', '16:29:43', '172.71.44.8', 'POP3', '10.0.0.45', '3'
'167', '2015-03-27', '16:22:00', '173.35.51.18', 'POP3', '192.168.1.50', '7.1'
'168', '2015-03-27', '07:41:46', '179.85.32.14', 'POP3', '10.0.0.45', '8'
'169', '2015-03-27', '12:11:29', '178.54.61.22', 'POP3', '10.0.0.100', '7.1'
'170', '2015-03-27', '22:37:22', '172.36.65.22', 'HTTPS', '10.0.0.45', '6.4'
'171', '2015-03-27', '20:03:42', '180.76.32.3', 'HTTPS', '192.168.1.50', '1.5'
'172', '2015-03-27', '14:43:43', '177.56.36.19', 'TELNET', '10.0.0.45', '0.9'
'173', '2015-03-27', '01:41:38', '178.50.65.9', 'POP3', '10.0.0.45', '7.2'
'174', '2015-03-27', '20:05:49', '174.60.41.12', 'HTTPS', '10.0.0.100', '5.5'
'175', '2015-03-27', '12:52:56', '177.30.42.20', 'POP3', '10.0.0.45', '2.1'
'176', '2015-03-27', '02:16:40', '175.84.63.16', 'POP3', '10.0.0.45', '0.6'
'177', '2015-03-27', '07:40:00', '173.31.50.23', 'POP3', '192.168.1.50', '3.9'
'178', '2015-03-27', '04:06:11', '179.57.36.6', 'POP3', '192.168.1.50', '2.2'
'179', '2015-03-27', '01:03:46', '174.38.69.8', 'HTTPS', '10.0.0.100', '1.7'
'180', '2015-03-27', '06:18:29', '180.49.62.13', 'HTTPS', '10.0.0.45', '0.1'
'181', '2015-03-27', '23:49:27', '180.37.51.10', 'HTTPS', '10.0.0.45', '7.4'
'182', '2015-03-27', '17:49:03', '176.87.40.24', 'POP3', '10.0.0.45', '1.7'
'183', '2015-03-27', '14:35:23', '176.69.44.13', 'POP3', '192.168.1.50', '2.2'
'184', '2015-03-27', '11:31:02', '174.75.48.4', 'HTTPS', '10.0.0.45', '6.8'
'185', '2015-03-27', '23:22:25', '178.44.39.4', 'POP3', '192.168.1.39', '6.7'
'186', '2015-03-27', '16:42:11', '174.40.53.3', 'HTTPS', '192.168.1.50', '4.5'
'187', '2015-03-27', '08:15:03', '178.69.32.17', 'TELNET', '10.0.0.45', '1.6'
'188', '2015-03-27', '04:41:42', '175.50.32.16', 'HTTPS', '192.168.1.50', '1.7'
'189', '2015-03-27', '19:36:38', '172.82.31.15', 'POP3', '10.0.0.45', '0.1'
'190', '2015-03-27', '12:28:30', '175.90.38.22', 'HTTP', '10.0.0.45', '3.9'
'191', '2015-03-27', '05:49:26', '176.77.64.24', 'HTTP', '10.0.0.100', '8.4'
'192', '2015-03-27', '20:20:26', '176.79.64.18', 'HTTPS', '10.0.0.100', '5.7'
'193', '2015-03-27', '02:14:52', '173.80.60.7', 'SFTP', '10.0.0.45', '7.5'
'194', '2015-03-27', '01:21:19', '175.50.35.19', 'POP3', '192.168.1.50', '8.1'
'195', '2015-03-27', '05:06:55', '179.38.64.8', 'HTTP', '10.0.0.45', '2.7'
'196', '2015-03-27', '00:18:16', '175.64.69.23', 'SFTP', '10.0.0.45', '4.8'
'197', '2015-03-27', '15:19:32', '179.90.30.17', 'POP3', '10.0.0.45', '4.5'
'198', '2015-03-27', '23:31:30', '176.31.43.25', 'POP3', '192.168.1.50', '3.6'
'199', '2015-03-27', '09:25:50', '175.64.58.22', 'FTP', '192.168.1.50', '0.4'
'200', '2015-03-27', '08:45:08', '179.76.42.17', 'HTTPS', '192.168.1.50', '1'
'201', '2015-03-27', '07:58:11', '173.86.34.17', 'POP3', '10.0.0.45', '2'
'202', '2015-03-27', '05:42:08', '173.62.30.17', 'HTTPS', '10.0.0.45', '2.2'
'203', '2015-03-27', '07:31:42', '178.61.62.8', 'FTP', '10.0.0.100', '0.7'
'204', '2015-03-27', '22:36:29', '175.90.35.11', 'HTTPS', '192.168.1.50', '4.5'
'205', '2015-03-27', '01:38:27', '177.76.63.4', 'POP3', '10.0.0.45', '1.4'
'206', '2015-03-27', '00:53:08', '174.66.65.5', 'TELNET', '192.168.1.39', '3.8'
'207', '2015-03-27', '01:18:17', '177.39.70.8', 'HTTPS', '192.168.1.39', '1.9'
'208', '2015-03-27', '01:47:42', '178.77.41.14', 'POP3', '10.0.0.45', '7.3'
'209', '2015-03-27', '10:10:31', '174.89.34.17', 'HTTPS', '10.0.0.45', '2.2'
'210', '2015-03-27', '01:27:20', '174.79.33.25', 'POP3', '10.0.0.100', '6.5'
'211', '2015-03-27', '00:36:14', '178.89.69.21', 'HTTP', '192.168.1.50', '3.7'
'212', '2015-03-27', '12:10:31', '179.42.39.23', 'SFTP', '10.0.0.45', '5.1'
'213', '2015-03-27', '02:26:39', '178.60.51.17', 'HTTPS', '10.0.0.45', '9.4'
'214', '2015-03-27', '14:19:20', '174.45.61.15', 'HTTPS', '10.0.0.45', '3.6'
'215', '2015-03-27', '11:27:51', '178.64.41.23', 'HTTPS', '10.0.0.45', '4.8'
'216', '2015-03-27', '22:22:10', '177.88.62.7', 'HTTP', '10.0.0.45', '0.6'
'217', '2015-03-27', '09:37:29', '175.51.40.9', 'HTTPS', '10.0.0.45', '9.7'
'218', '2015-03-27', '01:31:59', '175.31.66.22', 'HTTPS', '10.0.0.45', '1'
'219', '2015-03-27', '08:06:08', '175.36.68.20', 'HTTPS', '10.0.0.45', '7.4'
'220', '2015-03-27', '01:10:42', '178.54.62.16', 'POP3', '10.0.0.45', '2.7'
'221', '2015-03-27', '18:28:33', '176.39.30.8', 'HTTP', '10.0.0.45', '4.5'
'222', '2015-03-27', '19:04:54', '175.59.49.21', 'TELNET', '10.0.0.45', '0.8'
'223', '2015-03-27', '20:38:55', '180.49.49.9', 'POP3', '192.168.1.50', '1.7'
'224', '2015-03-27', '03:14:10', '172.56.54.3', 'HTTPS', '192.168.1.50', '7.9'
'225', '2015-03-27', '15:04:41', '173.44.50.7', 'SFTP', '192.168.1.50', '1'
'226', '2015-03-27', '05:38:17', '174.56.41.14', 'POP3', '10.0.0.45', '0'
'227', '2015-03-27', '17:34:42', '176.43.54.10', 'HTTPS', '10.0.0.45', '4.4'
'228', '2015-03-27', '12:07:41', '175.30.50.5', 'POP3', '10.0.0.45', '7.1'
'229', '2015-03-27', '01:23:05', '173.79.57.4', 'POP3', '192.168.1.50', '6.8'
'230', '2015-03-27', '06:17:29', '174.87.46.13', 'HTTPS', '10.0.0.45', '1.9'
'231', '2015-03-27', '18:45:00', '174.66.45.14', 'HTTPS', '10.0.0.45', '1.2'
'232', '2015-03-27', '07:02:01', '172.52.69.11', 'POP3', '10.0.0.45', '7.4'
'233', '2015-03-27', '08:10:12', '172.78.64.14', 'POP3', '10.0.0.45', '3.4'
'234', '2015-03-27', '02:00:57', '172.84.42.19', 'POP3', '10.0.0.45', '8.9'
'235', '2015-03-27', '08:03:22', '175.73.62.15', 'HTTPS', '10.0.0.45', '5.1'
'236', '2015-03-27', '00:18:07', '173.57.32.23', 'POP3', '192.168.1.50', '0.4'
'237', '2015-03-27', '14:34:33', '178.67.62.3', 'POP3', '192.168.1.50', '6.8'
'238', '2015-03-27', '00:13:26', '176.87.33.13', 'TELNET', '10.0.0.45', '5.2'
'239', '2015-03-27', '05:48:03', '172.50.42.16', 'POP3', '192.168.1.50', '1'
'240', '2015-03-27', '18:09:09', '179.30.39.16', 'TELNET', '192.168.1.50', '9.4'
'241', '2015-03-27', '06:33:55', '175.33.66.19', 'POP3', '10.0.0.45', '4.2'
'242', '2015-03-27', '07:50:47', '177.88.38.6', 'POP3', '10.0.0.100', '2.2'
'243', '2015-03-27', '12:57:57', '179.32.45.17', 'HTTPS', '192.168.1.50', '0.1'
'244', '2015-03-27', '05:10:59', '174.48.56.5', 'HTTPS', '10.0.0.45', '5.5'
'245', '2015-03-27', '17:24:59', '178.33.44.12', 'HTTPS', '10.0.0.45', '9.1'
'246', '2015-03-27', '23:36:25', '179.55.44.19', 'POP3', '10.0.0.45', '7'
'247', '2015-03-27', '07:18:37', '176.84.67.14', 'POP3', '192.168.1.50', '3.1'
'248', '2015-03-27', '17:47:00', '176.50.70.10', 'HTTPS', '192.168.1.50', '3.2'
'249', '2015-03-27', '09:48:11', '175.77.33.13', 'HTTPS', '10.0.0.45', '2.4'
'250', '2015-03-27', '05:00:20', '175.42.36.9', 'HTTPS', '10.0.0.45', '1.6'
'251', '2015-03-27', '18:04:24', '173.51.56.20', 'HTTPS', '10.0.0.45', '5.1'
'252', '2015-03-27', '13:44:25', '174.38.66.24', 'POP3', '10.0.0.45', '8.5'
'253', '2015-03-27', '12:27:31', '177.90.39.11', 'POP3', '192.168.1.50', '0.5'
'254', '2015-03-27', '11:39:49', '176.46.54.11', 'HTTPS', '10.0.0.45', '5'
'255', '2015-03-27', '14:38:56', '179.42.32.4', 'POP3', '10.0.0.45', '5'
'256', '2015-03-27', '13:28:24', '173.81.30.14', 'POP3', '10.0.0.45', '9'
'257', '2015-03-27', '02:43:44', '178.79.52.9', 'POP3', '10.0.0.45', '5.4'
'258', '2015-03-27', '05:08:27', '176.85.69.3', 'HTTPS', '10.0.0.45', '2.6'
'259', '2015-03-27', '03:40:53', '176.48.63.25', 'HTTPS', '10.0.0.45', '8.6'
'260', '2015-03-27', '13:32:10', '178.48.51.16', 'HTTPS', '192.168.1.50', '0.8'
'261', '2015-03-27', '00:31:27', '176.59.37.18', 'POP3', '10.0.0.45', '7.1'
'262', '2015-03-27', '04:37:40', '176.70.30.20', 'HTTPS', '10.0.0.45', '0.2'
'263', '2015-03-27', '09:58:49', '175.41.43.20', 'HTTP', '10.0.0.45', '1'
'264', '2015-03-27', '18:32:59', '177.59.49.12', 'HTTPS', '192.168.1.50', '9.9'
'265', '2015-03-27', '19:14:26', '176.60.44.17', 'HTTPS', '10.0.0.45', '7.2'
'266', '2015-03-27', '19:00:25', '177.86.67.14', 'HTTPS', '10.0.0.100', '9.9'
'267', '2015-03-27', '15:08:49', '176.72.53.8', 'POP3', '10.0.0.100', '3.8'
'268', '2015-03-27', '11:44:21', '177.90.67.7', 'POP3', '192.168.1.50', '9.2'
'269', '2015-03-27', '07:08:58', '174.56.38.12', 'HTTPS', '10.0.0.45', '3.2'
'270', '2015-03-27', '08:30:12', '175.66.33.14', 'HTTPS', '10.0.0.45', '5.4'
'271', '2015-03-27', '06:59:10', '180.50.58.5', 'POP3', '10.0.0.45', '6.1'
'272', '2015-03-27', '20:29:03', '175.68.46.17', 'FTP', '192.168.1.50', '0.7'
'273', '2015-03-27', '22:16:15', '173.79.48.3', 'TELNET', '10.0.0.45', '6.5'
'274', '2015-03-27', '21:41:30', '172.74.67.9', 'HTTPS', '10.0.0.45', '7.9'
'275', '2015-03-27', '23:36:33', '179.40.70.15', 'HTTPS', '10.0.0.45', '3.4'
'276', '2015-03-27', '05:55:17', '180.41.56.3', 'POP3', '192.168.1.50', '1.4'
'277', '2015-03-27', '18:26:00', '175.40.66.20', 'HTTPS', '10.0.0.45', '1.1'
'278', '2015-03-27', '03:14:28', '177.65.37.5', 'HTTPS', '10.0.0.45', '4.8'
'279', '2015-03-27', '06:03:02', '178.33.48.18', 'HTTPS', '10.0.0.45', '4.1'
'280', '2015-03-27', '14:12:06', '175.59.45.8', 'HTTP', '192.168.1.39', '6.6'
'281', '2015-03-27', '04:00:34', '179.33.31.25', 'SFTP', '10.0.0.45', '1.3'
'282', '2015-03-27', '16:30:17', '179.80.30.24', 'POP3', '192.168.1.50', '3.5'
'283', '2015-03-27', '23:21:22', '175.48.58.4', 'POP3', '10.0.0.45', '4.9'
'284', '2015-03-27', '01:42:25', '174.45.35.18', 'HTTPS', '10.0.0.45', '2.3'
'285', '2015-03-27', '07:40:10', '178.52.44.15', 'POP3', '10.0.0.45', '8.6'
'286', '2015-03-27', '12:58:21', '172.62.64.5', 'HTTPS', '10.0.0.45', '0.2'
'287', '2015-03-27', '22:47:23', '179.39.42.15', 'POP3', '10.0.0.45', '1.4'
'288', '2015-03-27', '19:26:27', '178.35.52.7', 'HTTPS', '10.0.0.45', '0.3'
'289', '2015-03-27', '04:12:04', '172.40.53.7', 'SFTP', '192.168.1.50', '0.4'
'290', '2015-03-27', '22:28:55', '175.38.57.15', 'TELNET', '10.0.0.45', '2.5'
'291', '2015-03-27', '08:18:12', '179.88.41.7', 'HTTPS', '192.168.1.50', '6.7'
'292', '2015-03-27', '20:42:37', '172.50.34.12', 'POP3', '10.0.0.45', '2.2'
'293', '2015-03-27', '08:19:34', '174.45.62.15', 'POP3', '192.168.1.50', '9.4'
'294', '2015-03-27', '07:26:23', '175.86.34.14', 'POP3', '192.168.1.50', '5'
'295', '2015-03-27', '09:14:39', '178.53.53.3', 'POP3', '10.0.0.45', '2.9'
'296', '2015-03-27', '02:55:55', '175.34.57.14', 'HTTPS', '10.0.0.45', '1.1'
'297', '2015-03-27', '23:30:07', '173.43.41.5', 'POP3', '10.0.0.100', '8.8'
'298', '2015-03-27', '10:22:16', '175.88.42.5', 'POP3', '10.0.0.45', '8.7'
'299', '2015-03-27', '01:27:52', '180.48.69.25', 'POP3', '10.0.0.45', '8.7'
'300', '2015-03-27', '13:45:49', '175.34.63.3', 'TELNET', '10.0.0.45', '5.5'
'301', '2015-03-27', '05:25:17', '177.46.60.21', 'HTTPS', '10.0.0.45', '6.3'
'302', '2015-03-27', '08:18:37', '173.68.54.16', 'HTTPS', '10.0.0.100', '9.7'
'303', '2015-03-27', '14:07:29', '177.79.53.18', 'POP3', '10.0.0.45', '3.3'
'304', '2015-03-27', '11:03:47', '175.46.61.10', 'SFTP', '10.0.0.45', '5.3'
'305', '2015-03-27', '15:05:34', '180.42.65.3', 'HTTPS', '192.168.1.50', '7.9'
'306', '2015-03-27', '11:32:46', '178.45.57.12', 'SFTP', '10.0.0.45', '2.6'
'307', '2015-03-27', '03:31:38', '178.62.69.17', 'POP3', '10.0.0.45', '2.5'
'308', '2015-03-27', '11:10:48', '180.39.59.11', 'POP3', '10.0.0.45', '4.9'
'309', '2015-03-27', '07:41:55', '180.47.67.21', 'HTTPS', '10.0.0.45', '9.2'
'310', '2015-03-27', '10:11:25', '177.60.51.10', 'HTTPS', '10.0.0.45', '0.6'
'311', '2015-03-27', '06:14:39', '179.37.52.24', 'POP3', '10.0.0.100', '3.9'
'312', '2015-03-27', '14:16:15', '179.85.57.22', 'HTTPS', '10.0.0.45', '2.1'
'313', '2015-03-27', '00:43:06', '178.70.43.9', 'HTTPS', '10.0.0.45', '7.4'
'314', '2015-03-27', '05:05:17', '172.34.51.12', 'HTTPS', '10.0.0.45', '0.9'
'315', '2015-03-27', '21:10:20', '179.81.36.8', 'POP3', '192.168.1.50', '7.3'
'316', '2015-03-27', '23:24:10', '179.83.57.6', 'POP3', '192.168.1.50', '4.9'
'317', '2015-03-27', '16:04:53', '172.78.40.15', 'HTTPS', '10.0.0.45', '5.8'
'318', '2015-03-27', '07:05:56', '172.52.63.13', 'POP3', '192.168.1.50', '2.8'
'319', '2015-03-27', '05:13:16', '176.33.46.16', 'POP3', '192.168.1.50', '9.7'
'320', '2015-03-27', '09:12:40', '178.87.63.12', 'TELNET', '192.168.1.50', '6.8'
'321', '2015-03-27', '13:29:42', '174.45.43.3', 'TELNET', '10.0.0.45', '6.8'
'322', '2015-03-27', '21:08:56', '174.65.45.14', 'HTTPS', '192.168.1.50', '5.9'
'323', '2015-03-27', '12:54:02', '179.49.33.21', 'POP3', '10.0.0.45', '7.9'
'324', '2015-03-27', '00:08:49', '177.60.34.17', 'HTTPS', '10.0.0.45', '5.3'
'325', '2015-03-27', '10:53:51', '172.42.38.6', 'HTTPS', '192.168.1.50', '8.6'
'326', '2015-03-27', '06:38:47', '173.37.63.20', 'POP3', '10.0.0.45', '2.3'
'327', '2015-03-27', '20:26:34', '180.77.63.5', 'HTTPS', '10.0.0.45', '3.8'
'328', '2015-03-27', '09:26:28', '180.43.49.18', 'POP3', '192.168.1.50', '6.7'
'329', '2015-03-27', '23:30:36', '180.80.50.12', 'POP3', '192.168.1.50', '2.1'
'330', '2015-03-27', '13:27:11', '174.43.69.15', 'POP3', '10.0.0.45', '3.3'
'331', '2015-03-27', '22:29:23', '180.59.38.12', 'HTTPS', '10.0.0.45', '7.7'
'332', '2015-03-27', '06:37:25', '180.34.56.11', 'HTTPS', '192.168.1.50', '4.5'
'333', '2015-03-27', '00:00:07', '178.69.44.12', 'HTTPS', '10.0.0.45', '5.5'
'334', '2015-03-27', '22:18:17', '176.57.64.24', 'TELNET', '192.168.1.39', '4.7'
'335', '2015-03-27', '04:15:34', '178.38.46.22', 'TELNET', '192.168.1.50', '4.2'
'336', '2015-03-27', '19:38:20', '174.53.64.5', 'POP3', '192.168.1.50', '5.7'
'337', '2015-03-27', '00:56:04', '173.43.70.8', 'HTTPS', '192.168.1.50', '2.7'
'338', '2015-03-27', '20:43:40', '175.85.66.5', 'SFTP', '10.0.0.45', '9'
'339', '2015-03-27', '01:54:26', '175.61.50.25', 'HTTPS', '10.0.0.45', '3.1'
'340', '2015-03-27', '11:06:06', '172.57.50.11', 'HTTP', '192.168.1.50', '0.8'
'341', '2015-03-27', '14:48:51', '179.32.64.23', 'POP3', '10.0.0.45', '9.2'
'342', '2015-03-27', '09:37:47', '173.88.70.3', 'POP3', '10.0.0.45', '7.5'
'343', '2015-03-27', '13:05:32', '175.84.36.10', 'HTTP', '10.0.0.45', '0.8'
'344', '2015-03-27', '01:14:53', '175.46.67.9', 'TELNET', '10.0.0.45', '4.8'
'345', '2015-03-27', '00:19:43', '178.32.50.9', 'POP3', '10.0.0.45', '4.6'
'346', '2015-03-27', '04:57:00', '177.80.42.22', 'HTTPS', '10.0.0.45', '6.2'
'347', '2015-03-27', '06:38:05', '180.44.59.20', 'HTTPS', '192.168.1.50', '3.6'
'348', '2015-03-27', '00:28:58', '179.51.37.10', 'HTTPS', '192.168.1.50', '4'
'349', '2015-03-27', '04:09:38', '177.67.30.6', 'HTTPS', '10.0.0.45', '3.6'
'350', '2015-03-27', '04:22:19', '176.61.70.17', 'HTTPS', '10.0.0.45', '2.5'
'351', '2015-03-27', '04:09:30', '172.57.61.23', 'SFTP', '192.168.1.39', '0.3'
'352', '2015-03-27', '06:43:08', '176.57.35.19', 'SFTP', '10.0.0.45', '9.6'
'353', '2015-03-27', '20:00:24', '175.48.38.13', 'SFTP', '10.0.0.45', '5.5'
'354', '2015-03-27', '00:43:05', '173.55.57.7', 'HTTPS', '10.0.0.45', '7.2'
'355', '2015-03-27', '09:55:21', '178.88.70.16', 'POP3', '10.0.0.45', '5.8'
'356', '2015-03-27', '21:06:32', '178.82.68.23', 'HTTPS', '10.0.0.45', '0.1'
'357', '2015-03-27', '18:43:26', '176.79.35.22', 'POP3', '192.168.1.50', '6.3'
'358', '2015-03-27', '16:20:58', '172.65.32.8', 'POP3', '192.168.1.50', '3.1'
'359', '2015-03-27', '13:34:57', '179.40.63.24', 'HTTPS', '10.0.0.45', '8.1'
'360', '2015-03-27', '12:37:24', '175.84.62.4', 'HTTPS', '192.168.1.50', '1.6'
'361', '2015-03-27', '04:28:57', '176.84.67.18', 'HTTPS', '10.0.0.45', '4'
'362', '2015-03-27', '12:10:38', '179.48.45.24', 'POP3', '10.0.0.45', '4.8'
'363', '2015-03-27', '03:30:44', '180.69.65.19', 'HTTPS', '10.0.0.45', '1'
'364', '2015-03-27', '07:10:36', '172.34.56.6', 'HTTPS', '192.168.1.39', '2.9'
'365', '2015-03-27', '01:18:20', '174.86.37.4', 'POP3', '192.168.1.50', '2.9'
'366', '2015-03-27', '01:29:37', '175.83.49.14', 'HTTPS', '10.0.0.45', '5.8'
'367', '2015-03-27', '08:09:27', '175.90.42.11', 'POP3', '10.0.0.45', '8'
'368', '2015-03-27', '19:10:05', '179.67.33.19', 'HTTPS', '10.0.0.45', '2.6'
'369', '2015-03-27', '17:37:40', '175.70.61.24', 'POP3', '192.168.1.50', '3'
'370', '2015-03-27', '23:00:44', '174.41.64.23', 'HTTPS', '192.168.1.50', '4.7'
'371', '2015-03-27', '16:40:06', '176.57.62.4', 'POP3', '10.0.0.45', '9'
'372', '2015-03-27', '21:23:53', '180.79.46.12', 'POP3', '10.0.0.100', '9.8'
'373', '2015-03-27', '12:20:57', '177.84.45.14', 'HTTPS', '10.0.0.45', '2.1'
'374', '2015-03-27', '19:01:43', '178.60.36.16', 'HTTPS', '10.0.0.45', '4.4'
'375', '2015-03-27', '00:02:22', '178.70.69.4', 'SFTP', '10.0.0.45', '1.2'
'376', '2015-03-27', '07:37:54', '174.37.34.17', 'POP3', '10.0.0.45', '7.1'
'377', '2015-03-27', '11:06:04', '174.85.70.5', 'FTP', '10.0.0.45', '7'
'378', '2015-03-27', '03:22:23', '178.66.65.6', 'POP3', '10.0.0.45', '3.6'
'379', '2015-03-27', '11:11:59', '178.67.39.18', 'POP3', '10.0.0.45', '7.1'
'380', '2015-03-27', '01:07:59', '173.71.67.19', 'POP3', '10.0.0.45', '7.2'
'381', '2015-03-27', '05:11:39', '173.89.55.16', 'POP3', '10.0.0.45', '1.5'
'382', '2015-03-27', '13:39:37', '176.39.65.5', 'POP3', '192.168.1.50', '1.9'
'383', '2015-03-27', '08:07:04', '173.34.60.7', 'POP3', '192.168.1.50', '0.1'
'384', '2015-03-27', '07:18:37', '180.44.67.20', 'HTTPS', '10.0.0.45', '6.4'
'385', '2015-03-27', '10:15:14', '178.71.49.5', 'HTTPS', '192.168.1.50', '5.5'
'386', '2015-03-27', '19:04:44', '173.57.53.15', 'HTTP', '10.0.0.100', '4.3'
'387', '2015-03-27', '01:56:04', '173.38.68.9', 'HTTPS', '10.0.0.45', '5.9'
'388', '2015-03-27', '16:03:41', '178.39.53.22', 'POP3', '10.0.0.45', '4.2'
'389', '2015-03-27', '11:03:07', '177.65.55.13', 'POP3', '10.0.0.45', '3.4'
'390', '2015-03-27', '11:32:37', '172.62.37.8', 'FTP', '10.0.0.45', '1.1'
'391', '2015-03-27', '01:12:55', '176.76.53.12', 'HTTPS', '10.0.0.45', '7.9'
'392', '2015-03-27', '17:27:30', '178.56.37.18', 'POP3', '10.0.0.45', '2.5'
'393', '2015-03-27', '13:04:45', '175.47.69.11', 'POP3', '192.168.1.50', '0.6'
'394', '2015-03-27', '14:20:57', '173.49.42.12', 'TELNET', '10.0.0.45', '5.3'
'395', '2015-03-27', '22:11:49', '176.35.32.17', 'POP3', '10.0.0.45', '6'
'396', '2015-03-27', '18:39:47', '177.51.55.4', 'HTTPS', '192.168.1.50', '9.7'
'397', '2015-03-27', '23:31:56', '177.42.51.6', 'POP3', '10.0.0.45', '9.8'
'398', '2015-03-27', '20:02:43', '172.44.36.3', 'POP3', '192.168.1.50', '3.2'
'399', '2015-03-27', '05:49:43', '172.63.38.12', 'HTTPS', '192.168.1.50', '7.2'
'400', '2015-03-27', '03:55:43', '177.88.46.6', 'POP3', '10.0.0.100', '8.1'
'401', '2015-03-27', '03:32:13', '176.54.56.13', 'TELNET', '10.0.0.45', '2.6'
'402', '2015-03-27', '08:32:06', '179.86.47.5', 'HTTPS', '10.0.0.45', '6.5'
'403', '2015-03-27', '15:43:17', '175.52.54.11', 'HTTPS', '10.0.0.45', '7.4'
'404', '2015-03-27', '22:41:43', '174.56.45.12', 'HTTPS', '10.0.0.45', '5.1'
'405', '2015-03-27', '11:42:25', '180.77.66.20', 'POP3', '10.0.0.45', '6.1'
'406', '2015-03-27', '04:21:57', '180.66.44.8', 'TELNET', '10.0.0.45', '2.5'
'407', '2015-03-27', '13:38:20', '175.67.33.7', 'POP3', '10.0.0.45', '8'
'408', '2015-03-27', '14:17:37', '178.62.58.8', 'POP3', '10.0.0.45', '1.1'
'409', '2015-03-27', '16:27:31', '172.50.32.22', 'POP3', '10.0.0.45', '3.4'
'410', '2015-03-27', '18:09:18', '175.53.64.4', 'SFTP', '10.0.0.45', '4.9'
'411', '2015-03-27', '01:02:20', '177.31.52.7', 'TELNET', '192.168.1.50', '2.3'
'412', '2015-03-27', '01:56:28', '179.49.68.10', 'SFTP', '192.168.1.50', '7.6'
'413', '2015-03-27', '05:08:26', '178.34.47.14', 'TELNET', '10.0.0.45', '3.9'
'414', '2015-03-27', '11:00:51', '172.39.58.8', 'POP3', '10.0.0.45', '2'
'415', '2015-03-27', '11:43:48', '176.80.69.22', 'POP3', '10.0.0.45', '9.9'
'416', '2015-03-27', '08:08:43', '173.63.35.8', 'HTTPS', '10.0.0.45', '7.3'
'417', '2015-03-27', '02:54:45', '173.33.52.12', 'HTTPS', '10.0.0.100', '5.3'
'418', '2015-03-27', '14:29:40', '174.73.43.13', 'POP3', '10.0.0.45', '7.2'
'419', '2015-03-27', '05:58:02', '176.58.47.7', 'POP3', '192.168.1.50', '7.3'
'420', '2015-03-27', '03:33:24', '179.39.54.17', 'POP3', '10.0.0.100', '6'
'421', '2015-03-27', '12:22:45', '176.56.38.6', 'HTTPS', '10.0.0.100', '4.3'
'422', '2015-03-27', '18:29:37', '174.53.34.17', 'TELNET', '192.168.1.50', '0.5'
'423', '2015-03-27', '12:33:51', '180.89.33.24', 'POP3', '10.0.0.45', '0'
'424', '2015-03-27', '14:04:35', '177.44.69.20', 'HTTP', '10.0.0.45', '5'
'425', '2015-03-27', '05:00:02', '179.43.45.3', 'HTTPS', '192.168.1.50', '0.2'
'426', '2015-03-27', '18:01:46', '176.66.59.14', 'HTTPS', '192.168.1.50', '8.8'
'427', '2015-03-27', '03:54:47', '174.61.37.21', 'POP3', '10.0.0.45', '2.4'
'428', '2015-03-27', '12:36:45', '175.37.37.12', 'POP3', '10.0.0.45', '7.9'
'429', '2015-03-27', '16:04:42', '179.68.48.25', 'HTTPS', '192.168.1.50', '0.9'
'430', '2015-03-27', '08:47:00', '172.56.30.17', 'POP3', '10.0.0.45', '9.5'
'431', '2015-03-27', '02:10:00', '176.38.38.23', 'POP3', '10.0.0.45', '8.3'
'432', '2015-03-27', '15:43:40', '176.50.70.3', 'POP3', '192.168.1.50', '3.4'
'433', '2015-03-27', '16:46:38', '177.72.60.25', 'POP3', '192.168.1.50', '5.1'
'434', '2015-03-27', '00:58:13', '176.31.69.15', 'POP3', '10.0.0.45', '9.6'
'435', '2015-03-27', '02:39:39', '178.60.68.18', 'TELNET', '10.0.0.45', '6.5'
'436', '2015-03-27', '13:24:45', '180.73.59.18', 'HTTPS', '10.0.0.45', '1.4'
'437', '2015-03-27', '12:22:58', '180.45.30.12', 'HTTPS', '10.0.0.45', '6.3'
'438', '2015-03-27', '09:29:17', '173.35.67.8', 'POP3', '10.0.0.45', '9.9'
'439', '2015-03-27', '01:49:28', '172.45.33.10', 'HTTPS', '10.0.0.45', '0.9'
'440', '2015-03-27', '03:18:39', '178.34.59.12', 'POP3', '192.168.1.50', '6.4'
'441', '2015-03-27', '21:26:05', '173.86.42.7', 'HTTPS', '192.168.1.50', '0'
'442', '2015-03-27', '09:06:28', '173.44.70.5', 'HTTPS', '192.168.1.50', '2.4'
'443', '2015-03-27', '00:26:17', '180.74.70.12', 'HTTPS', '10.0.0.45', '2.4'
'444', '2015-03-27', '19:12:09', '176.90.35.7', 'HTTP', '192.168.1.50', '2'
'445', '2015-03-27', '11:30:10', '172.70.55.3', 'POP3', '192.168.1.50', '3.5'
'446', '2015-03-27', '20:43:59', '176.35.64.16', 'POP3', '192.168.1.50', '0.4'
'447', '2015-03-27', '19:33:26', '172.40.34.5', 'HTTPS', '10.0.0.45', '5.2'
'448', '2015-03-27', '10:13:09', '177.65.63.16', 'HTTPS', '192.168.1.50', '8.2'
'449', '2015-03-27', '04:39:44', '177.81.53.18', 'HTTPS', '192.168.1.50', '2.5'
'450', '2015-03-27', '02:18:36', '172.34.70.21', 'HTTPS', '10.0.0.45', '8.3'
'451', '2015-03-27', '16:44:13', '180.45.56.25', 'POP3', '192.168.1.39', '7.2'
'452', '2015-03-27', '12:08:48', '172.40.40.9', 'POP3', '10.0.0.45', '4.5'
'453', '2015-03-27', '12:44:18', '176.58.35.18', 'HTTPS', '192.168.1.50', '5.5'
'454', '2015-03-27', '00:53:44', '179.90.35.14', 'POP3', '192.168.1.50', '4.3'
'455', '2015-03-27', '08:15:19', '174.36.55.8', 'POP3', '10.0.0.45', '9.4'
'456', '2015-03-27', '01:02:14', '175.33.69.18', 'POP3', '10.0.0.45', '7'
'457', '2015-03-27', '11:43:08', '174.45.43.7', 'HTTP', '10.0.0.45', '4.6'
'458', '2015-03-27', '05:37:26', '176.86.67.10', 'TELNET', '192.168.1.50', '1.8'
'459', '2015-03-27', '02:47:28', '176.76.51.21', 'POP3', '10.0.0.45', '1.5'
'460', '2015-03-27', '12:05:56', '173.50.42.8', 'HTTPS', '10.0.0.45', '3.8'
'461', '2015-03-27', '16:42:30', '180.36.33.20', 'HTTPS', '192.168.1.50', '0.1'
'462', '2015-03-27', '08:28:27', '172.49.48.4', 'HTTPS', '10.0.0.45', '4.3'
'463', '2015-03-27', '03:25:17', '180.30.67.21', 'HTTP', '10.0.0.45', '0.9'
'464', '2015-03-27', '09:29:36', '179.38.69.22', 'FTP', '10.0.0.45', '9.8'
'465', '2015-03-27', '11:58:21', '172.87.56.24', 'POP3', '10.0.0.45', '0.1'
'466', '2015-03-27', '17:10:58', '176.79.45.15', 'HTTPS', '10.0.0.45', '2.8'
'467', '2015-03-27', '00:35:46', '173.73.41.7', 'POP3', '192.168.1.50', '4'
'468', '2015-03-27', '06:27:18', '179.66.41.8', 'HTTPS', '10.0.0.45', '0.6'
'469', '2015-03-27', '22:17:45', '179.66.61.14', 'HTTPS', '192.168.1.50', '2.2'
'470', '2015-03-27', '19:31:10', '172.32.39.14', 'HTTPS', '10.0.0.45', '7.5'
'471', '2015-03-27', '20:12:52', '179.47.65.3', 'POP3', '10.0.0.45', '7.2'
'472', '2015-03-27', '03:41:38', '180.56.56.13', 'POP3', '10.0.0.100', '0.4'
'473', '2015-03-27', '03:35:58', '180.33.53.24', 'HTTPS', '10.0.0.45', '6.3'
'474', '2015-03-27', '11:10:50', '177.63.31.10', 'POP3', '192.168.1.50', '6.4'
'475', '2015-03-27', '04:28:18', '179.72.64.23', 'HTTPS', '10.0.0.100', '9.2'
'476', '2015-03-27', '02:04:13', '172.32.62.21', 'POP3', '192.168.1.50', '7'
'477', '2015-03-27', '00:09:01', '174.86.43.17', 'POP3', '10.0.0.45', '9.3'
'478', '2015-03-27', '20:11:28', '175.58.57.24', 'POP3', '192.168.1.39', '1.9'
'479', '2015-03-27', '07:42:08', '172.44.47.14', 'POP3', '10.0.0.45', '9.6'
'480', '2015-03-27', '02:15:59', '180.66.58.14', 'HTTPS', '192.168.1.50', '6.2'
'481', '2015-03-27', '15:41:51', '177.83.53.23', 'HTTPS', '10.0.0.45', '2.5'
'482', '2015-03-27', '22:14:28', '177.70.39.3', 'HTTPS', '10.0.0.45', '3.8'
'483', '2015-03-27', '22:21:36', '173.53.45.13', 'HTTPS', '10.0.0.45', '6.5'
'484', '2015-03-27', '00:51:57', '178.35.65.17', 'POP3', '10.0.0.45', '2.4'
'485', '2015-03-27', '09:53:59', '180.40.54.11', 'HTTPS', '10.0.0.45', '3.5'
'486', '2015-03-27', '20:17:07', '172.66.43.24', 'POP3', '192.168.1.50', '7'
'487', '2015-03-27', '21:05:03', '174.74.64.16', 'HTTPS', '10.0.0.45', '7.7'
'488', '2015-03-27', '21:22:33', '174.38.64.16', 'POP3', '192.168.1.50', '5.1'
'489', '2015-03-27', '08:38:32', '177.87.50.3', 'POP3', '10.0.0.45', '3.7'
'490', '2015-03-27', '01:37:02', '179.43.60.16', 'SFTP', '10.0.0.45', '4.6'
'491', '2015-03-27', '19:37:09', '176.76.38.8', 'POP3', '10.0.0.45', '5.6'
'492', '2015-03-27', '08:37:23', '174.41.35.3', 'POP3', '192.168.1.50', '0.4'
'493', '2015-03-27', '18:26:12', '174.75.65.19', 'HTTPS', '10.0.0.45', '7.7'
'494', '2015-03-27', '22:40:57', '172.59.47.23', 'POP3', '10.0.0.45', '1.3'
'495', '2015-03-27', '13:02:01', '173.82.30.18', 'HTTPS', '10.0.0.45', '1.9'
'496', '2015-03-27', '03:10:08', '176.60.66.9', 'TELNET', '10.0.0.45', '4'
'497', '2015-03-27', '07:40:43', '178.65.51.9', 'POP3', '10.0.0.45', '0.5'
'498', '2015-03-27', '04:05:39', '176.37.52.25', 'POP3', '10.0.0.45', '6.1'
'499', '2015-03-27', '16:09:18', '178.72.49.22', 'SFTP', '10.0.0.45', '4.6'
'500', '2015-03-27', '06:23:08', '178.90.69.25', 'HTTPS', '10.0.0.45', '3.9'
'501', '2015-03-27', '02:59:54', '176.77.68.12', 'HTTPS', '10.0.0.45', '4.3'
'502', '2015-03-27', '09:04:13', '175.65.42.4', 'HTTPS', '10.0.0.45', '0.7'
'503', '2015-03-27', '10:29:01', '173.44.42.6', 'HTTPS', '10.0.0.100', '8'
'504', '2015-03-27', '10:00:25', '179.46.34.18', 'POP3', '10.0.0.45', '8.9'
'505', '2015-03-27', '20:29:21', '177.56.30.11', 'POP3', '10.0.0.100', '2.3'
'506', '2015-03-27', '18:36:18', '176.47.41.13', 'HTTPS', '192.168.1.50', '0.3'
'507', '2015-03-27', '08:01:18', '172.66.64.3', 'TELNET', '10.0.0.45', '6.3'
'508', '2015-03-27', '12:43:00', '174.89.38.23', 'POP3', '10.0.0.45', '1.9'
'509', '2015-03-27', '12:38:14', '172.75.40.3', 'HTTPS', '192.168.1.39', '5.2'
'510', '2015-03-27', '01:25:55', '172.84.38.12', 'HTTPS', '10.0.0.45', '0.7'
'511', '2015-03-27', '01:17:39', '175.44.33.16', 'POP3', '10.0.0.45', '2'
'512', '2015-03-27', '00:57:11', '172.48.57.4', 'POP3', '10.0.0.45', '6.2'
'513', '2015-03-27', '05:45:47', '174.47.38.7', 'POP3', '10.0.0.45', '9.2'
'514', '2015-03-27', '21:02:49', '177.67.46.21', 'POP3', '10.0.0.45', '4.6'
'515', '2015-03-27', '03:12:16', '180.80.54.15', 'HTTPS', '192.168.1.50', '8'
'516', '2015-03-27', '11:31:51', '178.31.45.3', 'POP3', '10.0.0.45', '4.1'
'517', '2015-03-27', '17:27:23', '173.54.51.10', 'HTTPS', '10.0.0.45', '7.5'
'518', '2015-03-27', '19:37:32', '174.71.35.24', 'POP3', '10.0.0.45', '2.1'
'519', '2015-03-27', '17:28:28', '174.73.30.15', 'HTTPS', '10.0.0.45', '7.1'
'520', '2015-03-27', '13:29:00', '175.80.47.5', 'HTTPS', '10.0.0.45', '0.2'
'521', '2015-03-27', '23:51:15', '172.61.52.8', 'POP3', '10.0.0.45', '6.3'
'522', '2015-03-27', '07:48:56', '180.81.68.11', 'HTTPS', '10.0.0.45', '4.8'
'523', '2015-03-27', '18:46:25', '174.42.63.21', 'HTTPS', '192.168.1.50', '6.4'
'524', '2015-03-27', '16:53:41', '178.59.47.16', 'POP3', '192.168.1.50', '0.9'
'525', '2015-03-27', '06:13:07', '172.90.56.8', 'HTTPS', '192.168.1.50', '6.5'
'526', '2015-03-27', '01:10:35', '176.42.55.23', 'POP3', '10.0.0.45', '6.1'
'527', '2015-03-27', '13:41:55', '172.62.49.18', 'POP3', '10.0.0.100', '6.3'
'528', '2015-03-27', '04:27:52', '175.51.48.11', 'HTTPS', '10.0.0.45', '7.9'
'529', '2015-03-27', '16:21:02', '180.70.35.16', 'POP3', '10.0.0.45', '8.1'
'530', '2015-03-27', '00:54:40', '175.80.38.19', 'POP3', '10.0.0.45', '9.4'
'531', '2015-03-27', '07:06:51', '172.42.70.14', 'SFTP', '192.168.1.50', '9.8'
'532', '2015-03-27', '06:35:29', '174.54.66.20', 'HTTPS', '10.0.0.45', '4.4'
'533', '2015-03-27', '23:22:19', '177.75.37.5', 'FTP', '10.0.0.45', '0'
'534', '2015-03-27', '05:54:09', '172.64.34.21', 'POP3', '10.0.0.45', '0.9'
'535', '2015-03-27', '03:30:25', '173.31.47.11', 'TELNET', '10.0.0.45', '5.2'
'536', '2015-03-27', '15:10:17', '173.53.31.10', 'FTP', '192.168.1.50', '7.6'
'537', '2015-03-27', '12:30:24', '172.63.55.13', 'HTTPS', '10.0.0.45', '7.2'
'538', '2015-03-27', '08:25:35', '174.58.48.23', 'SFTP', '192.168.1.50', '3'
'539', '2015-03-27', '06:04:32', '173.47.53.12', 'TELNET', '10.0.0.45', '4.3'
'540', '2015-03-27', '05:37:15', '176.77.58.4', 'HTTPS', '10.0.0.45', '8.1'
'541', '2015-03-27', '01:42:30', '179.33.51.13', 'HTTPS', '10.0.0.45', '9.9'
'542', '2015-03-27', '07:26:55', '172.38.43.19', 'HTTPS', '192.168.1.50', '7.9'
'543', '2015-03-27', '07:20:50', '178.54.52.8', 'POP3', '10.0.0.45', '1.4'
'544', '2015-03-27', '22:31:50', '172.50.59.18', 'POP3', '10.0.0.45', '0.3'
'545', '2015-03-27', '15:32:19', '180.85.37.23', 'TELNET', '10.0.0.45', '8.9'
'546', '2015-03-27', '15:44:43', '180.68.61.22', 'HTTPS', '192.168.1.50', '9.7'
'547', '2015-03-27', '10:45:44', '173.35.63.3', 'HTTPS', '10.0.0.45', '7.2'
'548', '2015-03-27', '04:59:52', '174.83.42.21', 'POP3', '10.0.0.45', '1.7'
'549', '2015-03-27', '09:29:55', '176.63.42.10', 'HTTP', '10.0.0.45', '8.3'
'550', '2015-03-27', '11:23:44', '174.79.57.25', 'POP3', '192.168.1.50', '7.1'
'551', '2015-03-27', '03:06:02', '172.68.53.24', 'POP3', '10.0.0.45', '1.1'
'552', '2015-03-27', '08:49:39', '173.35.46.3', 'HTTPS', '10.0.0.100', '9'
'553', '2015-03-27', '09:43:31', '179.83.35.7', 'HTTPS', '10.0.0.45', '1.6'
'554', '2015-03-27', '14:10:42', '177.68.59.3', 'POP3', '192.168.1.50', '1.6'
'555', '2015-03-27', '16:47:19', '177.59.70.11', 'HTTPS', '10.0.0.45', '9.5'
'556', '2015-03-27', '08:18:20', '174.71.64.21', 'POP3', '192.168.1.50', '5.8'
'557', '2015-03-27', '21:13:56', '174.67.36.22', 'HTTPS', '10.0.0.45', '3.2'
'558', '2015-03-27', '22:53:02', '179.42.51.13', 'HTTP', '10.0.0.45', '3.5'
'559', '2015-03-27', '10:01:24', '179.67.58.14', 'POP3', '192.168.1.50', '7'
'560', '2015-03-27', '16:26:05', '173.86.44.22', 'TELNET', '10.0.0.45', '5.6'
'561', '2015-03-27', '03:58:40', '180.33.31.14', 'POP3', '192.168.1.50', '1'
'562', '2015-03-27', '22:36:04', '172.79.65.18', 'HTTP', '10.0.0.45', '9.9'
'563', '2015-03-27', '11:16:52', '178.33.34.6', 'HTTPS', '10.0.0.45', '10'
'564', '2015-03-27', '03:49:42', '174.51.49.21', 'HTTPS', '10.0.0.45', '3.2'
'565', '2015-03-27', '05:16:05', '175.83.44.5', 'POP3', '192.168.1.39', '4.5'
'566', '2015-03-27', '09:43:22', '176.78.57.11', 'POP3', '10.0.0.45', '5.4'
'567', '2015-03-27', '11:38:12', '173.80.30.4', 'POP3', '10.0.0.45', '0.1'
'568', '2015-03-27', '01:35:58', '172.90.37.24', 'POP3', '192.168.1.50', '1.7'
'569', '2015-03-27', '00:55:38', '175.54.56.9', 'POP3', '10.0.0.45', '7.9'
'570', '2015-03-27', '05:40:03', '172.48.51.14', 'POP3', '10.0.0.100', '2.7'
'571', '2015-03-27', '02:19:52', '174.74.30.16', 'HTTPS', '10.0.0.100', '6.8'
'572', '2015-03-27', '07:04:31', '177.70.35.15', 'HTTP', '10.0.0.45', '8.9'
'573', '2015-03-27', '10:44:03', '174.50.61.25', 'TELNET', '10.0.0.45', '1.9'
'574', '2015-03-27', '01:32:11', '172.75.65.12', 'HTTPS', '192.168.1.50', '9.2'
'575', '2015-03-27', '04:58:03', '175.51.54.6', 'POP3', '10.0.0.45', '1.9'
'576', '2015-03-27', '13:19:40', '176.37.58.20', 'POP3', '192.168.1.50', '1.2'
'577', '2015-03-27', '11:07:51', '175.60.56.18', 'POP3', '10.0.0.45', '3.8'
'578', '2015-03-27', '14:10:06', '180.88.35.5', 'POP3', '10.0.0.45', '5.7'
'579', '2015-03-27', '19:43:05', '176.65.70.4', 'SFTP', '10.0.0.45', '1.9'
'580', '2015-03-27', '04:10:45', '174.32.31.14', 'HTTPS', '192.168.1.50', '6.5'
'581', '2015-03-27', '15:16:45', '177.40.57.22', 'HTTP', '192.168.1.50', '2.4'
'582', '2015-03-27', '20:30:41', '176.60.65.23', 'POP3', '192.168.1.50', '0.8'
'583', '2015-03-27', '23:20:26', '176.37.68.22', 'HTTPS', '10.0.0.45', '5.9'
'584', '2015-03-27', '11:18:47', '180.66.48.15', 'HTTPS', '192.168.1.50', '9.6'
'585', '2015-03-27', '00:23:02', '177.30.65.19', 'SFTP', '10.0.0.45', '7.7'
'586', '2015-03-27', '02:40:09', '176.58.36.18', 'HTTPS', '10.0.0.45', '0.8'
'587', '2015-03-27', '08:46:59', '172.73.64.3', 'HTTPS', '192.168.1.50', '8.7'
'588', '2015-03-27', '16:00:04', '179.52.46.13', 'HTTPS', '192.168.1.50', '9.1'
'589', '2015-03-27', '15:26:45', '178.82.41.19', 'POP3', '192.168.1.50', '1.2'
'590', '2015-03-27', '06:00:01', '176.73.34.5', 'TELNET', '10.0.0.45', '6'
'591', '2015-03-27', '17:51:56', '172.62.69.19', 'HTTP', '192.168.1.50', '6.6'
'592', '2015-03-27', '07:17:57', '177.54.70.14', 'TELNET', '10.0.0.45', '5.3'
'593', '2015-03-27', '23:33:42', '172.71.69.6', 'HTTPS', '192.168.1.50', '1.8'
'594', '2015-03-27', '21:29:15', '175.46.50.7', 'HTTPS', '10.0.0.45', '9.3'
'595', '2015-03-27', '19:16:58', '175.58.63.11', 'HTTPS', '10.0.0.45', '3.9'
'596', '2015-03-27', '02:17:09', '177.75.68.25', 'HTTP', '192.168.1.50', '8.6'
'597', '2015-03-27', '03:06:50', '177.35.66.3', 'HTTPS', '192.168.1.50', '4.2'
'598', '2015-03-27', '20:07:49', '179.53.52.12', 'HTTPS', '10.0.0.45', '5.6'
'599', '2015-03-27', '11:42:50', '172.42.62.8', 'HTTPS', '192.168.1.39', '9.3'
'600', '2015-03-27', '20:00:48', '180.41.34.9', 'POP3', '10.0.0.45', '6.6'
'601', '2015-03-27', '13:15:50', '175.53.37.24', 'TELNET', '10.0.0.45', '5.9'
'602', '2015-03-27', '20:06:37', '180.32.55.25', 'TELNET', '10.0.0.45', '2.8'
'603', '2015-03-27', '22:26:07', '174.75.70.23', 'HTTPS', '10.0.0.45', '7.9'
'604', '2015-03-27', '17:56:36', '180.51.58.7', 'POP3', '192.168.1.50', '3.1'
'605', '2015-03-27', '16:06:33', '173.34.49.13', 'HTTPS', '10.0.0.45', '2.8'
'606', '2015-03-27', '07:39:58', '175.49.63.7', 'HTTPS', '10.0.0.45', '3.6'
'607', '2015-03-27', '05:33:41', '180.42.63.18', 'HTTPS', '192.168.1.50', '4'
'608', '2015-03-27', '04:57:50', '177.90.52.14', 'POP3', '10.0.0.45', '6.2'
'609', '2015-03-27', '01:40:31', '179.39.30.5', 'FTP', '10.0.0.45', '3.9'
'610', '2015-03-27', '09:07:24', '178.50.42.17', 'HTTP', '192.168.1.50', '2.4'
'611', '2015-03-27', '14:40:14', '173.39.58.24', 'TELNET', '10.0.0.45', '9.5'
'612', '2015-03-27', '10:02:43', '180.84.59.21', 'HTTP', '10.0.0.45', '1.2'
'613', '2015-03-27', '15:04:44', '173.31.40.18', 'HTTP', '10.0.0.100', '4.3'
'614', '2015-03-27', '06:23:56', '174.60.64.8', 'HTTPS', '10.0.0.45', '3.2'
'615', '2015-03-27', '09:44:28', '175.36.48.5', 'HTTPS', '192.168.1.50', '3.3'
'616', '2015-03-27', '05:42:39', '174.53.67.16', 'HTTP', '10.0.0.45', '8.9'
'617', '2015-03-27', '16:16:02', '177.71.55.7', 'HTTPS', '192.168.1.50', '1.3'
'618', '2015-03-27', '23:14:58', '180.54.55.15', 'POP3', '192.168.1.50', '2.2'
'619', '2015-03-27', '18:39:35', '176.85.46.6', 'POP3', '192.168.1.50', '1.3'
'620', '2015-03-27', '16:05:48', '176.72.46.21', 'HTTPS', '10.0.0.100', '5.8'
'621', '2015-03-27', '15:49:01', '174.34.38.13', 'TELNET', '10.0.0.45', '1.7'
'622', '2015-03-27', '04:46:08', '172.44.46.11', 'TELNET', '10.0.0.45', '4.6'
'623', '2015-03-27', '12:43:13', '174.59.50.4', 'HTTP', '10.0.0.45', '9.8'
'624', '2015-03-27', '09:44:55', '176.61.70.8', 'POP3', '10.0.0.45', '6.3'
'625', '2015-03-27', '08:55:48', '179.82.68.11', 'HTTPS', '192.168.1.39', '0.8'
'626', '2015-03-27', '10:48:43', '172.70.63.6', 'HTTPS', '10.0.0.45', '4.3'
'627', '2015-03-27', '18:47:09', '179.87.47.9', 'POP3', '192.168.1.50', '8'
'628', '2015-03-27', '19:39:48', '174.83.46.7', 'HTTPS', '10.0.0.45', '6.9'
'629', '2015-03-27', '21:56:40', '173.38.55.10', 'POP3', '10.0.0.45', '3.9'
'630', '2015-03-27', '19:43:11', '178.69.49.14', 'HTTPS', '10.0.0.45', '2'
'631', '2015-03-27', '11:12:06', '174.80.49.23', 'POP3', '192.168.1.50', '10'
'632', '2015-03-27', '01:33:20', '175.50.46.12', 'HTTP', '192.168.1.50', '9.5'
'633', '2015-03-27', '19:57:04', '177.87.60.13', 'HTTPS', '10.0.0.45', '1.8'
'634', '2015-03-27', '19:38:49', '174.80.68.7', 'POP3', '10.0.0.45', '3'
'635', '2015-03-27', '21:30:37', '177.86.54.21', 'HTTPS', '192.168.1.50', '4.7'
'636', '2015-03-27', '02:57:05', '175.60.44.21', 'HTTP', '192.168.1.50', '4'
'637', '2015-03-27', '02:57:33', '172.65.51.14', 'POP3', '192.168.1.50', '6.1'
'638', '2015-03-27', '18:02:12', '179.38.63.20', 'POP3', '10.0.0.45', '3.8'
'639', '2015-03-27', '20:21:51', '178.65.50.6', 'HTTPS', '192.168.1.50', '1.8'
'640', '2015-03-27', '01:40:49', '179.35.32.7', 'HTTPS', '10.0.0.45', '1'
'641', '2015-03-27', '07:30:19', '176.45.43.7', 'SFTP', '192.168.1.50', '6.2'
'642', '2015-03-27', '16:06:32', '176.46.61.16', 'POP3', '192.168.1.39', '8.9'
'643', '2015-03-27', '12:03:44', '177.77.46.13', 'POP3', '10.0.0.45', '1'
'644', '2015-03-27', '16:20:14', '174.75.66.17', 'TELNET', '10.0.0.45', '0.7'
'645', '2015-03-27', '01:22:08', '174.58.58.5', 'HTTPS', '10.0.0.45', '6.5'
'646', '2015-03-27', '17:14:08', '178.54.63.3', 'POP3', '10.0.0.45', '6.2'
'647', '2015-03-27', '23:30:20', '180.75.58.12', 'HTTPS', '10.0.0.45', '1.7'
'648', '2015-03-27', '09:19:42', '175.72.41.12', 'HTTPS', '10.0.0.45', '3.8'
'649', '2015-03-27', '05:59:48', '179.81.35.10', 'HTTPS', '10.0.0.45', '7'
'650', '2015-03-27', '16:28:04', '180.90.43.23', 'HTTPS', '10.0.0.45', '4.7'
'651', '2015-03-27', '04:28:58', '179.67.38.19', 'POP3', '10.0.0.45', '9.4'
'652', '2015-03-27', '07:03:56', '173.53.59.9', 'FTP', '10.0.0.45', '9.8'
'653', '2015-03-27', '17:01:21', '179.43.37.16', 'HTTPS', '192.168.1.50', '8'
'654', '2015-03-27', '09:13:59', '179.48.42.6', 'TELNET', '10.0.0.45', '8.2'
'655', '2015-03-27', '10:06:30', '176.56.54.9', 'TELNET', '10.0.0.45', '4.9'
'656', '2015-03-27', '11:32:15', '179.55.55.6', 'TELNET', '10.0.0.45', '5'
'657', '2015-03-27', '14:43:01', '173.33.30.10', 'POP3', '10.0.0.45', '4.4'
'658', '2015-03-27', '02:44:16', '180.72.64.16', 'POP3', '10.0.0.45', '3.2'
'659', '2015-03-27', '23:23:55', '180.77.56.20', 'HTTPS', '192.168.1.50', '3.4'
'660', '2015-03-27', '04:19:17', '180.64.42.19', 'POP3', '10.0.0.45', '6.7'
'661', '2015-03-27', '11:07:55', '173.88.61.13', 'HTTPS', '10.0.0.45', '2.6'
'662', '2015-03-27', '11:21:55', '180.65.51.24', 'POP3', '192.168.1.39', '2.1'
'663', '2015-03-27', '12:05:26', '174.34.56.7', 'POP3', '192.168.1.50', '2.7'
'664', '2015-03-27', '00:51:53', '180.85.33.19', 'POP3', '10.0.0.45', '6.1'
'665', '2015-03-27', '10:39:35', '175.33.61.25', 'FTP', '10.0.0.45', '7.9'
'666', '2015-03-27', '05:02:40', '180.75.45.8', 'HTTPS', '10.0.0.45', '9.2'
'667', '2015-03-27', '22:14:34', '173.41.38.10', 'HTTP', '192.168.1.50', '4.7'
'668', '2015-03-27', '07:04:12', '180.47.56.16', 'HTTPS', '10.0.0.45', '2.6'
'669', '2015-03-27', '23:40:33', '180.85.70.15', 'POP3', '10.0.0.45', '9.7'
'670', '2015-03-27', '09:32:42', '179.52.45.3', 'HTTPS', '192.168.1.50', '5.8'
'671', '2015-03-27', '07:06:07', '176.53.45.19', 'POP3', '10.0.0.45', '4.3'
'672', '2015-03-27', '00:03:17', '180.42.56.7', 'HTTPS', '10.0.0.45', '8.3'
'673', '2015-03-27', '18:27:23', '175.71.36.5', 'FTP', '192.168.1.50', '0.9'
'674', '2015-03-27', '16:06:36', '180.66.41.20', 'FTP', '192.168.1.50', '8'
'675', '2015-03-27', '01:28:36', '175.38.34.20', 'POP3', '192.168.1.50', '7.1'
'676', '2015-03-27', '01:08:06', '180.42.64.21', 'HTTPS', '10.0.0.45', '4.1'
'677', '2015-03-27', '19:25:47', '176.51.31.5', 'POP3', '192.168.1.50', '4.4'
'678', '2015-03-27', '23:53:23', '175.86.62.3', 'POP3', '192.168.1.50', '8.5'
'679', '2015-03-27', '00:19:01', '179.48.40.24', 'FTP', '10.0.0.45', '3.3'
'680', '2015-03-27', '22:32:27', '173.76.57.22', 'HTTPS', '10.0.0.45', '3.3'
'681', '2015-03-27', '00:40:24', '178.38.31.9', 'POP3', '10.0.0.45', '5.1'
'682', '2015-03-27', '09:33:41', '177.84.67.23', 'POP3', '10.0.0.45', '7.7'
'683', '2015-03-27', '00:12:27', '175.80.30.11', 'POP3', '10.0.0.45', '2.7'
'684', '2015-03-27', '19:12:33', '178.44.68.20', 'POP3', '192.168.1.50', '0.8'
'685', '2015-03-27', '04:06:59', '175.41.53.17', 'POP3', '10.0.0.45', '9.5'
'686', '2015-03-27', '11:51:35', '173.43.57.14', 'HTTP', '10.0.0.45', '3.1'
'687', '2015-03-27', '07:52:36', '177.87.56.11', 'HTTP', '10.0.0.45', '1.2'
'688', '2015-03-27', '12:42:05', '176.90.46.25', 'POP3', '192.168.1.50', '4.3'
'689', '2015-03-27', '04:29:11', '180.60.59.20', 'POP3', '10.0.0.45', '1.3'
'690', '2015-03-27', '14:08:14', '177.62.37.7', 'SFTP', '10.0.0.45', '8.7'
'691', '2015-03-27', '18:39:05', '172.74.63.4', 'HTTPS', '10.0.0.45', '7'
'692', '2015-03-27', '03:00:39', '176.79.37.16', 'SFTP', '10.0.0.45', '5.9'
'693', '2015-03-27', '10:31:16', '173.33.36.4', 'HTTPS', '10.0.0.45', '5'
'694', '2015-03-27', '15:06:53', '172.47.70.13', 'HTTPS', '10.0.0.100', '3.5'
'695', '2015-03-27', '20:17:17', '176.56.43.9', 'POP3', '192.168.1.50', '8.7'
'696', '2015-03-27', '09:51:54', '177.61.61.8', 'TELNET', '10.0.0.45', '1.8'
'697', '2015-03-27', '08:25:15', '174.79.45.5', 'POP3', '10.0.0.45', '8.5'
'698', '2015-03-27', '21:31:45', '174.54.38.3', 'HTTPS', '10.0.0.45', '0.8'
'699', '2015-03-27', '15:24:33', '174.80.35.23', 'HTTPS', '10.0.0.45', '4.8'
'700', '2015-03-27', '16:17:39', '180.55.69.13', 'POP3', '10.0.0.45', '6.3'
'701', '2015-03-27', '10:16:11', '180.66.62.15', 'POP3', '10.0.0.45', '1.8'
'702', '2015-03-27', '06:18:46', '172.65.56.13', 'HTTPS', '10.0.0.45', '0.9'
'703', '2015-03-27', '00:38:46', '173.40.37.16', 'POP3', '10.0.0.100', '8.4'
'704', '2015-03-27', '06:32:14', '177.89.30.19', 'POP3', '10.0.0.45', '3.8'
'705', '2015-03-27', '11:13:51', '175.82.52.16', 'TELNET', '192.168.1.50', '4.1'
'706', '2015-03-27', '20:25:45', '176.33.53.22', 'TELNET', '10.0.0.100', '3.5'
'707', '2015-03-27', '01:03:25', '175.33.56.25', 'HTTPS', '192.168.1.50', '2'
'708', '2015-03-27', '06:16:36', '173.55.59.8', 'POP3', '10.0.0.45', '6.2'
'709', '2015-03-27', '02:40:52', '175.30.31.22', 'TELNET', '10.0.0.45', '4.4'
'710', '2015-03-27', '13:47:41', '176.87.59.20', 'HTTPS', '192.168.1.50', '4.1'
'711', '2015-03-27', '17:19:44', '176.65.31.22', 'HTTPS', '192.168.1.39', '6.1'
'712', '2015-03-27', '16:05:46', '177.87.70.6', 'HTTP', '10.0.0.45', '9.5'
'713', '2015-03-27', '05:11:41', '173.35.30.15', 'POP3', '192.168.1.50', '4.7'
'714', '2015-03-27', '11:51:24', '175.49.44.20', 'HTTPS', '10.0.0.45', '8.3'
'715', '2015-03-27', '18:09:22', '174.60.69.12', 'TELNET', '192.168.1.50', '3.5'
'716', '2015-03-27', '20:18:47', '177.51.48.13', 'POP3', '192.168.1.50', '7.3'
'717', '2015-03-27', '18:49:51', '180.53.47.11', 'POP3', '10.0.0.45', '9.3'
'718', '2015-03-27', '04:19:11', '177.75.36.9', 'POP3', '192.168.1.50', '3.9'
'719', '2015-03-27', '12:01:25', '176.32.67.18', 'POP3', '10.0.0.45', '7.1'
'720', '2015-03-27', '22:28:31', '177.48.37.25', 'POP3', '192.168.1.50', '9.8'
'721', '2015-03-27', '05:03:18', '172.60.46.6', 'POP3', '192.168.1.39', '1.5'
'722', '2015-03-27', '18:30:25', '178.74.64.4', 'HTTPS', '10.0.0.45', '7.1'
'723', '2015-03-27', '11:27:06', '177.40.52.15', 'HTTPS', '10.0.0.45', '3.1'
'724', '2015-03-27', '00:53:02', '177.73.66.6', 'POP3', '192.168.1.50', '4'
'725', '2015-03-27', '20:38:37', '175.48.43.6', 'HTTPS', '10.0.0.45', '5.3'
'726', '2015-03-27', '16:38:33', '178.33.67.8', 'HTTPS', '192.168.1.50', '1.1'
'727', '2015-03-27', '00:49:29', '176.50.68.3', 'HTTP', '10.0.0.45', '8.2'
'728', '2015-03-27', '17:06:58', '174.47.62.4', 'HTTPS', '192.168.1.50', '0.7'
output should be
Protocol Ratio
POP3 0.4121
HTTPS 0.3791
TELNET 0.0879
HTTP 0.0549
SFTP 0.0440
FTP 0.0220
The second querie is Find the frquency of the connections to each protocol type in each location. Answer should look like below.
Location Protocol Ratio
East POP3 0.1456
East HTTPS 0.1168
East TELNET 0.0247
East HTTP 0.0179
East SFTP 0.0096
East FTP 0.0082
West POP3 0.2665
West HTTPS 0.2624
West TELNET 0.0632
West HTTP 0.0371
Explanation / Answer
Answer
1.
SELECT Protocol, COUNT (*) AS Total, ((SELECT Protocol, COUNT(Protocol) as Frequency) / Total) AS Ratio
FROM TRAFFIC
GROUP BY Protocol
2.
SELECT Location, (SELECT Protocol, COUNT (*) AS Total, ((SELECT Protocol, COUNT(Protocol) as Frequency) / Total) AS Ratio)
FROM TRAFFIC
GROUP BY Protocol
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.