input {
file {
path => ["/home/stats/archive/*.csv"]
start_position => "beginning"
max_open_files => 40000
# sincedb_path => "/tmp/.productsSince15.db"
}
}
filter {
csv {
separator => ","
skip_header => true
columns => ["mitigation_id","time","total_in_packets","total_out_packets","total_dropped_packets","total_in_bytes","total_out_bytes","total_dropped_bytes","invalid_pkts_in_packets","invalid_pkts_out_packets","invalid_pkts_dropped_packets","invalid_pkts_in_bytes","invalid_pkts_out_bytes","invalid_pkts_dropped_bytes","acl_in_packets","acl_out_packets","acl_dropped_packets","acl_in_bytes","acl_out_bytes","acl_dropped_bytes","zombie_detection_in_packets","zombie_detection_out_packets","zombie_detection_dropped_packets","zombie_detection_in_bytes","zombie_detection_out_bytes","zombie_detection_dropped_bytes","geo_ip_in_packets","geo_ip_out_packets","geo_ip_dropped_packets","geo_ip_in_bytes","geo_ip_out_bytes","geo_ip_dropped_bytes","tcpsyn_in_packets","tcpsyn_out_packets","tcpsyn_dropped_packets","tcpsyn_in_bytes","tcpsyn_out_bytes","tcpsyn_dropped_bytes","payload_in_packets","payload_out_packets","payload_dropped_packets","payload_in_bytes","payload_out_bytes","payload_dropped_bytes", "http_mlfd_in_packets","http_mlfd_out_packets","http_mlfd_dropped_packets","http_mlfd_in_bytes","http_mlfd_out_bytes","http_mlfd_dropped_bytes","dns_mlfd_in_packets","dns_mlfd_out_packets","dns_mlfd_dropped_packets","dns_mlfd_in_bytes","dns_mlfd_out_bytes","dns_mlfd_dropped_bytes","traffic_management_in_packets","traffic_management_out_packets","traffic_management_dropped_packets","traffic_management_in_bytes","traffic_management_out_bytes","traffic_management_dropped_bytes"]
}
date {
match => [ "time", "YYYY-MM-dd HH:mm:ss" ]
target => "timestamp"
}
mutate {
remove_field => [ "message" ]
}
mutate {
convert => {
"mitigation_id" => "integer_eu"
"total_in_packets" => "integer_eu"
"total_out_packets" => "integer_eu"
"total_dropped_packets" => "integer_eu"
"total_in_bytes" => "integer_eu"
"total_out_bytes" => "integer_eu"
"total_dropped_bytes" => "integer_eu"
"invalid_pkts_in_packets" => "integer_eu"
"invalid_pkts_out_packets" => "integer_eu"
"invalid_pkts_dropped_packets" => "integer_eu"
"invalid_pkts_in_bytes" => "integer_eu"
"invalid_pkts_out_bytes" => "integer_eu"
"invalid_pkts_dropped_bytes" => "integer_eu"
"acl_in_packets" => "integer_eu"
"acl_out_packets" => "integer_eu"
"acl_dropped_packets" => "integer_eu"
"acl_in_bytes" => "integer_eu"
"acl_out_bytes" => "integer_eu"
"acl_dropped_bytes" => "integer_eu"
"zombie_detection_in_packets" => "integer_eu"
"zombie_detection_out_packets" => "integer_eu"
"zombie_detection_dropped_packets" => "integer_eu"
"zombie_detection_in_bytes" => "integer_eu"
"zombie_detection_out_bytes" => "integer_eu"
"zombie_detection_dropped_bytes" => "integer_eu"
"geo_ip_in_packets" => "integer_eu"
"geo_ip_out_packets" => "integer_eu"
"geo_ip_dropped_packets" => "integer_eu"
"geo_ip_in_bytes" => "integer_eu"
"geo_ip_out_bytes" => "integer_eu"
"geo_ip_dropped_bytes" => "integer_eu"
"tcpsyn_in_packets" => "integer_eu"
"tcpsyn_out_packets" => "integer_eu"
"tcpsyn_dropped_packets" => "integer_eu"
"tcpsyn_in_bytes" => "integer_eu"
"tcpsyn_out_bytes" => "integer_eu"
"tcpsyn_dropped_bytes" => "integer_eu"
"payload_in_packets" => "integer_eu"
"payload_out_packets" => "integer_eu"
"payload_dropped_packets" => "integer_eu"
"payload_in_bytes" => "integer_eu"
"payload_out_bytes" => "integer_eu"
"payload_dropped_bytes" => "integer_eu"
"http_mlfd_in_packets" => "integer_eu"
"http_mlfd_out_packets" => "integer_eu"
"http_mlfd_dropped_packets" => "integer_eu"
"http_mlfd_in_bytes" => "integer_eu"
"http_mlfd_out_bytes" => "integer_eu"
"http_mlfd_dropped_bytes" => "integer_eu"
"dns_mlfd_in_packets" => "integer_eu"
"dns_mlfd_out_packets" => "integer_eu"
"dns_mlfd_dropped_packets" => "integer_eu"
"dns_mlfd_in_bytes" => "integer_eu"
"dns_mlfd_out_bytes" => "integer_eu"
"dns_mlfd_dropped_bytes" => "integer_eu"
"traffic_management_in_packets" => "integer_eu"
"traffic_management_out_packets" => "integer_eu"
"traffic_management_dropped_packets" => "integer_eu"
"traffic_management_in_bytes" => "integer_eu"
"traffic_management_out_bytes" => "integer_eu"
"traffic_management_dropped_bytes" => "integer_eu"
}
}
}
output {
elasticsearch {
hosts => "http://localhost:9200"
index => "typestats-%{+YYYY-MM-dd_HH_mm}"
}
}