# How to auto delete data older than 2 month or 30 days from elastcisearch index? **URL:** \ **Category:** Elasticsearch\ **Created:** [October 17, 2023, 5:42am UTC](https://discuss.elastic.co/t/how-to-auto-delete-data-older-than-2-month-or-30-days-from-elastcisearch-index/345161 "2023-10-17T05:42:33Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![bbkunbi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bbkunbi/32/107767_2.png) [@bbkunbi](https://discuss.elastic.co/u/bbkunbi)\ **Post date:** [October 17, 2023, 5:42am UTC](https://discuss.elastic.co/t/how-to-auto-delete-data-older-than-2-month-or-30-days-from-elastcisearch-index/345161/1 "2023-10-17T05:42:33Z")
Note: I am not using date in index name like index -yyyy-mm . any method to do this i am using python Elasticsearch client to store data in es database. ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [October 17, 2023, 5:53am UTC](https://discuss.elastic.co/t/how-to-auto-delete-data-older-than-2-month-or-30-days-from-elastcisearch-index/345161/2 "2023-10-17T05:53:24Z")
The only bilt-in way to manage retention of data in Elasticsearch is ILM, and this relies on time-based indices (by name as you outlined or rollover) being used. If you have a single index you need to delete data using delete-by-query and you need to periodically schedule these operations yourself. ---
**Author:** ![bbkunbi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bbkunbi/32/107767_2.png) [@bbkunbi](https://discuss.elastic.co/u/bbkunbi)\ **Post date:** [October 17, 2023, 6:23am UTC](https://discuss.elastic.co/t/how-to-auto-delete-data-older-than-2-month-or-30-days-from-elastcisearch-index/345161/3 "2023-10-17T06:23:08Z")
in my Elasticsearch index one data is date/time and timestamp . So how to do query and delete data older than X days? ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [October 17, 2023, 6:26am UTC](https://discuss.elastic.co/t/how-to-auto-delete-data-older-than-2-month-or-30-days-from-elastcisearch-index/345161/4 "2023-10-17T06:26:44Z")
Use the [delete by query API](https://www.elastic.co/guide/en/elasticsearch/reference/8.10/docs-delete-by-query.html) with a [date range filter](https://www.elastic.co/guide/en/elasticsearch/reference/8.10/query-dsl-range-query.html). ---
**Author:** ![bbkunbi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bbkunbi/32/107767_2.png) [@bbkunbi](https://discuss.elastic.co/u/bbkunbi)\ **Post date:** [October 17, 2023, 6:28am UTC](https://discuss.elastic.co/t/how-to-auto-delete-data-older-than-2-month-or-30-days-from-elastcisearch-index/345161/5 "2023-10-17T06:28:45Z")
I want to automate this task using pyhton script. how to do it? ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [October 17, 2023, 7:40am UTC](https://discuss.elastic.co/t/how-to-auto-delete-data-older-than-2-month-or-30-days-from-elastcisearch-index/345161/6 "2023-10-17T07:40:02Z")
Look at the links I provided and write a Python script that periodically uses that API, e.g. by triggering it via cron. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 14, 2023, 7:41am UTC](https://discuss.elastic.co/t/how-to-auto-delete-data-older-than-2-month-or-30-days-from-elastcisearch-index/345161/7 "2023-11-14T07:41:01Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.