As a Change Manager, I am looking for a Report that will allow me (or the Service Owner, Release Manager, etc) to see a list of active RFC's, where they are at in the process and who has the action (either a task needing to be closed or an approval needing to be done). I am a bit suprised that this report is not a standard report that comes out-of-the-box. I need the following data displayed on each line:
RFC Short Description
Change Request State
Workflow Activity Name
Process Role Name
To Whom that workflow step is assigned (name/email of the person) - Should be Assigned to
Date that Workflow step was reached (to see how long it has been awaitng approval or close)
Approval (I need to see the RFC’s in the: Requested, Not yet Requested or Approved state)
The problem I am having is that I can get the info from the change task table, but not if the approval state is Not yet requested. Or I can get the tasks and approvals in one report, but not the "Who" -"or Assigned To"- or person needing to close the task.
Since this infomation would seem to be valuable to any Change Manager, is this type of RFC Status Report just not possible?