# Latest **URL:** https://discuss.elastic.co/latest.md?page=1017 [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) **Page:** 1018 --- ## [How can i extract timestamp from my log in logstash](https://discuss.elastic.co/t/how-can-i-extract-timestamp-from-my-log-in-logstash/311484)
**Author:** [@Akumar22](https://discuss.elastic.co/u/Akumar22)\ **Replies:** 1\ **Last updated:** [August 5, 2022, 2:41pm UTC](https://discuss.elastic.co/t/how-can-i-extract-timestamp-from-my-log-in-logstash/311484 "2022-08-05T14:41:59Z")
Below is the format of my logs 05-08-2022 13:20:13,468 INFO \[stdout\] (151\_bYD2+EULzJ\_SLR\_124219\_-\_mymailfc@mailinator.com) Subject: Products Offer exceeded threshold limit of 10% I want to extract the timestamp from t… --- ## [Can I use conditionals inside json {} filter?](https://discuss.elastic.co/t/can-i-use-conditionals-inside-json-filter/311547)
**Author:** [@mfloris](https://discuss.elastic.co/u/mfloris)\ **Replies:** 1\ **Last updated:** [August 5, 2022, 2:40pm UTC](https://discuss.elastic.co/t/can-i-use-conditionals-inside-json-filter/311547 "2022-08-05T14:40:07Z")
My input does not always contain some fields and I want to parse it accordingly, like this: filter { json { source =\> "message" if "thisField" in \[message\] { add\_field =\> { "MyField" =\> "%{\[message\]\[this… --- ## [Error when installing @elastic/synthetics](https://discuss.elastic.co/t/error-when-installing-elastic-synthetics/311497)
**Author:** [@djkprojects](https://discuss.elastic.co/u/djkprojects)\ **Replies:** 1\ **Last updated:** [August 5, 2022, 2:18pm UTC](https://discuss.elastic.co/t/error-when-installing-elastic-synthetics/311497 "2022-08-05T14:18:38Z")
Hello, I'm trying to install npm install -g @elastic/synthetics on my local server but getting an error when running the command: loadCurrentTree ▀ ╢█████████████████████░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░… --- ## [Compare fields value](https://discuss.elastic.co/t/compare-fields-value/311387)
**Author:** [@alex\_vermex](https://discuss.elastic.co/u/alex_vermex)\ **Replies:** 2\ **Last updated:** [August 5, 2022, 2:12pm UTC](https://discuss.elastic.co/t/compare-fields-value/311387 "2022-08-05T14:12:53Z")
Hi, I would like if it is possible how to compare this value of two fields field1 : 123456XXXXXX1234 field2 : 1234567890001234 I mean i want to do if first 6 chars and last 4 chars of field1 are similar to field2 the… --- ## [Compare two fields with different documents](https://discuss.elastic.co/t/compare-two-fields-with-different-documents/311529)
**Author:** [@alex\_vermex](https://discuss.elastic.co/u/alex_vermex)\ **Replies:** 5\ **Last updated:** [August 5, 2022, 1:59pm UTC](https://discuss.elastic.co/t/compare-two-fields-with-different-documents/311529 "2022-08-05T13:59:45Z")
Hi, I want to compare two fields but not in the same document is that possible ? for example : if date.document1 == date.document2 and x.document1 == y.document2 { #DO somthing } Any help would be sincerely appre… --- ## [App Search - Scoring algorithm in B2B and multi-entity model](https://discuss.elastic.co/t/app-search-scoring-algorithm-in-b2b-and-multi-entity-model/311542)
**Author:** [@Gerardo\_Zenobi](https://discuss.elastic.co/u/Gerardo_Zenobi)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 1:32pm UTC](https://discuss.elastic.co/t/app-search-scoring-algorithm-in-b2b-and-multi-entity-model/311542 "2022-08-05T13:32:16Z")
Hi :wave: Context We have a B2B product. We would like to index different types of entities (e.g. User, Training, Group, etc). It was recommended that the best approach here would be to use one engine per entity. Probl… --- ## [Range filter in should match query](https://discuss.elastic.co/t/range-filter-in-should-match-query/311435)
**Author:** [@ansamHox](https://discuss.elastic.co/u/ansamHox)\ **Replies:** 3\ **Last updated:** [August 5, 2022, 1:41pm UTC](https://discuss.elastic.co/t/range-filter-in-should-match-query/311435 "2022-08-05T13:41:14Z")
Hi, let's say I have 3 documents, id=1, "text" = "my name is john", "date" = "2021" id=2, "text" = "my name is alice", "date" = "2017" id=3, "text" = "my name is steven", "date" = "2019" I want to find all documents th… --- ## [How to pass url query string value into the elasticsearch SQL query in kibana canvas](https://discuss.elastic.co/t/how-to-pass-url-query-string-value-into-the-elasticsearch-sql-query-in-kibana-canvas/311540)
**Author:** [@sarvshresht6561](https://discuss.elastic.co/u/sarvshresht6561)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 1:24pm UTC](https://discuss.elastic.co/t/how-to-pass-url-query-string-value-into-the-elasticsearch-sql-query-in-kibana-canvas/311540 "2022-08-05T13:24:06Z")
I am new to ELK stack. I am making line graphs in kibana canvas with elastic SQL query as a data source. I am trying to fetch the query string value from the url to the SQL query, but the result of the query is "no docum… --- ## [Elastic agent offline after upgrade](https://discuss.elastic.co/t/elastic-agent-offline-after-upgrade/311531)
**Author:** [@Leandre](https://discuss.elastic.co/u/Leandre)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 1:01pm UTC](https://discuss.elastic.co/t/elastic-agent-offline-after-upgrade/311531 "2022-08-05T13:01:38Z")
Same issue than this one when upgrading agent from 8.3.2 to 8.3.3. The service fails because the symlink to the executable elastic-agent.exe points on a deleted elastic-agent.exe (or the old .exe, wich causes an error li… --- ## [Geo\_distance agg results not consistent](https://discuss.elastic.co/t/geo-distance-agg-results-not-consistent/311453)
**Author:** [@drfreed](https://discuss.elastic.co/u/drfreed)\ **Replies:** 2\ **Last updated:** [August 5, 2022, 12:45pm UTC](https://discuss.elastic.co/t/geo-distance-agg-results-not-consistent/311453 "2022-08-05T12:45:31Z")
I was trying out the geo\_distance aggreation and received different results based on the order of the ranges specified. I was able to replicate this using the example in the geo\_distance aggregation documentation page. … --- ## [How to enroll elastic agent on image master to deploy 160 VDA Citrix Servers](https://discuss.elastic.co/t/how-to-enroll-elastic-agent-on-image-master-to-deploy-160-vda-citrix-servers/311526)
**Author:** [@dpachot](https://discuss.elastic.co/u/dpachot)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 12:35pm UTC](https://discuss.elastic.co/t/how-to-enroll-elastic-agent-on-image-master-to-deploy-160-vda-citrix-servers/311526 "2022-08-05T12:35:33Z")
Hi, i'am trying to enroll elastic-agent on Citrix's image master. When i deploy this image to my vda server, they are sharing the same id, so in the Fleet's menu, i can see only one VDA Server and the view is rotating o… --- ## [Is there a "stop" instruction in the block that skips to the next block?](https://discuss.elastic.co/t/is-there-a-stop-instruction-in-the-block-that-skips-to-the-next-block/311511)
**Author:** [@mfloris](https://discuss.elastic.co/u/mfloris)\ **Replies:** 1\ **Last updated:** [August 5, 2022, 12:31pm UTC](https://discuss.elastic.co/t/is-there-a-stop-instruction-in-the-block-that-skips-to-the-next-block/311511 "2022-08-05T12:31:59Z")
I want to split my filter block into separate files for better readability and easier maintenance and of course by doing that I cannot if-else through the various checks meaning that every input will go through all the f… --- ## [FS Crawler - Issue with OCR](https://discuss.elastic.co/t/fs-crawler-issue-with-ocr/311409)
**Author:** [@Julien70](https://discuss.elastic.co/u/Julien70)\ **Replies:** 6\ **Last updated:** [August 5, 2022, 12:12pm UTC](https://discuss.elastic.co/t/fs-crawler-issue-with-ocr/311409 "2022-08-05T12:12:11Z")
Hi everyone, I'm facing issue with FSCrawler and OCR: I have a small PDF datasets. Some are filled with "real" text and others with scanned text. When I activate the OCR module, I received this message: " \[I regret t… --- ## [How to optimize this agg search elasticsearch?](https://discuss.elastic.co/t/how-to-optimize-this-agg-search-elasticsearch/311521)
**Author:** [@robocon20x](https://discuss.elastic.co/u/robocon20x)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 11:59am UTC](https://discuss.elastic.co/t/how-to-optimize-this-agg-search-elasticsearch/311521 "2022-08-05T11:59:37Z")
i have query dsl Elasticsearch with field data 'arr\_color' is an string "red\_blu\_black" and an agg script like this { "runtime\_mappings": {}, "size": 0, "query": { "bool": { … --- ## [I want the full match text comes first than their prefixes than their substrings results](https://discuss.elastic.co/t/i-want-the-full-match-text-comes-first-than-their-prefixes-than-their-substrings-results/311512)
**Author:** [@Rakhshunda\_Noorein\_J](https://discuss.elastic.co/u/Rakhshunda_Noorein_J)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 11:27am UTC](https://discuss.elastic.co/t/i-want-the-full-match-text-comes-first-than-their-prefixes-than-their-substrings-results/311512 "2022-08-05T11:27:50Z")
Suppose If I am searching for Rohan Roy, I want Rohan Roy matching results comes first then rohan , rohan chohan etc.... The query I have used : { "size": 1000, "query": { "bool": { "must": \[ { … --- ## [Unique value counts in kibana](https://discuss.elastic.co/t/unique-value-counts-in-kibana/311510)
**Author:** [@Kara1990](https://discuss.elastic.co/u/Kara1990)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 11:23am UTC](https://discuss.elastic.co/t/unique-value-counts-in-kibana/311510 "2022-08-05T11:23:53Z")
Hello. I asked a question a while ago - see link Unique value counts in kibana After looking at your answer, my challenge is still that I cannot find the place where I can connect my visualization to an alert I have c… --- ## [Highlight not working when adjacent entities](https://discuss.elastic.co/t/highlight-not-working-when-adjacent-entities/311507)
**Author:** [@almeidajava](https://discuss.elastic.co/u/almeidajava)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 10:59am UTC](https://discuss.elastic.co/t/highlight-not-working-when-adjacent-entities/311507 "2022-08-05T10:59:36Z")
This happens when using mapper-annotated-text highlighter type: eg Query: { "query": { "ids": { "values": \[ "1" \] } }, "\_source": { "includes"… --- ## [Drupal ElasticSearch Connector](https://discuss.elastic.co/t/drupal-elasticsearch-connector/311505)
**Author:** [@betd-vramdoo](https://discuss.elastic.co/u/betd-vramdoo)\ **Replies:** 1\ **Last updated:** [August 5, 2022, 10:46am UTC](https://discuss.elastic.co/t/drupal-elasticsearch-connector/311505 "2022-08-05T10:46:15Z")
Hello there, I am currently working on a Drupal project with the search engine ElasticSearch 7.10, my team is using the Elasticsearch Connector | Drupal.org module to interface Drupal with ElasticSearch. Do you know if… --- ## [Elasticsearch Java api client get index mapping in a Map](https://discuss.elastic.co/t/elasticsearch-java-api-client-get-index-mapping-in-a-map/311461)
**Author:** [@ijaxahmed](https://discuss.elastic.co/u/ijaxahmed)\ **Replies:** 2\ **Last updated:** [August 5, 2022, 7:42am UTC](https://discuss.elastic.co/t/elasticsearch-java-api-client-get-index-mapping-in-a-map/311461 "2022-08-05T07:42:11Z")
I have two qestion 1- I want to get mapping of an Index in a map as "Map\", i successfully get the GetMappingResponse but from there not getting what to do in order to get mapping as a "Map\ **Author:** [@nicfr9](https://discuss.elastic.co/u/nicfr9)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 10:32am UTC](https://discuss.elastic.co/t/elasticsearch-pipeline-doesnt-catch-paths/311501 "2022-08-05T10:32:49Z") i'm trying to catch the paths that contains a specified path like path/to/my/url/VARIABLEPART, in the pipeline condition i put ctx.url.path == 'path/to/my/url/\*' but unfortunately it takes only the logs that have path/to… --- ## [How to perform join between two indexes in ES?](https://discuss.elastic.co/t/how-to-perform-join-between-two-indexes-in-es/311078)
**Author:** [@Ritikapawar](https://discuss.elastic.co/u/Ritikapawar)\ **Replies:** 4\ **Last updated:** [August 5, 2022, 10:20am UTC](https://discuss.elastic.co/t/how-to-perform-join-between-two-indexes-in-es/311078 "2022-08-05T10:20:26Z")
I have two indexes as Student1.csv and lecture.csv sample student1.csv student\_id name Roll no 1 Amey 1 2 Neha 2 3 Shubham 3 4 Satish 4 5 Ritika 5 sample lecture.csv lec\_no lec student\_id 1 eng 1 1 eng 1 1 eng 3 1 … --- ## [S3 Output malformed JSON](https://discuss.elastic.co/t/s3-output-malformed-json/311495)
**Author:** [@Giridharan\_C](https://discuss.elastic.co/u/Giridharan_C)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 9:07am UTC](https://discuss.elastic.co/t/s3-output-malformed-json/311495 "2022-08-05T09:07:36Z")
I am using some grok filter to parse the Syslog from TCP input and store them into S3. What I'm seeing is some malformed JSON. Some syslog events are good and some are not (Multiple events are grouping together as a sing… --- ## [Elastic Search matrix\_stats on both nested and non nested value](https://discuss.elastic.co/t/elastic-search-matrix-stats-on-both-nested-and-non-nested-value/311492)
**Author:** [@Mspprasath](https://discuss.elastic.co/u/Mspprasath)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 8:53am UTC](https://discuss.elastic.co/t/elastic-search-matrix-stats-on-both-nested-and-non-nested-value/311492 "2022-08-05T08:53:48Z")
we have a doc structure \[{ score: 10, list: \[ // nested type { id : 3, value: 10 }, { id: 4 value: 20 }, { id: 5, value: 15 } \] }, { score: 1, list:… --- ## [Use terminate\_after and sort query can't get the latest data](https://discuss.elastic.co/t/use-terminate-after-and-sort-query-cant-get-the-latest-data/311490)
**Author:** [@Xavier\_Stuart](https://discuss.elastic.co/u/Xavier_Stuart)\ **Replies:** 0\ **Last updated:** [August 5, 2022, 8:24am UTC](https://discuss.elastic.co/t/use-terminate-after-and-sort-query-cant-get-the-latest-data/311490 "2022-08-05T08:24:55Z")
Why can't I find the latest data when I add terminated\_after when sorting by creation time, the query statement is as follows GET index-1/\_search { "from": 0, "size": 20, "terminate\_after": 1111112, "query": { … --- ## [Transport and syncing data in ES](https://discuss.elastic.co/t/transport-and-syncing-data-in-es/311302)
**Author:** [@vnovotny98](https://discuss.elastic.co/u/vnovotny98)\ **Replies:** 4\ **Last updated:** [August 5, 2022, 7:27am UTC](https://discuss.elastic.co/t/transport-and-syncing-data-in-es/311302 "2022-08-05T07:27:20Z")
Hello, I have two elasticsearch clusters. One for acceptance where are 3 nodes (each has data, ingest, master role) and one for production where are 9 nodes (3 master, 3 ingest + hot nodes and 3 warm nodes). I would lik… --- ## [I want to make new ssl certificate and key for elasticsearch](https://discuss.elastic.co/t/i-want-to-make-new-ssl-certificate-and-key-for-elasticsearch/311469)
**Author:** [@hellocomputer](https://discuss.elastic.co/u/hellocomputer)\ **Replies:** 1\ **Last updated:** [August 5, 2022, 6:30am UTC](https://discuss.elastic.co/t/i-want-to-make-new-ssl-certificate-and-key-for-elasticsearch/311469 "2022-08-05T06:30:05Z")
Hello. I use ubuntu 20.04 version (server) and elasticsearch 8.3.2 version. Then, I want to make new certification and key for ssl secure elasticsearch. It already set ssl key using 'http.p12'. But i didn't set this. I… --- ## [How to fetch data from multiple hostnames in es](https://discuss.elastic.co/t/how-to-fetch-data-from-multiple-hostnames-in-es/311414)
**Author:** [@Gojo](https://discuss.elastic.co/u/Gojo)\ **Replies:** 2\ **Last updated:** [August 5, 2022, 6:16am UTC](https://discuss.elastic.co/t/how-to-fetch-data-from-multiple-hostnames-in-es/311414 "2022-08-05T06:16:41Z")
hey all iam new to elk , iam trying to get all the hosts in the Elasticsearch db , i tried using a wildcard and "wild\_card": "hosts", "query": { "host.keyword": "test\*", "severity.keyword": "err" }, consider there are … --- ## [How to get the sum in time of values in Lens](https://discuss.elastic.co/t/how-to-get-the-sum-in-time-of-values-in-lens/310735)
**Author:** [@its-ogawa](https://discuss.elastic.co/u/its-ogawa)\ **Replies:** 51\ **Last updated:** [August 5, 2022, 6:13am UTC](https://discuss.elastic.co/t/how-to-get-the-sum-in-time-of-values-in-lens/310735 "2022-08-05T06:13:32Z")
I collect logs in Elasticsearch and keep track of certain values in the logs with fields. Since the values are numeric, I would like to calculate the sum over a certain time interval and see the transition. However, wh… --- ## [SIEM alert based on CVE](https://discuss.elastic.co/t/siem-alert-based-on-cve/311251)
**Author:** [@n2x4](https://discuss.elastic.co/u/n2x4)\ **Replies:** 7\ **Last updated:** [August 5, 2022, 2:23am UTC](https://discuss.elastic.co/t/siem-alert-based-on-cve/311251 "2022-08-05T02:23:57Z")
I'm currently ingesting vulnerability data into elastic, including CVE ID. I would like to generate an alert whenever a vulnerabilty is ingested that shows up on a predefined list of "priority" CVEs. I'm not quite sure … --- ## [How to display data compared to yesterday?](https://discuss.elastic.co/t/how-to-display-data-compared-to-yesterday/311455)
**Author:** [@Kibanosi](https://discuss.elastic.co/u/Kibanosi)\ **Replies:** 1\ **Last updated:** [August 4, 2022, 11:38pm UTC](https://discuss.elastic.co/t/how-to-display-data-compared-to-yesterday/311455 "2022-08-04T23:38:52Z")
Hi, I'm looking for a dashboard view. Is there a way to display for example today's data and then show the data in percentage from yesterday like in this image? [Previous page](https://discuss.elastic.co/latest.md?page=1016) [Next page](https://discuss.elastic.co/latest.md?page=1018)