Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
05/01/2023 06:17 PM
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.
Solved! Go to Solution.
05/01/2023 06:27 PM
Please paste screenshot of your analytics config.
Thanks
05/01/2023 06:37 PM
05/01/2023 06:38 PM
I used both deprovision account and delete account, both didn't create tasks.
05/01/2023 06:57 PM
Select below as default action and try. It should work.
Thanks
05/01/2023 06:50 PM - edited 05/01/2023 06:59 PM
Sample query:
Schedule from Run All V2 Analytics Job
select a.name,a.accountkey as acctKey, endpointkey, 'deprovisionAccount' as Default_Action_For_Analytics from accounts;
Schedule from Run All V1 Analytics Job
select a.name,a.accountkey as acctKey, endpointkey, 'Deprovision Account' as Default_Action_For_Analytics from accounts;