Last Resolved By

Garvit1
Tera Contributor

Hi Team,

i need to create a report For Eg- if ticket is re-opened on today how can i add in the report this ticket is resolved by some other person not that person to whom it is assigned today. How can i achieve that? if i add resolved by it shows the person resolved by today only and assigned today?

what filter i can apply in the report.

 

Regads,

Garvit 

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

@Garvit1 

try this

    • Use the following filters to achieve your requirement:

      • Reopened Today:

        Reopen count > 0
        AND
        Reopen time on Today
        
      • Resolved by Different Person:

        Resolved by is not Assigned to
        
  1. Example Filter Configuration:

    • Here’s how you can set up the filters in the report:

      Reopen count > 0
      AND
      Reopen time on Today
      AND
      Resolved by is not Assigned to

If my response helped please mark it correct and close the thread so that it benefits future readers.

 

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@Ankur Bawiskar it's not given me the desired results, report filter is fine but type of report i can show so that the person who resolved the ticket can show that name and, in a team, there are like 8 members working how can i show that in the report.

@Garvit1 

are you saying the filter is working fine?

What's your exact requirement?

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Like, ticket is re-opened on today it is assigned to different person today but initially it is resolved by some other person before the ticket get re-opened today. i am trying to show like this.

 

kindly let me know what type of report i can select and criteria for generate the report, so that the person who resolved the ticket initially that name appears as well.

Garvit1_0-1734356629695.png