{"success":true,"generated_at":"2026-07-22 08:35:08","timezone":"Asia/Singapore","summary":{"total":32,"active":31,"renew_soon":1,"urgent":0,"expired":0,"unused":0,"suspended":0,"inactive":0,"cancelled":0,"no_due_date":0,"date_error":0,"monthly_cost":0,"annual_cost":0},"records":[{"id":16,"sim_serial_number":"","sim_number":"87845695","provider":"","company_name":"Samsung C&T Corporation","project_name":"T313","system_type":"","system_id":"ENV2026021","contact_person":"Narayan","contact_email":"test-630gjjomk@srv1.mail-tester.com","username":"","ecm_no":"ECM 1","date_activated":"2024-12-21","last_renewal_date":"2024-12-21","next_renewal_date":"2026-07-31","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Renew Soon","days_remaining":9,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 08:08:36"},{"id":17,"sim_serial_number":"","sim_number":"87809361","provider":"","company_name":"Kimly Construction Pte Ltd","project_name":"NUS","system_type":"Auto silt stopper","system_id":"ENV2026024","contact_person":"Chook Xin","contact_email":"xinyinchook@kimly.com.sg","username":"","ecm_no":"ECM 1","date_activated":"2025-09-03","last_renewal_date":"2025-09-03","next_renewal_date":"2026-09-02","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":42,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":18,"sim_serial_number":"","sim_number":"87685203","provider":"","company_name":"Kimly Construction Pte Ltd","project_name":"KBGC3","system_type":"Auto silt stopper","system_id":"ENV2026025","contact_person":"Chook Xin","contact_email":"xinyinchook@kimly.com.sg","username":"","ecm_no":"ECM 1","date_activated":"2025-10-07","last_renewal_date":"2025-10-07","next_renewal_date":"2026-10-07","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":77,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":8,"sim_serial_number":"","sim_number":"89237943","provider":"","company_name":"Samsung C&T Corporation","project_name":"CR112","system_type":"Auto silt stopper","system_id":"ENV2026009","contact_person":"Ramesh","contact_email":"v.ramesh@samsung.com","username":"","ecm_no":"ECM 7","date_activated":"2025-10-10","last_renewal_date":"2025-10-10","next_renewal_date":"2026-10-10","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":80,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":6,"sim_serial_number":"","sim_number":"87425648","provider":"","company_name":"Samsung C&T Corporation","project_name":"CR112","system_type":"Auto silt stopper","system_id":"ENV2026009","contact_person":"Ramesh","contact_email":"v.ramesh@samsung.com","username":"","ecm_no":"ECM 5","date_activated":"2024-09-13","last_renewal_date":"2025-10-10","next_renewal_date":"2026-11-10","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":111,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":5,"sim_serial_number":"","sim_number":"87933921","provider":"","company_name":"Samsung C&T Corporation","project_name":"CR112","system_type":"Auto silt stopper","system_id":"ENV2026009","contact_person":"Ramesh","contact_email":"v.ramesh@samsung.com","username":"","ecm_no":"ECM 4","date_activated":"2024-09-13","last_renewal_date":"2025-10-10","next_renewal_date":"2026-11-10","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":111,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":4,"sim_serial_number":"","sim_number":"87422093","provider":"","company_name":"Samsung C&T Corporation","project_name":"CR112","system_type":"Auto silt stopper","system_id":"ENV2026008","contact_person":"Ramesh","contact_email":"v.ramesh@samsung.com","username":"","ecm_no":"ECM 6","date_activated":"2024-09-08","last_renewal_date":"2025-10-10","next_renewal_date":"2026-11-10","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":111,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":3,"sim_serial_number":"","sim_number":"87689565","provider":"","company_name":"Samsung C&T Corporation","project_name":"CR112","system_type":"Auto silt stopper","system_id":"ENV2026007","contact_person":"Ramesh","contact_email":"v.ramesh@samsung.com","username":"","ecm_no":"ECM 2","date_activated":"2024-09-08","last_renewal_date":"2025-10-10","next_renewal_date":"2026-11-10","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":111,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":2,"sim_serial_number":"","sim_number":"87684303","provider":"","company_name":"Samsung C&T Corporation","project_name":"CR112","system_type":"Auto silt stopper","system_id":"ENV2026001","contact_person":"Ramesh","contact_email":"v.ramesh@samsung.com","username":"","ecm_no":"ECM 1","date_activated":"2023-05-08","last_renewal_date":"2025-11-10","next_renewal_date":"2026-11-10","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":111,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":33,"sim_serial_number":"","sim_number":"","provider":"","company_name":"BHCC Construction Pte Ltd","project_name":"KWC64","system_type":"WBGT","system_id":"WBGT1","contact_person":"Muthumanikam","contact_email":"muthumanickam@bhcc.com.sg","username":"","ecm_no":"WBGT1","date_activated":"2025-11-26","last_renewal_date":"2025-11-26","next_renewal_date":"2026-11-26","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":127,"remarks":"SIM number: Need to check","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":20,"sim_serial_number":"","sim_number":"87931465","provider":"","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"CR211","system_type":"Auto silt stopper","system_id":"ENV2026027","contact_person":"Ilango","contact_email":"ilango.malaiyandi@ktcgroup.com.sg","username":"","ecm_no":"ECM 1","date_activated":"2025-12-27","last_renewal_date":"2025-12-27","next_renewal_date":"2026-12-27","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":158,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":24,"sim_serial_number":"","sim_number":"87932745","provider":"","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"B202","system_type":"Auto silt stopper","system_id":"ENV2026028","contact_person":"Karthik","contact_email":"ramasamy.karthik@ktcgroup.com.sg","username":"","ecm_no":"ECM 2","date_activated":"2026-01-31","last_renewal_date":"2026-01-31","next_renewal_date":"2027-01-31","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":193,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":26,"sim_serial_number":"","sim_number":"89235180","provider":"","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"CR206","system_type":"Auto silt stopper","system_id":"ENV2026029","contact_person":"Raja","contact_email":"ramasamy.raja@ktcgroup.com.sg","username":"","ecm_no":"ECM 1","date_activated":"2026-02-10","last_renewal_date":"2026-02-10","next_renewal_date":"2027-02-10","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":203,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":13,"sim_serial_number":"","sim_number":"","provider":"","company_name":"Samsung C&T Corporation","project_name":"N106","system_type":"Auto silt stopper","system_id":"ENV2026017","contact_person":"Mahendiran","contact_email":"mahendiran.g@samsung.com","username":"","ecm_no":"ECM 18","date_activated":"2024-10-26","last_renewal_date":"2026-02-12","next_renewal_date":"2027-02-12","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":205,"remarks":"SIM number: Need to check site","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":12,"sim_serial_number":"","sim_number":"88671514","provider":"","company_name":"Samsung C&T Corporation","project_name":"N106","system_type":"Auto silt stopper","system_id":"ENV2026016","contact_person":"Mahendiran","contact_email":"mahendiran.g@samsung.com","username":"","ecm_no":"ECM 22","date_activated":"2024-10-26","last_renewal_date":"2026-02-12","next_renewal_date":"2027-02-12","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":205,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":11,"sim_serial_number":"","sim_number":"88674635","provider":"","company_name":"Samsung C&T Corporation","project_name":"N106","system_type":"Auto silt stopper","system_id":"ENV2026015","contact_person":"Mahendiran","contact_email":"mahendiran.g@samsung.com","username":"","ecm_no":"ECM 16","date_activated":"2024-10-26","last_renewal_date":"2026-02-12","next_renewal_date":"2027-02-12","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":205,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":10,"sim_serial_number":"","sim_number":"88678569","provider":"","company_name":"Samsung C&T Corporation","project_name":"N106","system_type":"Auto silt stopper","system_id":"ENV2026014","contact_person":"Mahendiran","contact_email":"mahendiran.g@samsung.com","username":"","ecm_no":"ECM 11","date_activated":"2024-10-22","last_renewal_date":"2026-02-12","next_renewal_date":"2027-02-12","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":205,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":9,"sim_serial_number":"","sim_number":"88671906","provider":"","company_name":"Samsung C&T Corporation","project_name":"N106","system_type":"Auto silt stopper","system_id":"ENV2026013","contact_person":"Mahendiran","contact_email":"mahendiran.g@samsung.com","username":"","ecm_no":"ECM 5","date_activated":"2024-10-08","last_renewal_date":"2026-02-12","next_renewal_date":"2027-02-12","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":205,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":25,"sim_serial_number":"","sim_number":"89236385","provider":"","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"B202","system_type":"Auto silt stopper","system_id":"ENV2026032","contact_person":"Karthik","contact_email":"ramasamy.karthik@ktcgroup.com.sg","username":"","ecm_no":"ECM 1","date_activated":"2026-03-02","last_renewal_date":"2026-03-02","next_renewal_date":"2027-03-02","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":223,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":28,"sim_serial_number":"","sim_number":"","provider":"","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"BUL 2","system_type":"Auto silt stopper","system_id":"ENV2026031","contact_person":"Reeza","contact_email":"md.shahreeza@ktcgroup.com.sg","username":"","ecm_no":"ECM 11","date_activated":"2026-03-02","last_renewal_date":"2026-03-02","next_renewal_date":"2027-03-02","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":223,"remarks":"Source shows duplicate SIM number 89236385; verify before updating","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":27,"sim_serial_number":"","sim_number":"88671492","provider":"","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"CR206","system_type":"Auto silt stopper","system_id":"ENV2026030","contact_person":"Raja","contact_email":"ramasamy.raja@ktcgroup.com.sg","username":"","ecm_no":"ECM 2","date_activated":"2026-03-13","last_renewal_date":"2026-03-13","next_renewal_date":"2027-03-13","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":234,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":21,"sim_serial_number":"","sim_number":"80917842","provider":"","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"CR211","system_type":"Auto silt stopper","system_id":"ENV2026033","contact_person":"Ilango","contact_email":"ilango.malaiyandi@ktcgroup.com.sg","username":"","ecm_no":"ECM 6","date_activated":"2026-03-16","last_renewal_date":"2026-03-16","next_renewal_date":"2027-03-16","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":237,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":22,"sim_serial_number":"","sim_number":"88670611","provider":"","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"CR211","system_type":"Auto silt stopper","system_id":"ENV2026034","contact_person":"Ilango","contact_email":"ilango.malaiyandi@ktcgroup.com.sg","username":"","ecm_no":"ECM 3","date_activated":"2026-03-22","last_renewal_date":"2026-03-22","next_renewal_date":"2027-03-22","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":243,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":7,"sim_serial_number":"","sim_number":"87480236","provider":"","company_name":"Samsung C&T Corporation","project_name":"CR112","system_type":"Auto silt stopper","system_id":"ENV2026009","contact_person":"Ramesh","contact_email":"v.ramesh@samsung.com","username":"","ecm_no":"ECM 3","date_activated":"2025-03-22","last_renewal_date":"2026-03-22","next_renewal_date":"2027-03-22","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":243,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":23,"sim_serial_number":"","sim_number":"88674258","provider":"","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"CR211","system_type":"Auto silt stopper","system_id":"ENV2026035","contact_person":"Ilango","contact_email":"ilango.malaiyandi@ktcgroup.com.sg","username":"","ecm_no":"ECM 4","date_activated":"2026-04-08","last_renewal_date":"2026-04-08","next_renewal_date":"2027-04-08","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":260,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":19,"sim_serial_number":"896503012601033488","sim_number":"","provider":"","company_name":"Kimly Construction Pte Ltd","project_name":"KBGC3","system_type":"WBGT","system_id":"WBGT2","contact_person":"Chook Xin","contact_email":"xinyinchook@kimly.com.sg","username":"","ecm_no":"WBGT2","date_activated":"2026-06-30","last_renewal_date":"2026-06-30","next_renewal_date":"2027-06-30","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":343,"remarks":"SIM number: Need to check site","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":15,"sim_serial_number":"","sim_number":"87921059","provider":"","company_name":"China Communications Construction Company Limited (Singapore Branch)","project_name":"CR109","system_type":"Auto silt stopper","system_id":"ENV2026020","contact_person":"Deng QiZhao","contact_email":"qizhao.deng@ccccltd.sg","username":"","ecm_no":"ECM 2","date_activated":"2024-10-29","last_renewal_date":"2026-11-22","next_renewal_date":"2027-11-22","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":488,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":14,"sim_serial_number":"","sim_number":"87938639","provider":"","company_name":"China Communications Construction Company Limited (Singapore Branch)","project_name":"CR109","system_type":"Auto silt stopper","system_id":"ENV2026019","contact_person":"Deng QiZhao","contact_email":"qizhao.deng@ccccltd.sg","username":"","ecm_no":"ECM 1","date_activated":"2024-09-09","last_renewal_date":"2026-11-22","next_renewal_date":"2027-11-22","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":488,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":31,"sim_serial_number":"","sim_number":"88671703","provider":"","company_name":"Kim Hua Construction Pte Ltd","project_name":"TSS 1","system_type":"TSS & SIDS","system_id":"TSS1","contact_person":"Sherwin","contact_email":"fabian@kimhuaconstruction.com","username":"","ecm_no":"ECM 1","date_activated":"2026-07-03","last_renewal_date":"2026-07-03","next_renewal_date":"2028-07-03","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":712,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":32,"sim_serial_number":"","sim_number":"89523995","provider":"","company_name":"Prelim Construction Pte Ltd","project_name":"TSS 2","system_type":"TSS & SIDS","system_id":"TSS2","contact_person":"","contact_email":"","username":"","ecm_no":"ECM 1","date_activated":"2026-07-10","last_renewal_date":"2026-07-10","next_renewal_date":"2028-07-10","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":719,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":29,"sim_serial_number":"","sim_number":"89957696","provider":"","company_name":"Gammon Construction Limited (Redhorn)","project_name":"DAA 1","system_type":"AI Camera&Chemical","system_id":"ENVRH1202601","contact_person":"Mathialagu","contact_email":"Mathialagu.Arumugam@gammonconstruction.com","username":"","ecm_no":"ECM 1","date_activated":"2026-06-24","last_renewal_date":"2026-06-24","next_renewal_date":"2029-06-24","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":1068,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"},{"id":30,"sim_serial_number":"","sim_number":"88672501","provider":"","company_name":"Gammon Construction Limited (Redhorn)","project_name":"DAA 2","system_type":"AI Camera&Chemical","system_id":"ENVRH1202602","contact_person":"Mathialagu","contact_email":"Mathialagu.Arumugam@gammonconstruction.com","username":"","ecm_no":"ECM 2","date_activated":"2026-07-06","last_renewal_date":"2026-07-06","next_renewal_date":"2029-07-06","monthly_cost":0,"plan_name":"","saved_status":"Active","calculated_status":"Active","days_remaining":1080,"remarks":"","created_at":"2026-07-21 06:04:21","updated_at":"2026-07-21 06:04:21"}]}