How to curl this query to shell script

Elastic Stack Kibana
1

I want to delete the 5 days old data of all my indexes. How to curl this query to shell script

POST _all/_delete_by_query
{
 "query": {
   "range": {
     "@timestamp": {
       "lte": "now-5d"
      }
    }
  }
}

Thanks in advance!

2

Hi
Have a look into Kibana's Console

Bildschirmfoto 2022-03-10 um 08.45.20
Bildschirmfoto 2022-03-10 um 08.45.201034×227 25.2 KB

curl -XPOST "{Elasticsearch}/_all/_delete_by_query" -H 'Content-Type: application/json' -d'
{
 "query": {
   "range": {
     "@timestamp": {
       "lte": "now-5d"
      }
    }
  }
}'

Best,
Matthias

1 Like
4

You're welcome!

5

Hope these aren't your real credentials :slight_smile:

6

Good day, the updated solution that works for me.

curl -XPOST "YourLocalhost:9200/YourIndexName/_delete_by_query" -H 'Content-Type: application/json' -d' { "query": { "range": { "@timestamp": { "lte": "now-5d" } } } }' -u YourElasticUsername:AndPassword

I added my Elastic Username and Password to the last of the command.
Thank you!

7

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.