Analytics Query for Account Creation/Update/Deletion

[Bhargav]

Hi Team, 

We have a requirement to build analytics to generate a report like Account Creation/Update/Deletion details.

Can someone please help me with Query?

TIA

Bhargav.

[rushikeshvartak]

• You can create update / delete account tasks from actionable analytics
• create account task is not supported from analytics
• Refer https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...
• Delete Account select a.name,a.accountkey as acctKey, endpointkey, 'deprovisionAccount' as Default_Action_For_Analytics from accounts;
• update account  - select a.name,a.accountkey as acctKey, endpointkey, 'UpdateAccount' as Default_Action_For_Analytics from accounts a;