Bonjour,
j'ai créer un requéte avec elastic search ,ci dessous la requéte et le resultat:
GET /jmx*/_search?pretty&_source=
{
"size": 0,
"query":
{
"terms":
{
"metric_path.keyword" : ["xxx.OperatingSystem.AvailableProcessors","xxx.OperatingSystem.ProcessCpuTime","xxx.Runtime.Uptime"]
}
},
"aggs":
{
"Appli":
{
"terms":
{
"field": "application.keyword"
},
"aggs": {
"metrique path": {
"terms": {
"field": "metric_path.keyword"
},
"aggs": {
"somme": {
"sum": {
"field": "metric_value_number"
}
}
}
}
}
}
}
}
resultat :
{
"took": 0,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": 90450,
"max_score": 0,
"hits": []
},
"aggregations": {
"Appli": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "xxx",
"doc_count": 90450,
"metrique path": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "xxx.OperatingSystem.AvailableProcessors",
"doc_count": 30150,
"somme": {
"value": 482400
}
},
{
"key": "xxx.OperatingSystem.ProcessCpuTime",
"doc_count": 30150,
"somme": {
"value": 100546778848580080000
}
},
{
"key": "xxx.Runtime.Uptime",
"doc_count": 30150,
"somme": {
"value": 89192486850080
}
}
]
}
}
]
}
}
}
Mon besoin est de faire des calculs sur les trois valeur 'value' et je ne sais pas comment le faire ni comment les récupérés
Est ce que vous pouvez m'aidez
Merci d'avance
Partager