Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/17/2024 09:05 AM - edited 04/17/2024 10:28 AM
Hi Team -
I have a requirement to set access enddate manually for entitlements assigned to accounts. We have implemented temporary access to the entitlements already, but to impose this on existing accounts, we need to set the enddate to expire their access after 3 months. This will be a one time process.
Please can someone advise how this can be achieved
Thank you
EDIT: I just realized that I may be able to use the enhanced query execution job to update the access end date for an account. Can someone please share a sample query for updating the enddate in the account_entitlements1 table? I am looking for a query to be used to update enddate for multiple accounts with single query
Solved! Go to Solution.
04/17/2024 05:42 PM
select accentkey as account_entitlements1__primarykey,
now() as account_entitlements1__enddate
from account_entitlements1 where accentkey = 78878
04/17/2024 10:06 PM
@rushikeshvartak , thank you. I have thousands of accounts with thousands of entitlements assigned and I need to force set a enddate for all those accounts. So, I am looking for a best way to include JOINs in this query to pull all those accounts.
Basically for endpoint A, I want to set the enddate for all high risk entitlements assigned to all the accounts of the endpoint. So that on that enddate, the high risk entitlements are removed from all the accounts in the endpoint
04/17/2024 10:09 PM
select accentkey as account_entitlements1__primarykey,
now() as account_entitlements1__enddate
from account_entitlements1 where entitlement_valuekey in (select entitlement_valuekey from entitlement_values where risk=4 and entitlementtypekey=1111)
05/09/2024 08:13 PM
Hi @rushikeshvartak ,
Is it possible to request update access enddate using file upload?
05/09/2024 08:26 PM
Use bulk upload access request yes
05/09/2024 08:28 PM
Can you give me an example for that ? I've try using this format but unfortunately the task for update access enddate is not generated
05/09/2024 08:35 PM
Please create new thread and share logs