"qs" is just prefix, there are random strings trailing (qs: abc, qs:_demo, qs: 123 and more). That's why i don't know how to remove with regex. I gave it some tries with other plugin but no luck.
Ive never tried this on nested objects, but when I ingest log files I filter out noise(pings, etc) by using
if [message] =~ "blah" {
grok {
match => { "message" => "%{BASE10NUM:Stored_Procedure_Exec_Time_Ms}" }
}
}
I used the grok filter here, but you should look into the drop filter. Just as a reminder, when you deal with nested objects in logstash, you should use [field][nestedField] as the format.
There is no regex for nested object as i checked. That's why i had to use ruby filter. But unfortunately i don't know ruby so it is my issue now. I cannot remove nested field with ruby code.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.