Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/29/2024 10:49 AM
Hi,
When i am trying to run the below query it is returning the result in Data Analyzer and Dry run in analytics. But it is throwing the error "Alert: Control execution is taking longer than expected. You will be notified when the result is ready." while executing. Only 6 records are expected to return from this query not sure why it is getting timed out.
I have created the analytics to use it in the dashboard in ES tile format. But as analytics is not running due to which data is not being displayed in dashboard.
Query used for analytics:
SELECT
e.endpointname,
t.endpoint,
COUNT(CASE WHEN t.tasktype = 2 THEN 1 END) AS 'Revoke',
COUNT(CASE WHEN t.tasktype = 14 THEN 1 END) AS 'Disable',
COUNT(CASE WHEN t.tasktype = 12 THEN 1 END) AS 'Update',
COUNT(CASE WHEN t.tasktype = 3 THEN 1 END) AS 'Create',
COUNT(CASE WHEN t.tasktype NOT IN (2, 3, 12, 14) THEN 1 END) AS 'Other '
FROM
arstasks t
INNER JOIN
endpoints e ON t.endpoint = e.endpointkey
WHERE
t.status = 1
AND t.endpoint IN (3, 7, 9, 10, 2, 2266)
GROUP BY
e.endpointname, t.endpoint;