SELECT "chdt"."CHANGEID" AS "Change ID", "chanf"."UDF_CHAR1" AS "Affected Services", "catadef"."CATEGORYNAME" AS "Category", "cmDef"."FIRST_NAME" AS "Change Manager", "ownaaa"."FIRST_NAME" AS "Change Owner", "orgaaa"."FIRST_NAME" AS "Change Requester", "tempDef"."NAME" AS "Change Template", "ctdef"."NAME" AS "Change Type", "chdt"."CREATEDTIME" AS "Created Time", "chandes"."FULL_DESCRIPTION" AS "Description", "chdt"."SCHEDULEDENDTIME" AS "Scheduled End", "chdt"."SCHEDULEDSTARTTIME" AS "Scheduled Start Time", "stageDef"."DISPLAYNAME" AS "Stage", "approvaldef"."STATUSNAME" AS "Approval Status", "clcodeDef"."NAME" AS "Change Closure Code", "chdt"."COMPLETEDTIME" AS "Completed Time", "chdt"."DELETEDTIME" AS "Deleted Time", "qd"."QUEUENAME" AS "Group", "impactdef"."NAME" AS "Impact", "itemdef1"."NAME" AS "Item", "chanf"."UDF_CHAR3" AS "Justify why Impact (High/Medium/Low)", "chanf"."UDF_CHAR2" AS "Justify why Risk  (High/Medium/Low)", "chdt"."NEXT_REVIEW_ON" AS "Next Review Schedule", "priodef1"."PRIORITYNAME" AS "Priority", "rfc"."NAME" AS "Reason For Change", "chdt"."ISRETROSPECTIVE" AS "Retrospective", "riskDef"."NAME" AS "Risk", "sdo"."NAME" AS "Site", "chsladef"."SLANAME" AS "SLA Name", "chdt"."ISOVERDUE" AS "SLA violated", "statusDef"."STATUSDISPLAYNAME" AS "Status", "subcatadef"."NAME" AS "Subcategory", "chdt"."TITLE" AS "Title", "chargeTable"."TOTAL_CHARGE" AS "Total Charges", "urgdef"."NAME" AS "Urgency", "orgsd"."ISVIPUSER" AS "VIP User", "wfDef"."WORKFLOWNAME" AS "Workflow"  FROM "ChangeDetails" "chdt" LEFT JOIN "SDUser" "orgsd" ON "chdt"."INITIATORID"="orgsd"."USERID" LEFT JOIN "AaaUser" "orgaaa" ON "orgsd"."USERID"="orgaaa"."USER_ID" LEFT JOIN "SDUser" "ownsd" ON "chdt"."TECHNICIANID"="ownsd"."USERID" LEFT JOIN "AaaUser" "ownaaa" ON "ownsd"."USERID"="ownaaa"."USER_ID" LEFT JOIN "PriorityDefinition" "priodef1" ON "chdt"."PRIORITYID"="priodef1"."PRIORITYID" LEFT JOIN "UrgencyDefinition" "urgdef" ON "chdt"."URGENCYID"="urgdef"."URGENCYID" LEFT JOIN "ChangeTypeDefinition" "ctdef" ON "chdt"."CHANGETYPEID"="ctdef"."CHANGETYPEID" LEFT JOIN "ApprovalStatusDefinition" "approvaldef" ON "chdt"."APPR_STATUSID"="approvaldef"."STATUSID" LEFT JOIN "CategoryDefinition" "catadef" ON "chdt"."CATEGORYID"="catadef"."CATEGORYID" LEFT JOIN "SubCategoryDefinition" "subcatadef" ON "chdt"."SUBCATEGORYID"="subcatadef"."SUBCATEGORYID" LEFT JOIN "ItemDefinition" "itemdef1" ON "chdt"."ITEMID"="itemdef1"."ITEMID" LEFT JOIN "ImpactDefinition" "impactdef" ON "chdt"."IMPACTID"="impactdef"."IMPACTID" LEFT JOIN "QueueDefinition" "qd" ON "chdt"."GROUPID"="qd"."QUEUEID" LEFT JOIN "ChangeToCharge" "changeCharge" ON "chdt"."CHANGEID"="changeCharge"."CHANGEID" LEFT JOIN "ChargesTable" "chargeTable" ON "changeCharge"."CHARGEID"="chargeTable"."CHARGEID" LEFT JOIN "ChangeToDescription" "chandes" ON "chdt"."CHANGEID"="chandes"."CHANGEID" LEFT JOIN "Change_Fields" "chanf" ON "chdt"."CHANGEID"="chanf"."CHANGEID" LEFT JOIN "SiteDefinition" "siteDef" ON "chdt"."SITEID"="siteDef"."SITEID" LEFT JOIN "SDOrganization" "sdo" ON "siteDef"."SITEID"="sdo"."ORG_ID" LEFT JOIN "RiskDefinition" "riskDef" ON "chdt"."RISKID"="riskDef"."RISKID" LEFT JOIN "ReasonForChangeDetails" "rfc" ON "chdt"."REASONFORCHANGEID"="rfc"."ID" LEFT JOIN "Change_StageDefinition" "stageDef" ON "chdt"."WFSTAGEID"="stageDef"."WFSTAGEID" LEFT JOIN "Change_StatusDefinition" "statusDef" ON "chdt"."WFSTATUSID"="statusDef"."WFSTATUSID" LEFT JOIN "Workflow" "wfDef" ON "chdt"."WFID"="wfDef"."WORKFLOWID" LEFT JOIN "ChangeTemplate" "tempDef" ON "chdt"."TEMPLATEID"="tempDef"."TEMPLATEID" LEFT JOIN "AaaUser" "cmDef" ON "chdt"."CHANGEMANAGERID"="cmDef"."USER_ID" LEFT JOIN "ChangeToClosureCode" "clcodeMapDef" ON "chdt"."CHANGEID"="clcodeMapDef"."CHANGEID" LEFT JOIN "Change_ClosureCode" "clcodeDef" ON "clcodeMapDef"."ID"="clcodeDef"."ID" LEFT JOIN "ChangeSLADef" "chsladef" ON "chdt"."SLAID"="chsladef"."SLAID" WHERE  ( ( ( ( "chdt"."CREATEDTIME" >= datetolong('2023-09-01') ) AND ( ( "chdt"."CREATEDTIME" != 0 ) AND ( "chdt"."CREATEDTIME" IS NOT NULL ) ) ) AND ( ( "chdt"."CREATEDTIME" <= 1700683199000 ) AND ( ( ( "chdt"."CREATEDTIME" != 0 ) AND ( "chdt"."CREATEDTIME" IS NOT NULL ) ) AND ( "chdt"."CREATEDTIME" != -1 ) ) ) ) AND ( "chdt"."DELETEDTIME" IS NULL ) )