Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
07/21/2024 05:42 AM
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
Solved! Go to Solution.
07/21/2024 08:48 PM
07/21/2024 10:04 PM
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
07/22/2024 09:56 AM
You can schedule the Job or create triggerchain to run after import.
07/23/2024 12:44 AM
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
07/23/2024 03:53 AM
select 'pam-aws' as entitlement_values__CUSTOMPROPERTY40, ev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUES__PRIMARYKEY FROM entitlement_values ev WHERE ev.ENTITLEMENT_VALUEKEY='195963';