Hello! I'm looking into generating a scheduled report report that shows our tickets related to "Leavers" from the last 30 days (to be sent the 15th of each month). The fields to consider are either "Effective Date" or "Start/Leave Date". This is the query I have so far, but doesn't look correct:

SELECT "wo"."WORKORDERID" AS "Request ID", "mdd"."MODENAME" AS "Request Mode", "aau"."FIRST_NAME" AS "Requester", "sdo"."NAME" AS "Site", "regionDef"."REGIONNAME" AS "Region", "std"."STATUSNAME" AS "Request Status", LONGTODATE("scf"."GUDF_DATE7") AS "Effective date", LONGTODATE("wof"."UDF_DATE6") AS "Start / Leave Date", LONGTODATE("wo"."CREATEDTIME") AS "Created Time" FROM WorkOrder wo 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 SiteDefinition siteDef ON wo.SITEID = siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID = sdo.ORG_ID LEFT JOIN RegionDefinition regionDef ON siteDef.REGIONID = regionDef.REGIONID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID = wos.WORKORDERID 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 LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID = wof.WORKORDERID LEFT JOIN ServiceCatalog_Fields scf ON wo.WORKORDERID = scf.WORKORDERID WHERE ((("qd"."QUEUENAME" = N'Global Access Management') AND ("wo"."TITLE" LIKE N'Leaver%')) AND ((("scf"."GUDF_DATE7" >= 1600556400000) AND (("scf"."GUDF_DATE7" != 0) AND ("scf"."GUDF_DATE7" IS NOT NULL))) AND (("scf"."GUDF_DATE7" <= 1603148399000) AND ((("scf"."GUDF_DATE7" != 0) AND ("scf"."GUDF_DATE7" IS NOT NULL)) AND ("scf"."GUDF_DATE7" != - 1))))) OR ((("wof"."UDF_DATE6" >= 1600556400000) AND (("wof"."UDF_DATE6" != 0) AND ("wof"."UDF_DATE6" IS NOT NULL))) AND (("wof"."UDF_DATE6" <= 1603148399000) AND ((("wof"."UDF_DATE6" != 0) AND ("wof"."UDF_DATE6" IS NOT NULL)) AND ("wof"."UDF_DATE6" != - 1)))) AND wo.ISPARENT = '1'

Are you able to assist? Thanks!