Auto update Ev query into imported aws entitlements

[Manju_SL]

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

[rushikeshvartak]

• Use enhanced Query / custom query

[Manju_SL]

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

[rushikeshvartak]

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

[Manju_SL]

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

[rushikeshvartak · Accepted solution]

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