topic Re: Creating graphs on extracted values in a csv file in Getting Data In

Creating graphs on extracted values in a csv file

anirudhduggal — Sun, 11 Mar 2018 13:22:06 GMT

Hello All,

I have a csv file which has values like this

host, ports running
192.168.1.1, 80,8081,22
192.168.1.2, 80,21,8083
192.168.1.3, 22,23,8082

Now, I want to create graphs by extracting the unique values form each ports running field.

i.e. for this file the result should be
number of port 80 open - 2
number of port 22 open - 2
number of port 8081 open - 1
number of port 8082 open - 1
number of port 8083 open - 1

I have tried extracting fields however, I am not able to use these values as a unique value.

Anyone has faced a similar situation.
Thank you for reading this and thanks in advance 🙂

Re: Creating graphs on extracted values in a csv file

martin_mueller — Sun, 11 Mar 2018 15:41:29 GMT

This should do:

... | makemv ports_running delim="," | stats count by ports_running

The makemv turns your comma-delimited string into a multi-value field, with one value per port. The stats then does the counting per port.

Re: Creating graphs on extracted values in a csv file

anirudhduggal — Tue, 13 Mar 2018 02:27:32 GMT

Worked like a charm.
Just another thing. The last field that appears is a blank because the fields are ending with a comma (,) is there any way i can omit this field ?