# Latest **URL:** https://discuss.elastic.co/latest.md?page=1067 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1068 --- ## [Aggregations by combining in/out datetimes to get inventory over time](https://discuss.elastic.co/t/aggregations-by-combining-in-out-datetimes-to-get-inventory-over-time/308484)
**Author:** [@mattvl](https://discuss.elastic.co/u/mattvl)\ **Replies:** 0\ **Last updated:** [June 29, 2022, 2:40pm UTC](https://discuss.elastic.co/t/aggregations-by-combining-in-out-datetimes-to-get-inventory-over-time/308484 "2022-06-29T14:40:33Z")
I have several inventory documents stored in elasticsearch, here is a simplified example (dates in database format YYYY-MM-DD): \[ {"item\_id": "a1", "in": "2020-12-01", "out": "2021-02-03"}, {"item\_id": "b2", "in… --- ## [Configured ELK Basic TLS Security](https://discuss.elastic.co/t/configured-elk-basic-tls-security/308387)
**Author:** [@ftayyab](https://discuss.elastic.co/u/ftayyab)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 2:34pm UTC](https://discuss.elastic.co/t/configured-elk-basic-tls-security/308387 "2022-06-29T14:34:06Z")
Hi, I have been able to follow the documentation and generate my own certificates and used them in Elasticsearch for Transport and HTTP security. Elasticsearch is up and running. I have also been able to establish conne… --- ## [ERR\_CONNECTION\_TIMED\_OUT in django template](https://discuss.elastic.co/t/err-connection-timed-out-in-django-template/307062)
**Author:** [@Vaibhav\_Lodha](https://discuss.elastic.co/u/Vaibhav_Lodha)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 2:27pm UTC](https://discuss.elastic.co/t/err-connection-timed-out-in-django-template/307062 "2022-06-29T14:27:59Z")
APM Agent language and version: python, 5.7 Browser version: 102 Original install method (e.g. download page, yum, deb, from source, etc.) and version: deb Steps to reproduce: I am trying to track API requests and pa… --- ## [How to use Atlassian Jira integration with Elastic Agent?](https://discuss.elastic.co/t/how-to-use-atlassian-jira-integration-with-elastic-agent/308478)
**Author:** [@SamuelSMendes](https://discuss.elastic.co/u/SamuelSMendes)\ **Replies:** 0\ **Last updated:** [June 29, 2022, 1:52pm UTC](https://discuss.elastic.co/t/how-to-use-atlassian-jira-integration-with-elastic-agent/308478 "2022-06-29T13:52:58Z")
I've been trying to setup the Atlassian Jira integration by Elastic Agent in the Elastic Cloud but so far haven't been able to. Is there a place I can see step by step how to setup it? Landed 3 pipeline assets but I sti… --- ## [How do I apply search analyzer to specific field in elasticsearch](https://discuss.elastic.co/t/how-do-i-apply-search-analyzer-to-specific-field-in-elasticsearch/308477)
**Author:** [@Ngabo\_Tresor](https://discuss.elastic.co/u/Ngabo_Tresor)\ **Replies:** 0\ **Last updated:** [June 29, 2022, 1:37pm UTC](https://discuss.elastic.co/t/how-do-i-apply-search-analyzer-to-specific-field-in-elasticsearch/308477 "2022-06-29T13:37:51Z")
Hello, I'm newbie to elasticsearch and would like to use the search analyzer on a certain field in the existing index. For instance, I want to convert the uppercase values in the retrieve field to lowercase letters. I wo… --- ## [JDBC Communication error with Logstash](https://discuss.elastic.co/t/jdbc-communication-error-with-logstash/308454)
**Author:** [@Simone1](https://discuss.elastic.co/u/Simone1)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 1:26pm UTC](https://discuss.elastic.co/t/jdbc-communication-error-with-logstash/308454 "2022-06-29T13:26:50Z")
I'm trying to collect data with Logstash from a remote MySQL db and i'm receving the following error: \[ERROR\] 2022-06-29 11:44:57.733 \[\[main\]\"… --- ## [High CPU load when using vector tile search API](https://discuss.elastic.co/t/high-cpu-load-when-using-vector-tile-search-api/308373)
**Author:** [@thibaultclem](https://discuss.elastic.co/u/thibaultclem)\ **Replies:** 5\ **Last updated:** [June 29, 2022, 1:18pm UTC](https://discuss.elastic.co/t/high-cpu-load-when-using-vector-tile-search-api/308373 "2022-06-29T13:18:45Z")
Hi everyone, We use Elasticsearch mainly for the vector tile search API and we are trying to figure out what could be the best way to configure it for better performance. We have a CPU optimized deployment on Elastic C… --- ## [Kibana install](https://discuss.elastic.co/t/kibana-install/308193)
**Author:** [@chandramouli\_ravi](https://discuss.elastic.co/u/chandramouli_ravi)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 1:18pm UTC](https://discuss.elastic.co/t/kibana-install/308193 "2022-06-29T13:18:14Z")
Hi, I have installed ElasticSearch 8.2.3 and its working ok and able to created index, document, able to search etc., Now, i want to install kibana-8.2.3 My os # Windows 10 When i run kibana.bat, i am getting this err… --- ## [Systemctl status kibana & systemctl status Elasticsearch is Running but kibana page is not loading](https://discuss.elastic.co/t/systemctl-status-kibana-systemctl-status-elasticsearch-is-running-but-kibana-page-is-not-loading/308467)
**Author:** [@bbkunbi](https://discuss.elastic.co/u/bbkunbi)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 1:15pm UTC](https://discuss.elastic.co/t/systemctl-status-kibana-systemctl-status-elasticsearch-is-running-but-kibana-page-is-not-loading/308467 "2022-06-29T13:15:14Z")
command result :==\> journalctl -fu kibana.service Jun 29 18:18:13 linux kibana\[54048\]: FATAL Error: Unable to complete saved object migrations for the \[.kibana\] index. Please check the health of your Elasticsearch clu… --- ## [Two questions about Kibana alarms](https://discuss.elastic.co/t/two-questions-about-kibana-alarms/306289)
**Author:** [@fgjensen](https://discuss.elastic.co/u/fgjensen)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 1:15pm UTC](https://discuss.elastic.co/t/two-questions-about-kibana-alarms/306289 "2022-06-29T13:15:11Z")
Hi Could you, please, help with two issues about Kibana alarms? The tags I can add to a rule when creating a rule from the Rules and Connectors page seem to be integrated with the tags I can create from the Kibana Ta… --- ## [Importing csv in Kibana with array of object](https://discuss.elastic.co/t/importing-csv-in-kibana-with-array-of-object/308469)
**Author:** [@KRISHNAPRASAD\_HG](https://discuss.elastic.co/u/KRISHNAPRASAD_HG)\ **Replies:** 0\ **Last updated:** [June 29, 2022, 12:56pm UTC](https://discuss.elastic.co/t/importing-csv-in-kibana-with-array-of-object/308469 "2022-06-29T12:56:31Z")
My CSV has this kind of data. When i import 'Colours you like' is imported as text. How i can make an array while importing the csv? Thanks in advance Name Colours you like Raj Black, Blue Ram Blue, White, Red Mohan Red… --- ## [Can't access to dashboard via Markdown link](https://discuss.elastic.co/t/cant-access-to-dashboard-via-markdown-link/307992)
**Author:** [@franckfct](https://discuss.elastic.co/u/franckfct)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 12:45pm UTC](https://discuss.elastic.co/t/cant-access-to-dashboard-via-markdown-link/307992 "2022-06-29T12:45:56Z")
Hi, I have several dashboards, i can access to them via the dashboard menu without any issues. I created a "landing" dashboard with Markdown text and links. When i try to access to them, i have the message : ## You do… --- ## [Add New field by Comparing Date](https://discuss.elastic.co/t/add-new-field-by-comparing-date/307895)
**Author:** [@RahulWagh](https://discuss.elastic.co/u/RahulWagh)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 12:06pm UTC](https://discuss.elastic.co/t/add-new-field-by-comparing-date/307895 "2022-06-29T12:06:27Z")
Hi, I am using Kibana v7.17 where I am trying to create new calculated field by comparing the date present in the existing field with hardcoded date. For e.g. if(doc\['trans\_date'\].value \>= "2021-02-15" {emit("FY 2021"} … --- ## [ElasticSearch REST API](https://discuss.elastic.co/t/elasticsearch-rest-api/308316)
**Author:** [@nijojob](https://discuss.elastic.co/u/nijojob)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 11:43am UTC](https://discuss.elastic.co/t/elasticsearch-rest-api/308316 "2022-06-29T11:43:41Z")
We are planning to send logs from Boomi to Elasticsearch directly using ELK REST APIs without using either Beats or Logstash. Document APIs | Elasticsearch Guide \[8.2\] | Elastic Is there any rate limiting for these API… --- ## [Convert Array to String by ingesting three double quotes](https://discuss.elastic.co/t/convert-array-to-string-by-ingesting-three-double-quotes/308358)
**Author:** [@Elie](https://discuss.elastic.co/u/Elie)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 10:40am UTC](https://discuss.elastic.co/t/convert-array-to-string-by-ingesting-three-double-quotes/308358 "2022-06-29T10:40:31Z")
Hi, I am wanting to change an Array to a String to make it easier for me to store in my Elasticsearch, but I am having trouble finding the way of doing so. There are some special cases in my data where my field "value" … --- ## [How to show data on cell when move pointer to this cell](https://discuss.elastic.co/t/how-to-show-data-on-cell-when-move-pointer-to-this-cell/308091)
**Author:** [@vuhai\_fo4](https://discuss.elastic.co/u/vuhai_fo4)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 10:21am UTC](https://discuss.elastic.co/t/how-to-show-data-on-cell-when-move-pointer-to-this-cell/308091 "2022-06-29T10:21:04Z")
Hi all, I have an issue with cells on my dashboard. I can't resize column because data on them is so long. Now, I want to view data on cell by move pointer to this cell. It same hint or suggest click about data of this c… --- ## [Kibana maps - add DSL Filter](https://discuss.elastic.co/t/kibana-maps-add-dsl-filter/308267)
**Author:** [@Yair\_Gofen](https://discuss.elastic.co/u/Yair_Gofen)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 10:03am UTC](https://discuss.elastic.co/t/kibana-maps-add-dsl-filter/308267 "2022-06-29T10:03:41Z")
Hi, I want to add filter to a layer on my map to reduce number of returned documents. however, i can only add a filter in KQL format and not DSL format. my filter uses painless script, and i don't know how to do that … --- ## [Regarding Mutate Ruby filter](https://discuss.elastic.co/t/regarding-mutate-ruby-filter/308426)
**Author:** [@suresh\_u](https://discuss.elastic.co/u/suresh_u)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 9:49am UTC](https://discuss.elastic.co/t/regarding-mutate-ruby-filter/308426 "2022-06-29T09:49:43Z")
I have 1 sample transaction number 10004567-P658910-569876. I want to seperate above transaction number with index 0 as 1 seperate field and remaining as other field. Ex: 10004567-P658910-569876 Num\_field = 10004567 … --- ## [Is "properties of analysis\_config" in Preview transform API Doc right?](https://discuss.elastic.co/t/is-properties-of-analysis-config-in-preview-transform-api-doc-right/308432)
**Author:** [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 9:40am UTC](https://discuss.elastic.co/t/is-properties-of-analysis-config-in-preview-transform-api-doc-right/308432 "2022-06-29T09:40:32Z")
Hi, Team, Preview Transform API Though it is not so important property for preview , "Properties of analysis\_config" should be "Properties of time"? In Create Transform API, it says "Properties of time". --- ## [Convert iso 8601 timestamp to UNIX\_MS](https://discuss.elastic.co/t/convert-iso-8601-timestamp-to-unix-ms/306693)
**Author:** [@The-morpho](https://discuss.elastic.co/u/The-morpho)\ **Replies:** 15\ **Last updated:** [June 29, 2022, 9:38am UTC](https://discuss.elastic.co/t/convert-iso-8601-timestamp-to-unix-ms/306693 "2022-06-29T09:38:08Z")
Hello, I have json logs wich have a field timestamp in iso 8601 format I want to convert it to UNIX\_MS so I can calculate the response time between step 1 and 2, 1 and 3 for each mid. How this can be done ? This is an… --- ## [Rollover and Consolidation of Shards](https://discuss.elastic.co/t/rollover-and-consolidation-of-shards/307158)
**Author:** [@parthmaniar](https://discuss.elastic.co/u/parthmaniar)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 9:28am UTC](https://discuss.elastic.co/t/rollover-and-consolidation-of-shards/307158 "2022-06-29T09:28:31Z")
Hello, my cluster has 1150 primary shards with 2300 total shards. I wanted to: consolidate them into recommended size of 50 GB each (100 with replica). I have attempted to this via Kibana GUI (using force merge) but it… --- ## [ProducerConfig values not all set](https://discuss.elastic.co/t/producerconfig-values-not-all-set/308438)
**Author:** [@mikhatanu](https://discuss.elastic.co/u/mikhatanu)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 9:23am UTC](https://discuss.elastic.co/t/producerconfig-values-not-all-set/308438 "2022-06-29T09:23:11Z")
Hello, i've been using the kafka plugin and set some ssl settings in the plugin. The config checker (before starting logstash) detects my config values, but the producerConfig (in the log) is not set. my config: input … --- ## [Filter data in interval or based on a specific field](https://discuss.elastic.co/t/filter-data-in-interval-or-based-on-a-specific-field/308351)
**Author:** [@Alice\_Ionescu](https://discuss.elastic.co/u/Alice_Ionescu)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 9:02am UTC](https://discuss.elastic.co/t/filter-data-in-interval-or-based-on-a-specific-field/308351 "2022-06-29T09:02:35Z")
Hello, I would like to filter data based on an interval or based on a specific field. For example I have a filter for begin date, one for end date and one for a specific date Begin date filter looks like this I … --- ## [Default configuration Local installation of ES on windows 10](https://discuss.elastic.co/t/default-configuration-local-installation-of-es-on-windows-10/308356)
**Author:** [@ftayyab](https://discuss.elastic.co/u/ftayyab)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 8:59am UTC](https://discuss.elastic.co/t/default-configuration-local-installation-of-es-on-windows-10/308356 "2022-06-29T08:59:05Z")
Hello, I am able to run ES and Kibana on window 10 machine with default configuration. However if I shut down the ES process and try to start ES again after few days, I get the following: java.security.cert.Certificate… --- ## [Elastic Agent, System Integration, Processors](https://discuss.elastic.co/t/elastic-agent-system-integration-processors/308236)
**Author:** [@fran\_hernandez](https://discuss.elastic.co/u/fran_hernandez)\ **Replies:** 8\ **Last updated:** [June 29, 2022, 8:49am UTC](https://discuss.elastic.co/t/elastic-agent-system-integration-processors/308236 "2022-06-29T08:49:30Z")
Hello, I am trying to get the hostname of a given IP in a field (source.ip), I am doing this for an agent deployed within a system integration, I have defined some processors in the "processors" field some drop\_event. B… --- ## [High CPU Usage in Elastic](https://discuss.elastic.co/t/high-cpu-usage-in-elastic/308429)
**Author:** [@Muhammad\_Umair](https://discuss.elastic.co/u/Muhammad_Umair)\ **Replies:** 3\ **Last updated:** [June 29, 2022, 8:18am UTC](https://discuss.elastic.co/t/high-cpu-usage-in-elastic/308429 "2022-06-29T08:18:49Z")
High I have 2 nodes in Elasticsearch cluster. 1 master and 1 data node. The master node is also a data node I have 2 logstash instances running and one filebeat on separate machines. The load is not too much just a mod… --- ## [Elasticesearch upgrade from 7.17 version to 8.x version](https://discuss.elastic.co/t/elasticesearch-upgrade-from-7-17-version-to-8-x-version/308424)
**Author:** [@Priyanka\_chauhan](https://discuss.elastic.co/u/Priyanka_chauhan)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 7:35am UTC](https://discuss.elastic.co/t/elasticesearch-upgrade-from-7-17-version-to-8-x-version/308424 "2022-06-29T07:35:57Z")
How to upgrade 7.17 elsasticsearch to 8.x version --- ## [Optionnal triggers in functionbeat](https://discuss.elastic.co/t/optionnal-triggers-in-functionbeat/308425)
**Author:** [@Lucas\_Zientek](https://discuss.elastic.co/u/Lucas_Zientek)\ **Replies:** 0\ **Last updated:** [June 29, 2022, 7:14am UTC](https://discuss.elastic.co/t/optionnal-triggers-in-functionbeat/308425 "2022-06-29T07:14:29Z")
Hello everyone, I have an issue on my functionbeat configuration, I want to have no triggers declared in my functionbeat.yml file. I am deploying the functionbeat lambda on aws using cloudformation that I edited myself… --- ## [Can't enroll token in elasticseacrh v8 in another vm](https://discuss.elastic.co/t/cant-enroll-token-in-elasticseacrh-v8-in-another-vm/308423)
**Author:** [@pencari\_berkah](https://discuss.elastic.co/u/pencari_berkah)\ **Replies:** 0\ **Last updated:** [June 29, 2022, 6:56am UTC](https://discuss.elastic.co/t/cant-enroll-token-in-elasticseacrh-v8-in-another-vm/308423 "2022-06-29T06:56:18Z")
i can't enroll kibana token in elasticseacrh, i create OVA my elastic server and move to new vm, but i don't know why elastic cannot enroll a new token now, please help. this error 13:45:56.788 \[main\] WARN org.elasti… --- ## [Some questions about PutComponentTemplateRequest in Java API](https://discuss.elastic.co/t/some-questions-about-putcomponenttemplaterequest-in-java-api/308308)
**Author:** [@black\_t](https://discuss.elastic.co/u/black_t)\ **Replies:** 1\ **Last updated:** [June 29, 2022, 6:41am UTC](https://discuss.elastic.co/t/some-questions-about-putcomponenttemplaterequest-in-java-api/308308 "2022-06-29T06:41:12Z")
Hi,guys. When i use the Elasticsearch of version 7.17.2, i found something when i use the PutComponentTemplateRequest. i used 7.11.1 in my last project, so i refer the guide document and follow it to create : PutCom… [Previous page](https://discuss.elastic.co/latest.md?page=1066) [Next page](https://discuss.elastic.co/latest.md?page=1068)