wajika
(wajika)
September 19, 2020, 8:58am
1
The index pattern was created without any timestamp.
filter {
date {
match => ["[CreationTime]","yyyy-MM-dd HH:mm:ss.SSS"]
timezone => "Asia/Shanghai"
target => "@timestamp"
}
}
mutate {
replace => [ "@timestamp", "%{CreationTime}" ]
}
The result is not right.
Badger
September 19, 2020, 8:33pm
2
Looks to me like there are two spaces. Try
"yyyy-MM-dd HH:mm:ss.SSS"
wajika
(wajika)
September 21, 2020, 5:13am
3
Even if I use "yyyy-MM-dd HH:mm:ss.SSS", it still fails.
@Badger
Badger
September 21, 2020, 2:02pm
4
Your [CreationTime] field does not have a sub-second part. The date filter pattern must exactly match the field. Try
"yyyy-MM-dd HH:mm:ss"
wajika
(wajika)
September 22, 2020, 2:14am
5
I have tested it before and it was not successful.
date {
match => ["[CreationTime]","yyyy-MM-dd HH:mm:ss","ISO8601"]
timezone => "Asia/Shanghai"
target => "@timestamp "
}
Is there any way to debug the date plugin?
kavierkoo
(Kavier)
September 22, 2020, 1:09pm
6
Try
date {
match => ["yyyy-MM-dd HH:mm:ss","yyyy-MM-dd HH:mm:ss","ISO8601"]
timezone => "Asia/Shanghai"
target => "@timestamp"
}
system
(system)
Closed
October 20, 2020, 1:09pm
7
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.