Can anyone please help me with the valid SQL query which will help me to fetch the tasks which got triggered due to a particular user update rule?
Go to Solution.
check arstasks table source,assignedfromrule column for the rule key through which this task go created.source column should have value as zero day.
Below is the query you can try
select TASKKEY,userkey from arstasks where ASSIGNEDFROMRULE in (select objectvalue from hanaruleattribute where (objectvalue !='') and HANARULE in (select hanarulekey from hanarule where type='2' and name = 'User_update_rule_Name'))