When running a report in the Incident Reports Table Schema, Resolved Time is showing as "Not Assigned" even though the individual tickets show a date/time resolved.  Running ServiceDesk 8.1.0 Build 8116

 

 

SELECT wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",wo.RESOLVEDTIME "Resolved Time" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID WHERE  (((wo.CREATEDTIME >= 1351742400000) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1354337999000) AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1))))  AND wo.ISPARENT=1