and more in a single search tool across platforms. Read the announcement here. |
03/12/2024 05:11 AM
Hi ,
We are trying to discontinue tasks from pending tasks via actionable analytics
PFB the query leveraged , however I am not able to take any action
Please suggest what can be modified
SELECT a.taskkey AS 'TASK ID',
a.taskdate AS 'TASK CREATE DATE',
a.updatedate AS 'TASK UPDATE DATE',
'discontinue' AS Default_Action_For_Analytics,
CASE
WHEN a.tasktype = 1 THEN 'Add Access'
WHEN a.tasktype = 2 THEN 'Remove Access'
WHEN a.tasktype = 3 THEN 'NEW ACCOUNT'
WHEN a.tasktype = 4 THEN 'NEW ROLE REQUEST'
WHEN a.tasktype = 5 THEN 'CHANGE PASSWORD'
WHEN a.tasktype = 6 THEN 'ENABLE ACCOUNT'
WHEN a.tasktype = 14 THEN 'DISABLE ACCOUNT'
WHEN a.tasktype = 12 THEN 'UPDATE ACCOUNT'
WHEN a.tasktype = 8 THEN 'DELETE ACCOUNT'
ELSE a.tasktype
END AS 'TASK TYPE',
u.username AS 'USERNAME',
CASE
WHEN u.statuskey = 0 THEN 'Inactive'
WHEN u.statuskey = 1 THEN 'Active'
ELSE u.statuskey
END AS 'User_Status',
a.accountname AS 'ACCOUNT NAME',
s.systemname AS 'Security System',
e.endpointname AS 'ENDPOINT NAME',
ev.entitlement_value AS 'ENTITLEMENT VALUE',
CASE
WHEN a.status = 1 THEN 'NEW'
WHEN a.status = 2 THEN 'IN PROGRESS'
WHEN a.status = 3 THEN 'COMPLETE'
WHEN a.status = 4 THEN 'DISCONTINUED'
WHEN a.status = 5 THEN 'PENDING CREATE'
WHEN a.status = 6 THEN 'PENDING PROVISIONING'
WHEN a.status = 7 THEN 'PROVISIONING FAILED'
WHEN a.status = 8 THEN 'ERROR'
WHEN a.status = 9 THEN 'NO_ACTION_REQUIRED'
ELSE a.status
END AS 'TaskStatus'
FROM arstasks a
INNER JOIN users u
ON u.userkey = a.userkey
INNER JOIN endpoints e
ON a.endpoint = e.endpointkey
INNER JOIN securitysystems s
ON s.systemkey = e.securitysystemkey
LEFT JOIN entitlement_values ev
ON a.entitlement_valuekey = ev.entitlement_valuekey where a.tasktype = 12 and a.status = 1
Thanks
Abdul Gaffar
03/12/2024 05:31 AM
We not sure it will work, but already we can achive enhanced update query right, based ars task table through u can update task status , anyway it will discontinue
03/12/2024 06:08 AM
Hi @Abdul_Gaffar ,
This doc has the list of allowed actions. https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...
Discontinue tasks is not in the list. You can not do it.
You can either try enhanced queries or use API calls {{url}}/ECM/{{path}}/discontinueTask
Thanks,
Amit
If this answers your query, Please ACCEPT SOLUTION and give KUDOS.
03/12/2024 09:20 AM
You cannot discontinue a task using actionable analytics as that action is not supported in "Allowed Action" field.
03/12/2024 10:35 AM
Discontinue is not allowed action in actionable analytic.
You can create Enhanced Query to discontinue the task
Refer Allowed actions :https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...