Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
09/15/2023 01:26 AM
Hi,
I am running an actionable analytics to disable account and send an email notification to user's manager.
Upon running the report I am constantly seeing the below message:
Alert: Control execution is taking longer than expected. You will be notified when the result is ready
The report never finishes running, be it from Analytics page or through a job.
I want to Save data with Context as 'None'
If I select 'Save data to file' the report runs but only send an email notification, and does not create a task to disable the account.
Report SQL:
SELECT u2.username as username, u2.displayname as 'Manager', u.username AS 'Guest user to terminate', u.displayname 'DisplayName', u.userkey AS userKey, date_format(u.enddate, '%Y/%m/%d') as EndDate, a.name AS accName , a.accountkey AS acctKey, 'Disable account' AS Default_Action_For_Analytics
FROM
users u
LEFT JOIN user_accounts ua ON u.userkey = ua.userkey
LEFT JOIN accounts a ON a.accountkey = ua.accountkey
LEFT JOIN users u2 on u2.userkey = u.manager
WHERE u.enddate is not null and datediff(now(),u.enddate) between 0 and 10 and a.status in (1 , 'Active','Manually Provisioned') and a.endpointkey=12;
The report has only 1 line of data result, but still fails to run.
09/15/2023 02:42 AM
Can you change your query to the below and check:
SELECT u2.username as username, u2.displayname as 'Manager', u.username AS 'Guest user to terminate', u.displayname 'DisplayName', u.userkey AS userKey, date_format(u.enddate, '%Y/%m/%d') as EndDate, a.name AS accName , a.accountkey AS acctKey, 'disableAccount' AS Default_Action_For_Analytics
FROM
users u
LEFT JOIN user_accounts ua ON u.userkey = ua.userkey
LEFT JOIN accounts a ON a.accountkey = ua.accountkey
LEFT JOIN users u2 on u2.userkey = u.manager
WHERE u.enddate is not null and datediff(now(),u.enddate) between 0 and 10 and a.status in (1 , 'Active','Manually Provisioned') and a.endpointkey=12;
Configuring Allowed Actions (saviyntcloud.com)
09/17/2023 10:15 PM - edited 09/17/2023 10:15 PM
Hi Armaan,
This solution does not work.
Thanks,
Shubham Babbar