Regarding search query in sailpoint isc . I need some search query for fetching some important tasks

Identity Security Cloud (ISC) ISC Discussion and Questions
1

hey guys,

i need a search query for new joiners, rehires, Leavers to make a report. Can someone kindly provide me search queriers for that? thanks.

2

Hello @Rakesh_Singh_1234

On what basis we can know the lcs of these identities . Is this LCS mapped to LCS attributes as “joiner” … and so ?

3

@sidharth_tarlapally i just need basic queries now like who joined yestyerday who left yesterday any idea on that ?

4

Hi Rakesh,

I suggest to go through this official documentation to build search queries.

Thanks.

5

It actually depends on the data and LCS Scenario . But still , if you want to get identities whose end date is between yesterday and today ,
attributes.endDate:[2025-04-15 TO 2025-04-16]
Identities whose startdate is between yesterday and today :
attributes.endDate:[2025-04-15 TO 2025-04-16]
if we want to check exact date : attributes.startDate:2025-04-16

Hope this helps

Sid

6

Below are the basic Search which returns daywise result when you run it everyday but you can build the query based on your LCS calculation by using the same attributes in Search.

Joiner:
attributes.startDate:[now-1d TO now] AND attributes.isRehire:“0”
Leaver:
attributes.endDate:[now-1d TO now]

Rehire:
attributes.startDate:[now-1d TO now] AND attributes.isRehire:“1”

isRehire is an sample identity attribute used to differentiate the rehire from new hire.