and more in a single search tool across platforms. Read the announcement here. |
01/11/2024 08:38 PM
01/11/2024 08:46 PM
Select 'XXXXXXXXXXXXXXXXX' as entvaluekey,a.accountkey as acctKey,a.name as accName,A.userKey as userKey from account_entitlements1 ae join accounts a on a.accountkey=ae.accountkey join entitlement_values ev on ev.entitlement_valuekey=ae.entitlement_valuekey,(Select u.userkey,ae.accountkey ak,ae.entitlement_valuekey aek from users u join user_accounts ua on ua.userkey=u.userkey join accounts a on a.accountkey=ua.accountkey join account_entitlements1 ae on ae.accountkey=a.accountkey join entitlement_values ev on ev.entitlement_valuekey=ae.entitlement_valuekey and a.endpointkey=xxx and a.status in (1,'Active','Manually Provisioned') group by ae.accountkey having count(ae.accountkey)=1) A where ae.accountkey=A.ak and ae.entitlement_valuekey='xxxxx'
01/11/2024 09:00 PM
Changed the query as suggested, but still same issue.
No Add access task is created when the Action is manually changed to Provision Access
01/11/2024 09:49 PM
Is it ES analytics ?
01/11/2024 10:11 PM
Its not ES ,it is normal SQl query
01/11/2024 10:49 PM
does the user has account?
01/11/2024 10:52 PM
Yes user has an account , it is fetching user details in reports
01/11/2024 10:54 PM
Anything you see in logs?
I just validated in 23.11 and it does create a task
01/12/2024 03:16 AM
There is user data error, so it was not creating the task.
Now i have corrected it and it was working.
Thank you for support.
01/14/2024 07:12 PM
Try with correct user.
if it worked you can close thread