ServiceDesk

I am trying to create a report in ServiceDesk 7.5 that displays all of the incidents we have on Hold and displays the date that they will be coming off hold. I cannot figure out how to get the hold date to show. The report designer does not seem to have that function. I cannot find where the data is located in SQL to create a raw query. Any suggestions? Thanks.

The hold until date is stored in the SLA Resolution Late Paused Until Date.   To get this in the report, check Add SLA To Report on the left and check Resolution Late Paused Until Date on the right of the report editor.   I've also attached an exported report with this already set.  Drop the .txt extension from the file and import it.

Attachment(s)

List Incidents On Hold with Date.report.txt   47 KB 1 version

Thanks Justin. That is just what I was looking for.