ServiceDesk

 View Only
  • 1.  Creating Report - Resolved By

    Posted Sep 05, 2013 01:05 PM

    Is there a way to create a simple report with the "resolved by" field?  The Closed by Owner report is close, but sometimes technicians close reports that are in the quueue (not directly assigned to them).  When this happens, the Ownder field is set to blank, so it won't pull up in the reports as an incident they worked on.

     

    Thanks!

    ServiceDesk 7.5 reporting



  • 2.  RE: Creating Report - Resolved By

    Posted Sep 05, 2013 02:50 PM

    Yes, the Resolved By field is available under Incidents. 

    Create a new report, add the default data source, then click "Add Processes to Report", then "Add Incidents to Report", and add the fields you want from the right side of the Report Writer.



  • 3.  RE: Creating Report - Resolved By

    Posted Sep 05, 2013 04:11 PM

    Thanks for the help!  This is close to what I am looking for.  I see how it lists the Resolved By field now, thank you.  But how do I get it to filter by technician?  That is, I want the Resolved By field to be editable, so that I can select only certain technicians who resolved.

     



  • 4.  RE: Creating Report - Resolved By

    Posted Sep 06, 2013 07:43 AM

    You can't filter on Resolved by in the report settings, however, you can add your technicians to groups and choose With Tasks for Groups (left side of the report writer under Incidents).  Once you select that, an editor will show, and you can select "Editable at Runtime" to filter by group.  You can do the same with Queues by selecting Assigned Queue from the left. 

    You can also group the results by clicking Options towards the top left side of the report writer and selecting the column to group by.

     



  • 5.  RE: Creating Report - Resolved By

    Posted Sep 06, 2013 08:52 AM

    Agreed. As another alternative, you could do a raw sql report and enter your technician name(s) there. Or use a data profile. More knowledge of the SD DB structure is required, but I think everyone should learn that anyway.