How can we retrieve name of the identity using hql

IdentityIQ (IIQ) IIQ Discussion and Questions
, ,
1

Which IIQ version are you inquiring about?

Version 8.3

Share all details related to your problem, including any error messages you may have received.

how can we retrieve the name of the identity , the workflow triggered for that identity and the completion status of the task . I have used the above query but it is not showing any result and it is showing not mapped error.

select i.name,w.name,t.completionStatus 
from Identity i
join i.Workflow w
join w.TaskResult t
2

Hi @AkashRaavi131,

Run the below query and see whether is that what you are looking for.

select target_name,name,completion_status from identityiq.spt_task_result where type in ('Workflow','LCM') ;
3

You can use my Query Plugin to test your HQL (and other things): pub / sailpoint-plugins / Query Plugin · GitLab