Question: Hello, how would I Write a piped command using head, tail, sort, cut, and sed to return the date of the latest event in the

Hello, how would I Write a piped command using head, tail, sort, cut, and sed to return the date of the latest event in the file in yyyy/mm/dd format? Here is the Input file (lab0202.csv):

date time protocol ip-address port packet-size

2018-01-01 19:27:19 TCP 11.101.6.64 22 44

2018-04-17 01:35:12 UDP 10.101.7.69 2135 83

2018-05-05 04:26:05 UDP 11.101.6.65 2160 104

2018-08-20 15:43:16 TCP 10.101.7.64 22 113

2018-02-10 02:28:02 UDP 11.101.6.65 2089 68

2018-03-22 00:05:32 TCP 9.101.7.65 23 92

2018-04-24 19:32:47 TCP 9.100.8.65 22 93

2018-05-19 01:22:06 TCP 10.100.7.64 2107 29

2018-04-13 03:51:33 TCP 9.102.8.64 22 32

2018-08-16 21:02:36 UDP 11.100.8.65 2190 17

2018-06-27 00:44:54 UDP 11.101.6.65 2109 73

2018-01-08 07:39:00 TCP 10.101.8.65 22 74

2018-01-22 07:08:54 UDP 9.101.7.65 2165 27

2018-01-11 07:17:44 TCP 11.101.6.65 22 110

2018-01-10 13:14:41 TCP 10.101.7.64 22 89

2018-08-23 13:47:24 UDP 11.100.6.65 2187 93

2018-08-17 06:29:35 TCP 11.101.6.65 2114 66

2018-11-23 02:22:22 UDP 9.100.7.64 2142 118

2018-09-22 22:06:47 TCP 11.101.6.65 22 9

2018-04-04 09:41:43 UDP 9.102.7.64 2116 34

and the expected output file is: 2018/11/23

Also, how would I write a piped command using grep, sort, uniq, tail, wc, and cut to read the provided data file and return the number of unique IP addresses that match the following criteria:

- IP address begins with 11

- Occurred before August 2018

- Occurred at an even numbered hour

- Has a size less than or equal to 100

The input file is:

date time protocol ip-address port packet-size

2018-01-01 19:27:19 TCP 11.101.6.64 22 44

2018-04-17 01:35:12 UDP 10.101.7.69 2135 83

2018-05-05 04:26:05 UDP 11.101.6.65 2160 104

2018-08-20 15:43:16 TCP 10.101.7.64 22 113

2018-02-10 02:28:02 UDP 11.101.6.65 2089 68

2018-03-22 00:05:32 TCP 9.101.7.65 23 92

2018-04-24 19:32:47 TCP 9.100.8.65 22 93

2018-05-19 01:22:06 TCP 10.100.7.64 2107 29

2018-04-13 03:51:33 TCP 9.102.8.64 22 32

2018-08-16 21:02:36 UDP 11.100.8.65 2190 17

2018-06-27 00:44:54 UDP 11.101.6.65 2109 73

2018-01-08 07:39:00 TCP 10.101.8.65 22 74

2018-01-22 07:08:54 UDP 9.101.7.65 2165 27

2018-01-11 07:17:44 TCP 11.101.6.65 22 110

2018-01-10 13:14:41 TCP 10.101.7.64 22 89

2018-08-23 13:47:24 UDP 11.100.6.65 2187 93

2018-08-17 06:29:35 TCP 11.101.6.65 2114 66

2018-11-23 02:22:22 UDP 9.100.7.64 2142 118

2018-09-22 22:06:47 TCP 11.101.6.65 22 9

2018-04-04 09:41:43 UDP 9.102.7.64 2116 34

And the expected output file is: 1

Thanks!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Task 01 (5 points) Write an piped command using cat, grep, and cut to read the provided data file, named lab0201.csv, and print the Name field from each line where the section is online Input file...

#Write a piped command using head , tail , sort , cut , and sed to return the date of the latest event in the file in yyyy/mm/dd format Input file: date time protocol ip-address port packet-size...

Task 0 3 ( 1 0 points ) Write a piped command using tail, cut, sort, uniq, and wc to read the provided data file and print the number of unique students ( Name ) . Task 0 4 ( 1 0 points ) Write a...

Task 04 (20 points) Write a piped command using grep and cut to read the provided data file, find the entries that use UDP protocol to transmit packets less than 100 bytes, and print the port number...

Write a piped command using grep, sort, uniq, tail, wc, and cut to read the provided data file and return the number of unique IP addresses that match the following criteria: IP address begins with...

#Write a piped command using grep , sort , uniq , tail , wc , and cut to read the provided data file and return the number of unique entries that match the following criteria: IP address begins with...

UNIX: The data file is comprised of a header, followed by lines containing firewall events. You can view the head of the file with the following command; cat firewall.log | head OUTPUT OF COMMAND:...

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

3. (10 points) Solve the initial value problem by Laplace transform y" + 4y + 13y = 2e-t sin 3t with y(0) = 1 and y' (0) = 0

How is a nations supply curve of its export commodity and demand for its import commodity derived from the nations production frontier and indifference map?

In partnership accounting each Partner s share of profit is posted to the: Question 2 Answer a . capital account b . current account current account c . drawings account drawings account

Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total...

Working with other project stakeholders for support.

Knowledge of project management (PMI) teachings

1. What is the relationship between information technology, project management, and Arups business model and business strategy?