# Is there a search query to get all the identities whose entitlement access is going to expire in certain date range?

**URL:** <https://developer.sailpoint.com/discuss/t/is-there-a-search-query-to-get-all-the-identities-whose-entitlement-access-is-going-to-expire-in-certain-date-range/89959>\
**Category:** SHF Discussion and Questions\
**Tags:** access, search, sailpoint-identity-security\
**Created:** [November 18, 2024, 6:27am UTC](https://developer.sailpoint.com/discuss/t/is-there-a-search-query-to-get-all-the-identities-whose-entitlement-access-is-going-to-expire-in-certain-date-range/89959 "2024-11-18T06:27:07Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![zachm117](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/zachm117/32/3883_2.png) [@zachm117](https://developer.sailpoint.com/discuss/u/zachm117)\
**Post date:** [November 18, 2024, 4:03pm UTC](https://developer.sailpoint.com/discuss/t/is-there-a-search-query-to-get-all-the-identities-whose-entitlement-access-is-going-to-expire-in-certain-date-range/89959/6 "2024-11-18T16:03:22Z")

</div>

I have 2 other options that might help with your current situation, but they are not exactly what you seem to be looking for.

A search like this can let you search for removeDates that are in a specified year/month. This might give you some info you need to look for removeDates that are coming up in the next month.

```auto
{
	"indices": [
		"events"
	],
	"query": {

		"query": "attributes.removeDate:\"2024-11*\""
	}
}

```

Additionally, you can search my identity id to find the removeDates for the items they requested to see if any are upcoming. This solution was described here: [How to view expiration date of an entitlement for a particular Identity? - #3 by kdfreeman](https://developer.sailpoint.com/discuss/t/how-to-view-expiration-date-of-an-entitlement-for-a-particular-identity/83767/3)

Hope one of these solutions helps you!

- Zach

---

_[View the full topic](https://developer.sailpoint.com/discuss/t/is-there-a-search-query-to-get-all-the-identities-whose-entitlement-access-is-going-to-expire-in-certain-date-range/89959)._
