How to provision an AD entitlement to the newly created Service Account using Analytics

[Thriller]

Hello
I need to provision an AD entitlement to the newly created service account that meets the below criteria. How can I do it using the Analytics? Where do I specify the entitlement that I need to provision?

select e.endpointname, a.name, a.customproperty3 as 'Location', a.customproperty1 as 'Brand', 'Provision Access' AS Default_Action_For_Analytics from accounts a join endpoints e on e.endpointkey = a.endpointkey where e.endpointname = 'Hyperion' and a.customproperty3 in ('Mexico', 'Canada') and a.customproperty1 in ('NGS', 'BGS')

[rushikeshvartak · Accepted solution]

select e.endpointname, a.name as accName , a.customproperty3 as 'Location', a.customproperty1 as 'Brand', 'Provision Access' AS Default_Action_For_Analytics,a.accountkey as acctKey ,'1' as userKey ,'99999' as entvaluekey from accounts a join endpoints e on e.endpointkey = a.endpointkey where e.endpointname = 'Hyperion' and a.customproperty3 in ('Mexico', 'Canada') and a.customproperty1 in ('NGS', 'BGS')

[NM]

@Thriller entitlementid as entvaluekey

Analytics action- provision access

[Thriller]

Thank you @rushikeshvartak and @NM