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

[HussainshaSyed001 (Hussainssha Syed)]

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

[gourab (Gourab Sadhukhan)]

@HussainshaSyed001

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.

You can use this:

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

[pavya (pravin Dhamdhere)]

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

[HussainshaSyed001 (Hussainssha Syed)]

in a similar way, knowing sources created ?

[jlee555 (Jabes Lee)]

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

[pavya (pravin Dhamdhere)]

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