query sql in Service Desk

query sql in Service Desk

Hello, first excuse my English.
As I add this consultation sql in SD.
The run with mysql and I work, but the report I sent a mistake.

SELECT
std.STATUSNAME "Estado de solicitud",
wo.WORKORDERID "ID de solicitud",
mdd.MODENAME "Modo de solicitud",
sinfo.WORKSTATIONNAME "Estaci�n de trabajo",
DATE_FORMAT(FROM_UNIXTIME(wo.CREATEDTIME/1000) ,'%d-%m-%Y %k:%i') "Hora de creaci�n",
DATE_FORMAT(FROM_UNIXTIME(woh.OPERATIONTIME/1000) ,'%d-%m-%Y %k:%i') "Inicio tiempo resuelto",
DATE_FORMAT(FROM_UNIXTIME(wo.COMPLETEDTIME/1000) ,'%d-%m-%Y %k:%i') "Hora de finalizaci�n",
DATE_FORMAT(FROM_UNIXTIME(wo.TIMESPENTONREQ/1000) ,'%d-%m-%Y %k:%i') "Tiempo empleado",
wo.TITLE "Asunto",
aau.FIRST_NAME "Cliente",
ti.FIRST_NAME "Tecnico",
woh.OPERATION "Estado"

FROM
WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID
LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN SystemInfo sinfo ON wo.WORKSTATIONID=sinfo.WORKSTATIONID
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
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
LEFT JOIN workorderhistory woh ON woh.WORKORDERID=wo.WORKORDERID

WHERE
woh.OPERATION="RESOLVED"

ORDER BY 1

:cry:


































                  New to ADSelfService Plus?