I have created a summary report of all tickets by technician. We have only had Servicedesk Plus since last December, 2016 but I get results showing data from December of 1969. Very strange. Any ideas on why that is occurring?
I have attached what the output looks like. Here is the SQL query that the report generator created:
SELECT ti.FIRST_NAME AS "Technician", ti.FIRST_NAME AS "Technician", longtodate(wo.RESOLVEDTIME) AS "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.ISPARENT='1') ORDER BY 3 NULLS FIRST
I was trying to create a summary report that would let me choose which month to display but I haven't quite figured that piece out. I was just trying to get this as a starting point.
Any help would be appreciated.
Tim