On 07/27/2015 04:03 AM, Luca Deri wrote:
David
I think you should
1. export flows to Elastic search using -F
This what I did but used an ES addon
https://github.com/jprante/elasticsearch-csv
to extract the data from elastic search. I then loaded the .csv into PostgreSQL
because I had
more than 1 million records, and used sql queries to extract and summarize the
data which
I then graphed in excel.
2. Create a report on ES using Kibana
Luca
On 07/27/2015 09:00 AM, Yuri Francalacci wrote:
David you are right because -F in nprobe is the dump frequency, but the -D
option allows you to specify the export format for the data (-D t export flows
in text file).
However to achieve your goal, you still need a bit of post process, because you
have to parse each file and aggregate the data in the way you would like to
export (using the metrics you are interested in).
Yuri
###############################################
Yuri Francalacci - [email protected] <mailto:[email protected]> -
http://www.ntop.org
"Simplicity is the ultimate sophistication" - Leonardo da Vinci
###############################################
On 27 Jul 2015, at 03:09, David Kraut <[email protected]
<mailto:[email protected]>> wrote:
Looks like -F only affects frequency? > -F: It specifies the frequency at
which files are dumped on disk
Maybe I'm barking up the wrong tree... What I want to do is collect network
traffic from a spanned switch port for a period of one week and then create a
report from that data (preferably using MS Excel) showing host to host
communications including IP addresses, Ports and Protocols. Is ntop/nprobe (or
nbox) capable of performing this type of task or am I trying to open a can with
a hammer?
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*From:* Yuri Francalacci <[email protected] <mailto:[email protected]>>
*To:* [email protected] <mailto:[email protected]>; David Kraut <[email protected]
<mailto:[email protected]>>
*Sent:* Friday, July 24, 2015 4:07 AM
*Subject:* Re: [Ntop] Export Data to Excel or CSV?
Try using -F parameter in nprobe. This option allows to dump exported data also
in text files. Once you have a text file, you can easily create a cvs.
Yuri
###############################################
Yuri Francalacci - [email protected] <mailto:[email protected]> - http://www.ntop.org
<http://www.ntop.org/>
"Simplicity is the ultimate sophistication" - Leonardo da Vinci
###############################################
On 23 Jul 2015, at 21:12, David Kraut <[email protected]
<mailto:[email protected]>> wrote:
Is it possible to export ntop/nprobe data to Excel or csv format for reporting?
_______________________________________________
Ntop mailing list
[email protected] <mailto:[email protected]>
http://listgateway.unipi.it/mailman/listinfo/ntop
_______________________________________________
Ntop mailing list
[email protected]
http://listgateway.unipi.it/mailman/listinfo/ntop
_______________________________________________
Ntop mailing list
[email protected]
http://listgateway.unipi.it/mailman/listinfo/ntop
--
Stephen Clark
*NetWolves Managed Services, LLC.*
Director of Technology
Phone: 813-579-3200
Fax: 813-882-0209
Email: [email protected]
http://www.netwolves.com
_______________________________________________
Ntop mailing list
[email protected]
http://listgateway.unipi.it/mailman/listinfo/ntop
