Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry. Saviynt Copilot Icon
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Pull a report for when users are provisioned and deprovisioned to roles for an application

anirban23
New Contributor III
New Contributor III

‎08/23/2024 06:40 AM

Hi everyone,

Requirement is-

We need to pull report for when users are provisioned and deprovisioned to roles for an application between a date range like from 1st Jan to 31st July. Can anyone provide analytics query to achieve this ?

Thank you

Labels:
0 Kudos
2 REPLIES 2

rushikeshvartak
All-Star
All-Star

‎08/23/2024 07:31 AM

  • You can prepare query based on below tables
    • arstasks
    • entitlement_values
    • endpoints

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.
0 Kudos

Amit_Malik
Valued Contributor II
Valued Contributor II

‎08/24/2024 12:59 PM

HI @anirban23 ,

You can join following tables 

arstasks

role_entitlements

roles

entitlement_values

endpoints

Thanks,

Amit

If this answers your query, Please ACCEPT SOLUTION and give KUDOS.

 

Kind Regards,
Amit Malik
If this helped you move forward, please click on the "Kudos" button.
If this answers your query, please select "Accept As Solution".
0 Kudos
Copyright © 2024 Khoros, LLC