Need query that gives report number of Identities over the last months(let say two months or a year)

We would like to pull how many identities are added over the last months/years in our tenant. Let us know any query to pull this.

Also in a similar way we want pull report how sources has been added over the last months/year in our tenant

You can use this:


From UI filter I believe you can choose “Identities” to get identity only

HI @HussainshaSyed001 ,
To get Identities created in last 1 year or 12 M you can use below query
created: [now-12M TO now] and in filters select for identities .
To get report their is option to download report for the same.

Thank you

1 Like

in a similar way, knowing sources created ?

In this case, I think you’ll need to use the API.
There’s an option to filter by the created field:
created : eq, ge, gt, in, le, lt, ne, isnull, sw
list-sources | SailPoint Developer Community

Hi @HussainshaSyed001,
created gt 2025-03-31T15:34:24.557Z
you can use this filter in source api ,also change the operators according to your requirements.

Thank you

1 Like