Query's output:
{
"took" : 99,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 10000,
"relation" : "gte"
},
"max_score" : null,
"hits" : [
{
"_index" : "metricbeat-7.2.1-2020.04.16-000001",
"_type" : "_doc",
"_id" : "6O0JqHEBhhYgzDqa8HzS",
"_score" : null,
"_source" : {
"@timestamp" : "2020-04-23T17:16:59.356Z",
"service" : {
"address" : "10.88.220.200:3306",
"type" : "mysql"
},
"error" : {
"message" : "Error 1045: Access denied for user 'root'@'test.kdb.com' (using password: YES)"
},
"agent" : {
"id" : "fff474f2-e90c-4841-b01b-ec792d7b66ad",
"version" : "7.2.1",
"type" : "metricbeat",
"ephemeral_id" : "9eee171a-734d-4db9-b0c1-49ceca993c7a",
"hostname" : "test.kdb.com"
},
...
BR,
Md. Saidur Rahman