Elastic search document fields queries

Grafana Elasticsearch
1

I have an elastic search index like this. Now how can i template a variable that is based on the document source that is region_name?
this doesnt work

image.jpg1386×484 63.9 KB

where as this also doesnt work

image.jpg1562×718 102 KB

{
“_index” : “region_summary”,
“_type” : “CLDIN_ETZ_C_VM01_Summary”,
“_id” : “20170703110906851475_CLDIN_ETZ_C_VM01”,
“_score” : 1.0,
“_source” : {
“subnets_identity” : [
“subnet_1”
],
“start_time” : 30717105729,
“no_of_networks” : 1,
“hypervisor_identity” : [
“h_1”
],
“total_ips_configured” : 449,
“active_ips” : 302,
“region_name” : “CLDIN_ETZ_C_VM01”,
“subnet_1” : {
“name” : “ETZ_C_9.113.28”,
“ipcount” : 449
},
“disk_san_tb” : 138.9833984375,
“h_1” : {
“id” : 1,
“memory_mb” : 7843657,
“running_vms” : 372,
“disk_used_gb” : 73089,
“disk_discoverd_gb” : 142319,
“vcpus_used” : 1771,
“memory_used_mb” : 4686580,
“name” : “domain-c235469(GreenMountain02)”,
“vcpus” : 592
},
“vol_count” : 39,
“end_time” : 30717105854,
“vmcount” : 333,
“no_of_hypervisors” : 1,
“vmsandvols_count” : 372,
“timestamp” : “2017-07-03T10:58:54+05:30”,
“disk_san_free_tb” : 69.06359672546387
}
},

2

you are using a @ (at symbol) when you refer to the field region_name but in your document there is no such symbol. The at symbol has no meaning in ES, you should not use it unless you fields are named with that prefix

3

hello, do you how to change the value in term sand field by variables as {“find”:"$v1",“field”:"$v2",“query”:"$v3:$v4"} ? Many thanks