Hi,
I am trying to see the monitoring data in kibana for the indices I have in elasticsearch.
No data is showing even after adding the relevant settings in elasticsearch.yml and kibana.yml.
Please help .
I will post my settings file for both.
Hi @Tanya_Shah,
- what is the version of the stack you use?
- what license (open source, basic etc.)?
- what do you have in elasticsearch.yml and kibana.yml?
- what do you see when you query
http://elasticsearch-url:9200/_cat/indices
? - where exactly you're
trying to see the monitoring data in kibana
?
Hi,
- I am using 7.0.0 for both ES and kibana.Earlier I was using 6.7.0 also for both didn't work there as well.
- Basic license
- i am trying to visualise monitoring data on my local only(will put the setting of kibana.yml and elasticsearch.yml at the end)
- output of _cat/indices
5.in the monitoring tab of kibana ,i want to see the data for the indices i have in my elasticsearch running on localhost:9200
Properties i added in elasticsearch.yml for monitoring
{
xpack.monitoring.enabled:true
xpack.monitoring.collection.enabled:true
xpack.monitoring.elasticsearch.collection.enabled:true
xpack.monitoring.exporters.my_local:
type:local
}
in kibana.yml
{
xpack.monitoring.ui.enabled:true
xpack.monitoring.enabled:true
xpack.monitoring.elasticsearch.url:"http://localhost:9200"
}
Can I have the complete concrete steps to suit my use case i.e to view the monitoring data of elasticsearch indices in kibana.?
Hmm, everything seems to be correct and works for me in 7.0.0 using these:
xpack.monitoring.enabled: true
xpack.monitoring.collection.enabled: true
xpack.monitoring.elasticsearch.collection.enabled: true
xpack.monitoring.exporters.my_local.type: local
xpack.monitoring.ui.enabled: true
xpack.monitoring.enabled: true
xpack.monitoring.elasticsearch.hosts: http://localhost:9200
But I'm surprised that Kibana starts for you with this setting xpack.monitoring.elasticsearch.url
. I completely removed it from 7.0.0 and Kibana should fail to start with this setting and require xpack.monitoring.elasticsearch.hosts
instead.
Are you sure you're running Kibana 7.0.0 and that your config is really applied?
Yes absolutely
I tried removing and adding this multiple times.No changes in kibana monitoring tab at all.
It alwayd ends up showing the same message "can't activate monitoring"
In one of my trials i added elasticsearch.hosts also even then it didn't work.
And for that matter,I switched to 7.0.0 when it didn't work for me in 6.7.0
Okay, let's look into logs then. Do you see anything suspicious in Elasticsearch logs? Also please run Kibana with logging.verbose: true
and share Kibana logs here if possible (black-outing any sensitive info you may have there).
But as I said above if Kibana 7.0.0 doesn't crash on startup with xpack.monitoring.elasticsearch.url
then most likely config isn't being applied for some reason.
OK,i will just paste the logs of kibana here and no elasticsearch seems perfectly fine.It is creating the monitoring index as well,as you can see in the output of _cat/indices.
i am attching here a file for kibana logs and also the screenshot for kibana monitoring tab.
Can i attach a text file here for logs?
Logs: kibana
{
C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\bin>kibana.bat --verbose
log [09:38:32.440] [debug][config] Marking config path as handled: server
log [09:38:32.441] [debug][http] registering route handler for [/core]
log [09:38:32.441] [debug][root] starting root
log [09:38:32.445] [debug][config] Marking config path as handled: logging
log [09:38:32.735] [debug][server] starting server
log [09:38:32.745] [debug][server][http] starting http server
log [09:38:32.788] [debug][server][http] http server running at http://localhost:5601
log [09:38:32.790] [debug][plugins-service] Starting plugins service
log [09:38:32.797] [debug][config] Marking config path as handled: plugins
log [09:38:32.800] [debug][plugins-discovery] Discovering plugins...
log [09:38:32.803] [debug][plugins-discovery] Scanning "C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\bin\src\plugins" for plugin sub-directories...
log [09:38:32.811] [debug][plugins-discovery] Scanning "C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\bin\plugins" for plugin sub-directories...
log [09:38:32.813] [debug][plugins-discovery] Scanning "C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\kibana-extra" for plugin sub-directories...
log [09:38:32.823] [debug][plugins-service] Discovered 0 plugins.
log [09:38:32.825] [debug][legacy-service] starting legacy service
log [09:38:34.937] [debug][config] Marking config path as handled: server
log [09:38:45.863] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\node_modules\x-pack
log [09:38:45.889] [debug][legacy-proxy] "getConnections" has been called.
log [09:38:45.905] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\apm_oss
log [09:38:45.933] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\console
log [09:38:45.942] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\input_control_vis
log [09:38:45.978] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\elasticsearch
log [09:38:45.985] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\inspector_views
log [09:38:46.028] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\interpreter
log [09:38:46.033] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\kbn_vislib_vis_types
log [09:38:46.040] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\kbn_doc_views
log [09:38:46.043] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\markdown_vis
log [09:38:46.259] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\kibana
log [09:38:46.440] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\metrics
log [09:38:46.446] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\region_map
log [09:38:46.453] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\metric_vis
log [09:38:46.457] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\status_page
log [09:38:46.466] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\table_vis
log [09:38:46.476] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\state_session_storage_redirect
log [09:38:46.479] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\tagcloud
log [09:38:46.559] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\tile_map
log [09:38:46.565] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\timelion
log [09:38:46.576] [debug][plugin] Found plugin at C:\Users\tanyashah\Desktop\kibana-7.0.0-windows-x86_64\src\legacy\core_plugins\vega
log [09:38:47.126] [debug][optimize] All bundles are cached and ready to go!
log [09:38:47.132] [debug][plugins] Initializing plugin kibana@kibana
log [09:38:47.381] [info][status][plugin:kibana@undefined] Status changed from uninitialized to green - Ready
log [09:38:47.384] [debug][plugins] Initializing plugin elasticsearch@kibana
log [09:38:47.419] [info][status][plugin:elasticsearch@undefined] Status changed from uninitialized to yellow - Waiting for Elasticsearch
log [09:38:47.423] [debug][plugins] Initializing plugin xpack_main@7.0.0
log [09:38:47.424] [info][status][plugin:xpack_main@7.0.0] Status changed from uninitialized to yellow - Waiting for Elasticsearch
log [09:38:47.436] [debug][plugins] Initializing plugin graph@7.0.0
log [09:38:47.438] [info][status][plugin:graph@7.0.0] Status changed from uninitialized to yellow - Waiting for Elasticsearch
log [09:38:47.447] [debug][plugins] Initializing plugin monitoring@7.0.0
log [09:38:47.461] [debug][stats-collection] Initializing kibana_stats collector
log [09:38:47.465] [info][status][plugin:monitoring@7.0.0] Status changed from uninitialized to green - Ready
log [09:38:47.478] [debug][plugins] Initializing plugin spaces@7.0.0
log [09:38:47.492] [info][status][plugin:spaces@7.0.0] Status changed from uninitialized to yellow - Waiting for Elasticsearch
log [09:38:47.498] [debug][plugins] Initializing plugin security@7.0.0
log [09:38:47.510] [warning][security] Generating a random key for xpack.security.encryptionKey. To prevent sessions from being invalidated on restart, please set xpack.security.encryptionKey in kibana.yml
log [09:38:47.515] [warning][security] Session cookies will be transmitted over insecure connections. This is not recommended.
log [09:38:47.525] [info][status][plugin:security@7.0.0] Status changed from uninitialized to yellow - Waiting for Elasticsearch
log [09:38:47.541] [debug][plugins] Initializing plugin searchprofiler@7.0.0
log [09:38:47.543] [info][status][plugin:searchprofiler@7.0.0] Status changed from
}
Please, execute these queries in Kibana Dev Tools and paste results here:
GET .monitoring-es-7-*/_mapping
And
POST .monitoring-es-*/_search
{
"query": {
"bool": {
"filter": {
"term": {
"type": "cluster_stats"
}
}
}
},
"collapse": {
"field": "cluster_uuid"
},
"sort": [
{
"timestamp": {
"order": "desc"
}
}
]
}
Also log just includes Kibana bootstrap stage, we need to see what Kibana logs when you access Monitoring views, so in the response for the latter query you should get cluster_uuid
that you'll need to insert here http://kibana-url:5601/app/monitoring#/elasticsearch?_g=(cluster_uuid:....value_of_the_cluster_uuid...)
and copy the corresponding log entries once you open this URL in browser.
Sure thing,sending the response for the query
For GET .monitoring-es-7-*/_mapping,the output is:
{
".monitoring-es-7-2019.05.15" : {
"mappings" : {
"dynamic" : "false",
"enabled" : false,
"date_detection" : false,
"properties" : {
"ccr_auto_follow_stats" : {
"properties" : {
"auto_followed_clusters" : {
"type" : "nested",
"properties" : {
"cluster_name" : {
"type" : "keyword"
},
"last_seen_metadata_version" : {
"type" : "long"
},
"time_since_last_check_millis" : {
"type" : "long"
}
}
},
"number_of_failed_follow_indices" : {
"type" : "long"
},
"number_of_failed_remote_cluster_state_requests" : {
"type" : "long"
},
"number_of_successful_follow_indices" : {
"type" : "long"
},
"recent_auto_follow_errors" : {
"type" : "nested",
"properties" : {
"auto_follow_exception" : {
"properties" : {
"reason" : {
"type" : "text"
},
"type" : {
"type" : "keyword"
}
}
},
"leader_index" : {
"type" : "keyword"
},
"timestamp" : {
"type" : "long"
}
}
}
}
},
"ccr_stats" : {
"properties" : {
"bytes_read" : {
"type" : "long"
},
"failed_read_requests" : {
"type" : "long"
},
"failed_write_requests" : {
"type" : "long"
},
"fatal_exception" : {
"properties" : {
"reason" : {
"type" : "text"
},
"type" : {
"type" : "keyword"
}
}
},
"follower_global_checkpoint" : {
"type" : "long"
},
"follower_index" : {
"type" : "keyword"
},
"follower_mapping_version" : {
"type" : "long"
},
"follower_max_seq_no" : {
"type" : "long"
},
"follower_settings_version" : {
"type" : "long"
},
"last_requested_seq_no" : {
"type" : "long"
},
"leader_global_checkpoint" : {
"type" : "long"
},
"leader_index" : {
"type" : "keyword"
},
"leader_max_seq_no" : {
"type" : "long"
},
"operations_read" : {
"type" : "long"
},
"operations_written" : {
"type" : "long"
},
"outstanding_read_requests" : {
"type" : "long"
},
"outstanding_write_requests" : {
"type" : "long"
},
"read_exceptions" : {
"type" : "nested",
"properties" : {
"exception" : {
"properties" : {
"reason" : {
"type" : "text"
},
"type" : {
"type" : "keyword"
}
}
},
"from_seq_no" : {
"type" : "long"
},
"retries" : {
"type" : "integer"
}
}
},
"remote_cluster" : {
"type" : "keyword"
},
"shard_id" : {
"type" : "integer"
},
"successful_read_requests" : {
"type" : "long"
},
"successful_write_requests" : {
"type" : "long"
},
"time_since_last_read_millis" : {
"type" : "long"
},
}
{
"total_read_remote_exec_time_millis" : {
"type" : "long"
},
"total_read_time_millis" : {
"type" : "long"
},
"total_write_time_millis" : {
"type" : "long"
},
"write_buffer_operation_count" : {
"type" : "long"
},
"write_buffer_size_in_bytes" : {
"type" : "long"
}
}
},
"cluster_state" : {
"properties" : {
"master_node" : {
"type" : "keyword"
},
"nodes" : {
"type" : "object"
},
"nodes_hash" : {
"type" : "integer"
},
"shards" : {
"type" : "object"
},
"state_uuid" : {
"type" : "keyword"
},
"status" : {
"type" : "keyword"
},
"version" : {
"type" : "long"
}
}
},
"cluster_stats" : {
"properties" : {
"indices" : {
"type" : "object"
},
"nodes" : {
"type" : "object"
}
}
},
"cluster_uuid" : {
"type" : "keyword"
},
"index_recovery" : {
"type" : "object"
},
"index_stats" : {
"properties" : {
"index" : {
"type" : "keyword"
},
"primaries" : {
"properties" : {
"docs" : {
"properties" : {
"count" : {
"type" : "long"
}
}
},
"fielddata" : {
"properties" : {
"evictions" : {
"type" : "long"
},
"memory_size_in_bytes" : {
"type" : "long"
}
}
},
"indexing" : {
"properties" : {
"index_time_in_millis" : {
"type" : "long"
},
"index_total" : {
"type" : "long"
},
"throttle_time_in_millis" : {
"type" : "long"
}
}
},
"merges" : {
"properties" : {
"total_size_in_bytes" : {
"type" : "long"
}
}
},
"query_cache" : {
"properties" : {
"evictions" : {
"type" : "long"
},
"hit_count" : {
"type" : "long"
},
"memory_size_in_bytes" : {
"type" : "long"
},
"miss_count" : {
"type" : "long"
}
}
},
"refresh" : {
"properties" : {
"total_time_in_millis" : {
"type" : "long"
}
}
},
"request_cache" : {
"properties" : {
"evictions" : {
"type" : "long"
},
"hit_count" : {
"type" : "long"
},
"memory_size_in_bytes" : {
"type" : "long"
},
"miss_count" : {
"type" : "long"
}
}
},
"search" : {
"properties" : {
"query_time_in_millis" : {
"type" : "long"
},
"query_total" : {
"type" : "long"
}
}
},
"segments" : {
"properties" : {
"count" : {
"type" : "integer"
},
"doc_values_memory_in_bytes" : {
"type" : "long"
},
"fixed_bit_set_memory_in_bytes" : {
"type" : "long"
},
"index_writer_memory_in_bytes" : {
"type" : "long"
}
the output is too long,Should i add more?
For second query output is:
{ "took" : 0, "timed_out" : false, "_shards" : { "total" : 5, "successful" : 5, "skipped" : 0, "failed" : 0 }, "hits" : { "total" : { "value" : 0, "relation" : "eq" }, "max_score" : null, "hits" : [ ] } }
Response when i entered the url after insering cluster_uuid
So it seems you don't have any cluster_stats
at all. @chrisronline any ideas what may be the issue here?
Can you run this query and return the results?
POST .monitoring-es-*/_search
{
"size": 1,
"aggs": {
"types": {
"terms": {
"field": "type"
}
}
}
}
{
"took" : 8,
"timed_out" : false,
"_shards" : {
"total" : 10,
"successful" : 10,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 10000,
"relation" : "gte"
},
"max_score" : 1.0,
"hits" : [
{
"_index" : ".monitoring-es-7-2019.05.15",
"_type" : "_doc",
"_id" : "lTJYumoB63opnwKeglhl",
"_score" : 1.0,
"_source" : {
"cluster_uuid" : "xmTTnou4Sze-l7bPqFKa7w",
"timestamp" : "2019-05-15T07:15:23.863Z",
"interval_ms" : 10000,
"type" : "cluster_stats",
"source_node" : {
"uuid" : "MlvqdteISaOyhqqEkw7ubw",
"host" : "127.0.0.1",
"transport_address" : "127.0.0.1:9300",
"ip" : "127.0.0.1",
"name" : "D98793M2",
"timestamp" : "2019-05-15T07:15:23.800Z"
},
"cluster_name" : "elasticsearch",
"version" : "7.0.1",
"license" : {
"status" : "active",
"uid" : "071f3569-7121-4746-87b8-a3a926a6d812",
"type" : "basic",
"issue_date" : "2019-01-21T11:29:12.209Z",
"issue_date_in_millis" : 1548070152209,
"max_nodes" : 1000,
"issued_to" : "elasticsearch",
"issuer" : "elasticsearch",
"start_date_in_millis" : -1
},
"cluster_stats" : {
"cluster_uuid" : "xmTTnou4Sze-l7bPqFKa7w",
"timestamp" : 1557904523841,
"status" : "green",
"indices" : {
"count" : 4,
"shards" : {
"total" : 12,
"primaries" : 12,
"replication" : 0.0,
"index" : {
"shards" : {
"min" : 1,
"max" : 5,
"avg" : 3.0
},
"primaries" : {
"min" : 1,
"max" : 5,
"avg" : 3.0
},
"replication" : {
"min" : 0.0,
"max" : 0.0,
"avg" : 0.0
}
}
},
"docs" : {
"count" : 42,
"deleted" : 30
},
"store" : {
"size_in_bytes" : 108432
},
"fielddata" : {
"memory_size_in_bytes" : 0,
"evictions" : 0
},
"query_cache" : {
"memory_size_in_bytes" : 0,
"total_count" : 0,
"hit_count" : 0,
"miss_count" : 0,
"cache_size" : 0,
"cache_count" : 0,
"evictions" : 0
},
"completion" : {
"size_in_bytes" : 0
},
"segments" : {
"count" : 28,
"memory_in_bytes" : 22192,
"terms_memory_in_bytes" : 8764,
"stored_fields_memory_in_bytes" : 8736,
"term_vectors_memory_in_bytes" : 0,
"norms_memory_in_bytes" : 0,
"points_memory_in_bytes" : 28,
"doc_values_memory_in_bytes" : 4664,
"index_writer_memory_in_bytes" : 397512,
"version_map_memory_in_bytes" : 129,
"fixed_bit_set_memory_in_bytes" : 1104,
"max_unsafe_auto_id_timestamp" : -1,
"file_sizes" : { }
}
},
"nodes" : {
"count" : {
"total" : 1,
"data" : 1,
"coordinating_only" : 0,
"master" : 1,
"ingest" : 1
},
"versions" : [
"7.0.1"
],
"os" : {
"available_processors" : 8,
"allocated_processors" : 8,
"names" : [
{
"name" : "Windows 10",
"count" : 1
}
],
"pretty_names" : [
{
"pretty_name" : "Windows 10",
"count" : 1
}
],
"mem" : {
"total_in_bytes" : 17055911936,
"free_in_bytes" : 6409302016,
"used_in_bytes" : 10646609920,
"free_percent" : 38,
"used_percent" : 62
}
},
"process" : {
"cpu" : {
"percent" : 1
},
"open_file_descriptors" : {
"min" : -1,
"max" : -1,
"avg" : 0
}
},
"jvm" : {
"max_uptime_in_millis" : 3452350,
"versions" : [
{
"version" : "1.8.0_161",
"vm_name" : "Java HotSpot(TM) 64-Bit Server VM",
"vm_version" : "25.161-b12",
"vm_vendor" : "Oracle Corporation",
"bundled_jdk" : false,
"using_bundled_jdk" : null,
"count" : 1
}
],
"mem" : {
"heap_used_in_bytes" : 646564248,
"heap_max_in_bytes" : 2077753344
},
"threads" : 100
},
"fs" : {
"total_in_bytes" : 506130092032,
"free_in_bytes" : 312158330880,
"available_in_bytes" : 312158330880
},
"plugins" : ,
"network_types" : {
"transport_types" : {
"netty4" : 1
},
"http_types" : {
"netty4" : 1
}
},
"discovery_types" : {
"zen" : 1
}
}
},
"cluster_state" : {
"nodes_hash" : 349199106,
"status" : "green",
"cluster_uuid" : "xmTTnou4Sze-l7bPqFKa7w",
"version" : 126,
"state_uuid" : "8jx1EtOaSZOzmQGnKO4M6A",
"master_node" : "MlvqdteISaOyhqqEkw7ubw",
"nodes" : {
"MlvqdteISaOyhqqEkw7ubw" : {
"name" : "D98793M2",
"ephemeral_id" : "CDlaP2WhTnS3I6vcIUjD8w",
"transport_address" : "127.0.0.1:9300",
"attributes" : {
"ml.machine_memory" : "17055911936",
"xpack.installed" : "true",
"ml.max_open_jobs" : "20"
}
}
}
},
"stack_stats" : {
"apm" : {
"found" : false
},
"xpack" : {
"security" : {
"available" : false,
"enabled" : false
},
"monitoring" : {
"available" : true,
"enabled" : true,
"collection_enabled" : true,
"enabled_exporters" : {
"local" : 1
}
},
"watcher" : {
"available" : false,
"enabled" : true,
"execution" : {
"actions" : {
"_all" : {
"total" : 0,
"total_time_in_ms" : 0
}
}
},
"watch" : {
"input" : {
"_all" : {
"total" : 0,
"active" : 0
}
},
"trigger" : {
"_all" : {
"total" : 0,
"active" : 0
}
}
},
"count" : {
"total" : 0,
"active" : 0
}
},
"ml" : {
"available" : false,
"enabled" : true,
"jobs" : {
"_all" : {
"count" : 0,
"detectors" : {
"total" : 0.0,
"min" : 0.0,
"avg" : 0.0,
"max" : 0.0
},
"model_size" : {
"total" : 0.0,
"min" : 0.0,
"avg" : 0.0,
"max" : 0.0
},
"forecasts" : {
"total" : 0,
"forecasted_jobs" : 0
}
}
},
"datafeeds" : {
"_all" : {
"count" : 0
}
},
"node_count" : 1
},
"ilm" : {
"policy_count" : 1,
"policy_stats" : [
{
"phases" : {
"delete" : {
"min_age" : 604800000,
"actions" : [
"delete"
]
}
},
"indices_managed" : 0
}
]
},
"logstash" : {
"available" : false,
"enabled" : true
},
"ccr" : {
"available" : false,
"enabled" : true,
"follower_indices_count" : 0,
"auto_follow_patterns_count" : 0
},
"graph" : {
"available" : false,
"enabled" : true
},
"sql" : {
"available" : true,
"enabled" : true,
"features" : {
"having" : 0,
"subselect" : 0,
"limit" : 0,
"orderby" : 0,
"where" : 0,
"join" : 0,
"groupby" : 0,
"command" : 0,
"local" : 0
},
"queries" : {
"cli" : {
"total" : 0,
"paging" : 0,
"failed" : 0
},
"rest" : {
"total" : 0,
"paging" : 0,
"failed" : 0
},
"canvas" : {
"total" : 0,
"paging" : 0,
"failed" : 0
},
"odbc" : {
"total" : 0,
"paging" : 0,
"failed" : 0
},
"jdbc" : {
"total" : 0,
"paging" : 0,
"failed" : 0
},
"odbc32" : {
"total" : 0,
"paging" : 0,
"failed" : 0
},
"odbc64" : {
"total" : 0,
"paging" : 0,
"failed" : 0
},
"_all" : {
"total" : 0,
"paging" : 0,
"failed" : 0
},
"translate" : {
"count" : 0
}
}
},
"rollup" : {
"available" : true,
"enabled" : true
}
}
}
}
}
]
},
"aggregations" : {
"types" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" :
}
}
}
output for your query @chrisronline
also are we restricted to do certain no of replies per day?
Can someone please help on this issue?
HI @Tanya_Shah,
I will do my best to help you out with this issue.
Let's tweak the query slightly. Run this and please return the result:
POST .monitoring-es-*/_search
{
"size": 0,
"aggs": {
"types": {
"terms": {
"field": "type"
}
}
}
}