Query report for Time Spent for First response in Version 11.0 (Postgres)
SELECT slad.SLANAME AS "Request SLA", wo.WORKORDERID AS "Request ID", longtodate(wo.CREATEDTIME) AS "Created Time", slad.SLANAME AS "Request SLA", longtodate(wo.FR_DUETIME) AS "Request first response due time",round(wo.RESPONSE_TIMESPENT / 60000) AS "Request response time elapsed (in Minutes)", wos.IS_FR_OVERDUE AS "Request first response overdue status", longtodate(wo.RESPONDEDTIME) AS "Responded Date" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN SLADefinition slad ON wo.SLAID=slad.SLAID WHERE ( std.ISPENDING = false ) AND wo.ISPARENT='1' ORDER BY 1, 2
Filtered by: Pending Status is NO.