HI
by using elk preparing Dashboard for Jmeter Lt results.Jmeter writes result to file by using Flexible file writer . i configured That textfile /csv to Logstash but the problem is it had startTime and EndTime variables returning in epoch values so iam not able to convert those into human date and make difference b/w them. below is the sample of result file.
TargetApplication,StartTime,Transaction,AvgResponseTime,ResponseCode,SentBytes,Throughput,Latency,Status
MyAPP,1509004004580,Launch,4024,200,88,5810,3462,1
MyAPP,1509004011380,Launch,155,200,88,5810,134,1
and below is the logstash conf file:
input {
file {
path => ["D:/LoadTests/LT*.csv"]
start_position => "beginning"
}
}
filter {
grok {
match => ["message" ,"%{DATA:TargetApplication},%{INT:StartTime},%{DATA:Transaction},%{NUMBER:AvgResponseTime},%{DATA:ResponseCode},%{NUMBER:SentBytes},%{NUMBER:Throughput},%{NUMBER:Latency},%{WORD:Status}"]
}
date {
match => [ "StartTime","UNIX" ]
target => "StartTime"
}
if "1" in [Status] {
mutate {
replace => {"Status" => "Pass" }
}
}
if "0" in [Status] {
mutate {
replace => { "Status" => "Fail" }
}
}
mutate {
convert =>{
"AvgResponseTime" => "integer"
"SentBytes" => "integer"
"Throughput" => "integer"
"Latency" => "integer"
}
}
}
output {
file {
path => "D:\MW\OutPutLogs\OLTDC12.txt"
}
elasticsearch {
hosts => "localhost:9200"
index => "dappslt-%{+YYYY.MM.dd}"
template_name => "dappslt*"
template => "D:\logstash\templates\template_dappslt.json"
template_overwrite => true
manage_template => true
}
}
i used date filter to convert to humandate.
date {
match => [ "StartTime","UNIX" ]
target => "StartTime"
}
1509004004580 this is the startTime epoch value (Epoch time when the request was started)
there are no grok failures but this time not converting to human date if it works i had to make difference of start and end time if any one had worked with please help on thi thanks inadvance
using 5.6 ELK