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 🙂
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.
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 ?
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.