Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Analytics issue - Alert: Control execution is taking longer than expected.

Saksi
New Contributor II
New Contributor II

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;

 

7 REPLIES 7

Raghu
All-Star
All-Star

@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


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

rushikeshvartak
All-Star
All-Star

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;


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Manu269
All-Star
All-Star

@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.

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Saksi
New Contributor II
New Contributor II

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.

Update / create are internal words hence i have added access keyword


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

@Saksi  Some of keys words not allow .

Example : date,status ..etc  it wont allow so you need append new word  or change the word


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

Saksi
New Contributor II
New Contributor II

Thank you Rushikesh and Raghu. I have accepted the solution.