1 Reply Latest reply on Sep 2, 2010 12:07 AM by jilufe

    All Incidents and Analyst query

    Rookie

      Hi all, I am looking to create a query showing all incidents and the current assigned analyst. I've tried to pull user_currentassignedanalyst from the dbo_im_incident, but when looking at the table, most incidents are not showing up with an analyst.

       

      Any ideas what table I would need to link to get this to show up?

       

      I know in the dbo_pm_process table, there is a pm_latest_assignment_guid field, but I dont know what table to link to get the data.

       

      Thanks,

      Ronald