What is Add Access Entitlement Task Type?

[hokim90]

I'm trying to figure this out when setting instant provisioning by exploring Saviynt docs.

But there is no information on this.

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

- https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter06-EIC-Configurations/Config...

- And other release notes also...

Thanks.

What is this type and how can pull only tasks that have Add Access Entitlement type of task via query?

[rushikeshvartak · Accepted solution]

This task are used when entitlements are added into role during role management process from ARS

task type and meanings

LECT new Map(tasks.status as status,requestKey as requestKey,endpoint as endpoint,entitlement_valueKey as entitlement_valueKey,users as users,parenttask as parenttask,| accountKey as accountKey,securitysystem as securitysystem,tasks.tasktype as tasktype,tasks.accountName as accountName,requestAccessKey as requestAccessKey,tasks.ownerType as ownerType,tasks.ownerkey as ownerkey,|tasks.id as id,tasks.sourceId as sourceId,tasks.taskdate as taskdate,tasks.updateDate as updateDate ,tasks.provisioningComments as provisioningComments,tasks.provisioningMetadata as provisioningMetadata,tasks.source as source,|updateuser as upadteuser,tasks.comments as comments,tasks.startDate as startDate,tasks.endDate as endDate, (select concat(COALESCE(firstname,'') , ' ' , COALESCE(lastname,'') , ' (' , username , ')') from Users u where u.id=tasks.requestedBy) as name,| case when tasks.tasktype = 1 then 'Add Access'| when tasks.tasktype = 2 then 'Remove Access'| when tasks.tasktype = 3 then 'New Account'| when tasks.tasktype = 4 then 'Role'| when tasks.tasktype = 5 then 'Change Password'| when tasks.tasktype = 6 then 'Enable Account'| when tasks.tasktype = 7 then 'Claim Account'| when tasks.tasktype = 8 then 'Delete Account'| when tasks.tasktype = 9 then 'Update User'| when tasks.tasktype = 12 then 'Update Account'| when tasks.tasktype = 13 then 'Proposed Entitlement Owner'| when tasks.tasktype = 14 then 'Disable Account'| when tasks.tasktype = 23 then 'Modify Privilege'| when tasks.tasktype = 24 then 'Create Entitlement'| when tasks.tasktype = 25 then 'Add Access Entitlement'| when tasks.tasktype = 26 then 'Remove Access Entitlement'| when tasks.tasktype = 27 then 'Update Entitlement'| when tasks.tasktype = 28 then 'Delete Entitlement'| when tasks.tasktype = 29 then 'Grant Firefighter ID'| when tasks.tasktype = 30 then 'Revoke Firefighter ID'| when tasks.tasktype = 31 then 'Update Access End Date'| when tasks.tasktype = 32 then 'Lock Account'| when tasks.tasktype = 33 then 'Unlock Account'| when tasks.tasktype = 34 then 'FireFighter Instance Grant Access' | when tasks.tasktype = 35 then 'FireFighter Instance Revoke Access'| when tasks.tasktype = 36 then 'Emergency Access ID Alert'| when tasks.tasktype = 37 then 'Create Organization' | when tasks.tasktype = 38 then 'Update Organization' | else 'tasks.tasktype' end as TASKTYPE ,| tasks.requestedBy )| FROM ArsTasks tasks left join tasks.entitlement_valueKey entitlement_valueKey|left join tasks.requestKey requestKey|left join tasks.endpoint endpoint|left join tasks.users users|left join tasks.accountKey accountKey|left join tasks.securitysystem securitysystem|left join tasks.requestAccessKey requestAccessKey|left join tasks.upadteuser as updateuser|left join tasks.parenttask as parenttask| WHERE tasks.id > 0 and tasks.status IN (1,2,6,7) and 1=1 order by tasks.id desc NULLS LAST

[hokim90]

Hi rushikeshvartak.

Thanks for prompt response. Is there no attribute to identify ADD ACCESS / ADD ACCESS ENTITLEMENT?

[hokim90]

Wanted to see how many tasks created for the last 1 month or couple of months for that type of task.

[rushikeshvartak]

Select taskkey,tasktype from arstasks where tasktype in (25,1)

[hokim90]

One another question, if task for Corp AD is created, then this task will be provisioned by WSRetry on Corp AD endpoint, right?

[rushikeshvartak]

Yes its based on security system