Reporting on most recent requested date for each service

[Lisa Conn]

Hello Experts,

I have a requirement to create a report that displays the most recent date a service was requested for each item in our service catalog. So the desired end result would display the list of catalog items (sc_cat_item) with the most recent date that it was requested. Does anyone know how this can be achieved?

Thank You

[Community Alums]

Hi @Lisa Conn ,

I believe it can be done in a simple way-

Create a report on sc_req_item table

Group it by Item(if required)- The item field holds the catalog item name

Add a sort filter on Opened field from z-a.

Please find the below Screenshot of the same-

I hope this helps.

[jcmings]

Report on sc_req_item, grouping on the Item field, sorting Z-A on Created/Opened.