4 Replies Latest reply on Mar 25, 2013 12:56 PM by Carl.Simpson

    How to query What user closed and Incident by date range, can't find user that closed Incident

    Apprentice

      ?I am trying to create a query that shows who created Incidents in a given date range, as I could not see a field for closed date I used the criteria of;

       

      Any Incident that status.is Completion is equal to (True) and Last updated by.Creation Date is between Dates Prompt User.

       

      So far so good the last update date for a closed Incident is the closed date however I can not locate the Lastupdateuser to add to the query.

       

      I did use currently assigned user but realised that the person closing the incident maynot be the currently assigned user.

       

      Any Ideas how I add the person that created the close task to the query Criteria?

       

      Thanks, Gareth