Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Enable Account via analytics

Sekhar
New Contributor III
New Contributor III

Hi,

Iam trying to enable the account via analytics, when start date & current date have 1 day difference.

Query:

select u.username,a.accountkey acctKey,'enableAccount' as Default_Action_For_Analytics FROM USERS U, USER_ACCOUNTS UA, ACCOUNTS A, ENDPOINTS E WHERE U.USERKEY = UA.USERKEY AND UA.ACCOUNTKEY = A. ACCOUNTKEY AND A.ENDPOINTKEY = E.ENDPOINTKEY and e.ENDPOINTKEY=21 and a.status NOT IN (1,'active', 'manually suspended', 'suspended from import service')and date(u.startdate)=date(curdate())+1

Sekhar_0-1715276346544.png

 

 I created Job as well, analytics is not running even if job was success.

Pending task is not triggering if i run the analytics manually.

Sekhar_1-1715276439899.png

Could you please help me in this issue.

 

Thanks,

Sekhar

3 REPLIES 3

Saathvik
All-Star
All-Star

@Sekhar : Can you remove Analytics Application and then run the job to see if that works?


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

Sekhar
New Contributor III
New Contributor III

Hi @Saathvik 

Enable task was triggering now, after removed the analytics application in the job.

 

Thanks,

Sekhar.

rushikeshvartak
All-Star
All-Star
  • Select Base count =1 
  • Try running report manually 
  • Does query works from Data analyzer ?

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.