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;
Solved! Go to Solution.
09/29/2024 09:34 PM
@Saksi try below
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 'Updatee',
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
09/29/2024 10:01 PM
SELECT e.endpointname,
t.endpoint,
Count(CASE
WHEN t.tasktype = 2 THEN 1
END) AS 'Revoke Access',
Count(CASE
WHEN t.tasktype = 14 THEN 1
END) AS 'Disable Access',
Count(CASE
WHEN t.tasktype = 12 THEN 1
END) AS 'Update Access',
Count(CASE
WHEN t.tasktype = 3 THEN 1
END) AS 'Create Access',
Count(CASE
WHEN t.tasktype NOT IN ( 2, 3, 12, 14 ) THEN 1
END) AS 'Other Access'
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;
09/29/2024 11:43 PM
@Saksi what we were informed is that guardrail has been implemented due to which if the query takes longer time than you see this message.
Though you can attach an email template once anlytics execution completes.
09/30/2024 01:18 AM
It worked thank you Raghu and Rushikesh, but i am curious to know what was the issue as the query is exactly same which i provided.
09/30/2024 01:52 AM
Update / create are internal words hence i have added access keyword
09/30/2024 02:17 AM
@Saksi Some of keys words not allow .
Example : date,status ..etc it wont allow so you need append new word or change the word
09/30/2024 03:15 AM
Thank you Rushikesh and Raghu. I have accepted the solution.