Hi,
i want to display my data in my data in status pannel by using Elasticsearch data soure in grafana,
Below is my sampe data : :
“hits” : [
{
“_index” : “mongo-collections2020-01-08”,
“_type” : “log”,
“_id” : “dVxmhG8BQaiuF_Y18chq”,
“_score” : 1.0,
“_source” : {
“runNumber” : 1,
“jobName” : “abcxyz”,
“jobStream” : “abcxyz”,
“serverName” : “AA01”,
“status” : “Waiting”,
“startTime” : “2020-01-01T00:00:00+08:00”,
“endTime” : “2020-01-01T00:00:00+08:00”,
“scheduleTime” : “2020-08-02T08:01:00+08:00”,
“jobDuration” : 0.0,
“scheduleToStartDuration” : 0.0,
“expected_jobDuration” : 0.0,
“expected_scheduleToStartDuration” : 0.0
}
},
{
“_index” : “mongo-collections2020-01-08”,
“_type” : “log”,
“_id” : “dlxmhG8BQaiuF_Y18chq”,
“_score” : 1.0,
“_source” : {
“runNumber” : 1,
“jobName” : “abcxy”,
“jobStream” : “abcxyz”,
“serverName” : “A012A”,
“status” : “Waiting”,
“startTime” : “2020-01-01T00:00:00+08:00”,
“endTime” : “2020-01-01T00:00:00+08:00”,
“scheduleTime” : “2020-08-02T08:01:00+08:00”,
“jobDuration” : 0.0,
“scheduleToStartDuration” : 0.0,
“expected_jobDuration” : 0.0,
“expected_scheduleToStartDuration” : 0.0
}
}
I want to display job Name and status in the status panel, Cna you please help me how to write query.
