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

Different tasktype code for Remove account and Remove access

Rekha
New Contributor
New Contributor

Hi,

Is there any different task type code for 'Remove account' and 'Remove access' to add in sql query. We followed the Saviynt documentation were tasktype code is 2 for both Remove account and Remove access, can you please let us know if there is different tasktype code. 

2 REPLIES 2

sudeshjaiswal
Saviynt Employee
Saviynt Employee

Hello @Rekha,

You can differentiate remove access and remove account on the basis of entitlement present in the task or not.

Use below queries 

For Remove Access:
Select * from arstasks where tasktype=2 and ENTITLEMENT_VALUEKEY is not null;

For Remove Account:
Select * from arstasks where tasktype=2 and ENTITLEMENT_VALUEKEY is null;

If there is no entitlement (entitlement_valuekey column null in arstaks ) then Remove account  else Remove Access.

Thanks.

If you find the above response useful, Kindly Mark it as "Accept As Solution".

rushikeshvartak
All-Star
All-Star

Source Value Mapping Value Description

ADD

1

Task created when the user requests for new access and the request approval is completed.

REMOVE ACCESS

2

Task created when the user requests for removing access and the request approval is completed.

if Remove Account then Entitlement Valuekey will be null in arstasks table

if Remove Access then Entitlement Valuekey will be present in arstasks table


 

NEWACCOUNT

3

Task created when the user requests for a new account and the request approval is completed.

ROLE REQUEST

4

Task created when the user requests for a new role and the request approval is completed.

CHANGEPASSWORD 

5

Tasks created when the user requests for changing the account password, changing the account password for others, and changing the service account password and the request approval is completed.

ENABLE ACCOUNT

6

Tasks created when the user request for enabling the account and the request approval is completed.

PROPOSED ACCOUNT OWNERS

7

 

DELETE ACCOUNT

8

Tasks created when the user request for deleting an account and the request approval is completed.

UPDATE USER

9

Tasks created when the user request for updating the user information and the request approval is completed.

UPDATE ACCOUNT 

12

Tasks created when the user request for updating the account information and the request approval is completed.

PROPOSED Entitlement OWNERS 

13

 

DISABLE ACCOUNT 

14

Tasks created when the user request for disabling the account and the request approval is completed.

MODIFY PRIVILEGE 

23

Tasks created when the user request for modifying the existing privileges and the request approval is completed.

CREATE ENTITLEMENT

24

Tasks created when the user request for creating entitlement and the request approval is completed.

UPDATE ENTITLEMENT ACCESS ADD

25

 

UPDATE ENTITLEMENT ACCESS ADD

26

 

UPDATE ENTITLEMENT

27

Tasks created when the user request for updating the entitlement and the request approval is completed.

DELETE ENTITLEMENT 

28

Tasks created when the user request for deleting an entitlement and the request approval is completed.

FIREFIGHTER ID GRANT ACCESS

29

 

FIREFIGHTER ID REVOKE ACCESS

30

Tasks created when the user request for revoking the firefighter access and the request approval is completed.

UPDATE ACCESS END DATE

31

Tasks created when the user request for updating the access end date and the request approval is completed.

LOCK ACCOUNT

32

Tasks created when the user request for locking the account and the request approval is completed.

UNLOCK ACCOUNT

33

Tasks created when the user request for unlocking the account and the request approval is completed.

FIREFIGHTER INSTANCE GRANT ACCESS

34

 

FIREFIGHTER INSTANCE REVOKE ACCESS

35

 

FIREFIGHTER ACCESS ALERT

36

 

CREATE ORGANIZATION

37

Tasks created when the user request for creating the organization and the request approval is completed.

UPDATE ORGANIZATION

38

Tasks created when the user requests for updating the organization and the request approval is completed.

https://docs.saviyntcloud.com/bundle/EIC-Database-Schema-Reference/page/Content/Database-Schema-Refe...

 

rushikeshvartak_1-1712804945316.png

 


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