Create Report to Only Show the Last Work_Notes Entry on a Problem Ticket

[TheKatherine]

I have a request from management to create a report that will be scheduled and emailed out daily or weekly for the following:

• All active Problem tickets
• Priority of 1 or 2
• Show only the last entered work_notes (not all work_notes entered)

Steps I have done so far:

• Created Database View

• Created Report using the new database view

My problem or question:

• The report is showing all of the work_notes entered on the problem ticket (PRB0040010 had 3 work_notes entered at different times of the day)
• How do I only show the last work_notes entry (the one entered on 11/13/2023 09:29:08 AM)?

Any help or guidance would be appreciated.

thank you

TheKatherine

[S A Martin]

It's not the exact solution you're asking for, but this might open up a few options:

https://www.servicenow.com/community/platform-analytics-articles/how-to-create-a-report-that-shows-o...

[TheKatherine]

Thank you S A Martin ... I did look at that video.

However it only shows the last record in the table, whereas I want to show the last comment or work_notes entered on a ticket ... so this will not work.