Tasks are not created

[Kumat]

i'm using simple query to deprovision AD accounts and tasks are not created, when I click on action as Deprovision account in the actionable report.

SELECT name as Accountname, accountkey AS acctKey, endpointkey, 'Deprovision Account' AS Default_Action_For_Analytics FROM accounts WHERE status = 2 and ENDPOINTKEY = 1

Please help me if i'm missing anything. Query returned correct count but tasks are not created.

[dgandhi]

Please paste screenshot of your analytics config.

Thanks

[Kumat]

[Kumat]

I used both deprovision account and delete account, both didn't create tasks.

[dgandhi · Accepted solution]

Select below as default action and try. It should work.

Thanks

[rushikeshvartak · Accepted solution]

https://docs.saviyntcloud.com/bundle/EIC-Admin-v2022x/page/Content/Chapter17-EIC-Analytics/Configuri...

• Sample query:

  • Schedule from Run All V2 Analytics Job

  SQL

  select a.name,a.accountkey as acctKey, endpointkey, 'deprovisionAccount' as Default_Action_For_Analytics from accounts;

  • Schedule from Run All V1 Analytics Job

  SQL

  select a.name,a.accountkey as acctKey, endpointkey, 'Deprovision Account' as Default_Action_For_Analytics from accounts;