Sailpoint IIQ 8.4 ver

[Aakansha_Sahu (Aakanksha Sahu)]

Which IIQ version are you inquiring about?

8.4

Please share any images or screenshots, if relevant.

[Please insert images here, otherwise delete this section]

Please share any other relevant files that may be required (for example, logs).

[Please insert files here, otherwise delete this section]

Share all details about your problem, including any error messages you may have received.

So i want to download the terminated user data from 2 years till now. what option i have to choose in advance analytic to get that data.
I was using equals for one day but i need data in bulk. I tried other option but it not giving me any result.

[ajmerasunny (Sunny Ajmera)]

you will have to use filters for that.

[pravin_ranjan (Kumar Ranjan)]

@Aakansha_Sahu when you say terminated user from 2 years till now, if you have sample xml then pls provide.

if it’s not searchable then you can use db query

Look in spt_identity table and in attributes column you might have terminated date that you can add query to return only 2 years records.

let me know if you have issue with query.

In Advance analytics filter you can only search by searchable attributes.