Search query to get list of vendors who is going to be expired within 30 days

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi Team,
I am trying to get the list of vendors whose “End Date” is within 30 days from now.The End Date identity attribute which is coming from source is in M/dd/yyyy format I converted it to “ISO8601” format by creating new identity attribute(endDateForReport) using transform and using below search query to get the list of vendors whose End Date is within 30 days.

attributes.employeeType:“Vendor” AND attributes.endDateForReport:[now TO now+30d]

there are identities who is going to be expired in 30 days but not returning using this search query. Please help me on this.

Thanks

2

Hi @sgonuguntla,

You will need to name the attribute, appending dateType to the end for the date search to work on custom attributes.

image
image1045×131 19.8 KB

Try with attribute name as endDateForReportdateType

3

Hi @sgonuguntla,

If you’d like to use the created:[now-30d TO now] query, you’ll need to convert the attribute to dateType. Otherwise, you can search it as a string using the format:

attributes.endDate:“2025-05-19T00:00:00Z”

4

@jesvin90.I added datetype to attribute it is working as expected. Thank you so much.

5

1.Check if you have enabled searchable=true.
2.Try to search with Technical name.
3.Try to run a identityRefresh for it to appear. Run a IdentityProfile Refresh.
4.Also there is a limit for attributes. Check this point.

Look at this thread who faced similar issue:

2 Likes
6

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