Reporting on Assignments

Version 1

    Requirement

    Produce a report that shows who an Incident was assigned to and for how long

     

    Solution

    All assignments are stored in the pm_process_assignment table.  This table contains references to the particular process instance (linked to on pm_process) it refers to as well as the assignee user/group/role which can be linked to the tps_user/tps_group/tps_role tables.  Furthermore, the creation date of the assignment and the last update date are on that table, in conjunction with the status of the assignment (link pm_status_guid to the lc_status table) you can determine how long the assignment was with each individual.