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

Auto update Ev query into imported aws entitlements

Manju_SL
New Contributor III
New Contributor III

Hi Team, 

We have "EVQuery": "ev.customproperty40='pam-aws'" in the AWS connector PAM Config. Once we run the import access job, we have all the AWS entitlements imported. 

For EC2 instances or RDS instances that is to be bootstrapped, we manually update the entitlement customproperty40 with pam-aws.  

Looking for option to automatically update entitlement customproperty40 with pam-aws value during the AWS entitlements import (Access job). 

Automation will reduce the operations team overhead. Also avoids possible miss out of manually updating customproperty40, which results in instances not bootstrapped as per business need. 

Thanks, 

Manju

5 REPLIES 5

rushikeshvartak
All-Star
All-Star
  • Use enhanced Query / custom query

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

Hi Rushikesh, 

Running enhanced query/custom query will be additional manual activity. 

If there is any option to update the entitlement value automatically during entitlement import will fix issue. 

Thanks, 

Manjunatha V

You can schedule the Job or create triggerchain to run after import. 

 


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

Hi Rushikesh, 

Thanks for your inputs. Below query is showing error in enhanced query job, is it because tablename has _ in it.

select 'pam-aws' as entitlement_values__CUSTOMPROPERTY40, ev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY__PRIMARYKEY FROM entitlement_values ev WHERE ev.ENTITLEMENT_VALUEKEY='195963';

Regards, 

Manju

select 'pam-aws' as entitlement_values__CUSTOMPROPERTY40, ev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUES__PRIMARYKEY FROM entitlement_values ev WHERE ev.ENTITLEMENT_VALUEKEY='195963';


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