A MySQL query to return Closed calls without a notification

A MySQL query to return Closed calls without a notification

Hi Supportcenter team,

We use a MySQL query you gave us previously to retrieve the status of calls, including closed calls.

This doesn't appear to bring back the closed calls that are closed without sending a close notification as the query we use checks on the last entry for the call showed as Notification sent call closed.

Is there a query you can provide please that will allow us to get the last entry within a request to be "Call Closed without Notification"

Many thanks

Rich

                New to ADSelfService Plus?