Hi,

I got an SQL report which have been working in the past but all of a sudden stopped working. 

The report should say which tickets haven't been updated during the last three days.

Below is the query:

SELECT "qd"."QUEUENAME" AS "Group", "wo"."WORKORDERID" AS "Request ID", "ti"."FIRST_NAME" AS "Technician", "scd"."NAME" AS "Subcategory", "wo"."TITLE" AS "Subject", LONGTODATE(wo.CREATEDTIME) AS "Created Time", LONGTODATE(wos.LAST_TECH_UPDATE) AS "Last Upd Time" FROM "WorkOrder" "wo" LEFT JOIN "WorkOrderStates" "wos" ON "wo"."WORKORDERID"="wos"."WORKORDERID"

LEFT JOIN "SubCategoryDefinition" "scd" ON "wos"."SUBCATEGORYID"="scd"."SUBCATEGORYID"

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 "WorkOrder_Queue" "woq" ON "wo"."WORKORDERID"="woq"."WORKORDERID"

LEFT JOIN "QueueDefinition" "qd" ON "woq"."QUEUEID"="qd"."QUEUEID"

INNER JOIN "AccountSiteMapping" "asm" ON "wo"."siteid"="asm"."siteid"

INNER JOIN "AccountDefinition" "ad" ON "asm"."accountid"="ad"."org_id" WHERE (( ((("wos"."LAST_TECH_UPDATE" != 0) AND ("wos"."LAST_TECH_UPDATE" IS NOT NULL)) AND ("wos"."LAST_TECH_UPDATE" != -1)))) AND wo.ISPARENT='1' and wos.LAST_TECH_UPDATE/1000 <= (datediff(s,'1970-01-01 00:00',GETDATE())-(3*24*60*60)) and ad.org_name like '%Customer A%' and ad.org_name like '%Customer B%' and std.statusname like '%Awaiting customer response%' and std.statusname like '%Open%' ORDER BY 1, 6

When I run the report I don't get any "No data to generate report", but I know for a fact that we got tickets that haven't been updated in the last 72 hours.