Find Roles with assignments in a Workflow
Find Roles with assignments in a Workflow
May 24, 2013
Roles in Maximo are used to represent a specific person or a group of people that can be used in workflows, communication templates and escalations.
If you need to find which roles are used in a specific workflow you can use an SQL query like this.
SELECT wfnode.title, wfnode.description, wfa.roleid, r.descriptionFROM wfnodeJOIN wfassignment wfa ON wfa.nodeid=wfnode.nodeid AND wfa.processrev=wfnode.processrev AND wfa.assigncode IS NULLJOIN maxrole r ON r.maxrole=wfa.roleidWHERE wfnode.processname='[PNAME]' AND wfnode.processrev=[PREV] AND wfnode.nodetype='WFTASK'ORDER BY wfnode.title;Just replace the [PNAME] and [PVER] tags with the correct process name and revision.