{"success":true,"server_time":"2026-11-12 07:13:48","timezone":"Asia/Singapore","records":[{"database":"envcctv_bd201","id":1,"dtu_no":"","project_name":"KOH Brothers BD201","sim_number":"896503012603011182","mobile_number":"89998095","telco":"","activation_date":"2026-10-17","expiry_date":"2027-10-17","status":"ACTIVE","remarks":"","created_at":"2026-09-16 06:04:50","updated_at":"2026-10-17 01:34:41","username":"envrh20","ecm_no":"4","purpose":"Auto silt stopper & AI Camera"},{"database":"envcctv_cr109","id":1,"dtu_no":"","project_name":"CR109","sim_number":"896503012307098156","mobile_number":"87938639","telco":"","activation_date":"2025-09-09","expiry_date":"2026-11-22","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:56:50","updated_at":"2026-09-08 08:56:50","username":"cr109ecm","ecm_no":"1","purpose":"Auto silt stopper"},{"database":"envcctv_cr109","id":2,"dtu_no":"","project_name":"CR109","sim_number":"896503012307098164","mobile_number":"87921059","telco":"","activation_date":"2025-10-29","expiry_date":"2026-11-22","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:58:34","updated_at":"2026-09-08 08:58:34","username":"cr109ecm","ecm_no":"2","purpose":"Auto silt stopper"},{"database":"envcctv_daa3","id":1,"dtu_no":"","project_name":"DAA 3","sim_number":"896503012509082866","mobile_number":"89952502","telco":"","activation_date":"2026-07-18","expiry_date":"2027-07-18","status":"ACTIVE","remarks":"","created_at":"2026-09-08 10:02:33","updated_at":"2026-09-08 10:02:33","username":"envrh6","ecm_no":"1","purpose":"DAA3-redhorn"},{"database":"envcctv_daa4","id":1,"dtu_no":"","project_name":"DAA 4","sim_number":"896503012509082863","mobile_number":"80268579","telco":"","activation_date":"2026-07-30","expiry_date":"2027-07-30","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:49:09","updated_at":"2026-09-08 09:49:09","username":"envrh7","ecm_no":"1","purpose":"DAA4-Redhorn"},{"database":"envcctv_daa5","id":1,"dtu_no":"","project_name":"DAA 5","sim_number":"896503012509082861","mobile_number":"89952074","telco":"","activation_date":"2026-07-31","expiry_date":"2027-07-31","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:46:54","updated_at":"2026-09-08 09:46:54","username":"envrh8","ecm_no":"1","purpose":"DAA5-Redhorn"},{"database":"envcctv_daa6","id":1,"dtu_no":"","project_name":"DAA 6","sim_number":"896503012509082860","mobile_number":"89952721","telco":"","activation_date":"2026-07-30","expiry_date":"2027-07-30","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:43:48","updated_at":"2026-09-08 09:43:48","username":"envrh10","ecm_no":"1","purpose":"DAA 6-Redhorn"},{"database":"envcctv_de195","id":1,"dtu_no":"","project_name":"DE195","sim_number":"896503012509082859","mobile_number":"89957696","telco":"","activation_date":"2026-06-24","expiry_date":"2027-06-24","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:38:03","updated_at":"2026-09-08 09:38:03","username":"gammonde195","ecm_no":"1","purpose":"Auto silt stopper"},{"database":"envcctv_de195","id":2,"dtu_no":"","project_name":"DE195","sim_number":"896503012509082858","mobile_number":"88672501","telco":"","activation_date":"2026-07-06","expiry_date":"2027-07-06","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:39:44","updated_at":"2026-09-08 09:39:44","username":"gammonde195","ecm_no":"2","purpose":"Auto silt stopper"},{"database":"envcctv_kbgc3","id":1,"dtu_no":"","project_name":"KBGC3","sim_number":"896503012307098163","mobile_number":"87685203","telco":"","activation_date":"2025-10-06","expiry_date":"2027-10-06","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:12:38","updated_at":"2026-10-27 08:20:35","username":"envrh15","ecm_no":"1","purpose":"Auto silt stopper"},{"database":"envcctv_kimlykbgc3","id":1,"dtu_no":"","project_name":"KIMLY KBGC3","sim_number":"896503012601033488","mobile_number":"80917842","telco":"","activation_date":"2026-06-30","expiry_date":"2027-06-30","status":"ACTIVE","remarks":"","created_at":"2026-09-08 10:13:55","updated_at":"2026-09-08 10:13:55","username":"kbgc3wbgt","ecm_no":"1","purpose":"WBGT"},{"database":"envcctv_ktcb202","id":1,"dtu_no":"","project_name":"KTC B202","sim_number":"896503012509082611","mobile_number":"88675483","telco":"","activation_date":"2026-03-04","expiry_date":"2027-03-04","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:04:30","updated_at":"2026-09-08 09:04:30","username":"envrh18","ecm_no":"1","purpose":"Auto silt stopper"},{"database":"envcctv_ktcb202","id":2,"dtu_no":"","project_name":"KTC B202","sim_number":"896503012307098162","mobile_number":"87932745","telco":"","activation_date":"2026-01-31","expiry_date":"2027-01-31","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:06:42","updated_at":"2026-09-08 09:06:42","username":"envrh18","ecm_no":"2","purpose":"Auto silt stopper"},{"database":"envcctv_ktcbul2","id":1,"dtu_no":"","project_name":"KTC BUL2","sim_number":"896503012509082612","mobile_number":"89236385","telco":"","activation_date":"2026-03-02","expiry_date":"2027-03-02","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:33:58","updated_at":"2026-09-08 09:33:58","username":"envrh17","ecm_no":"11","purpose":"Auto silt stopper"},{"database":"envcctv_ktccr206","id":1,"dtu_no":"","project_name":"KTC CR206","sim_number":"896503012405052322","mobile_number":"89235180","telco":"","activation_date":"2026-02-10","expiry_date":"2027-02-10","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:20:53","updated_at":"2026-09-08 09:20:53","username":"envrh16","ecm_no":"1","purpose":"Auto silt stopper"},{"database":"envcctv_ktccr206","id":2,"dtu_no":"","project_name":"KTC CR206","sim_number":"896503012509082607","mobile_number":"88671492","telco":"","activation_date":"2026-03-13","expiry_date":"2027-03-13","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:22:36","updated_at":"2026-09-08 09:22:36","username":"envrh16","ecm_no":"2","purpose":"Auto silt stopper"},{"database":"envcctv_ktccr211","id":1,"dtu_no":"","project_name":"KTC CR211","sim_number":"896503012405052327","mobile_number":"87931465","telco":"","activation_date":"2025-12-27","expiry_date":"2026-12-27","status":"ACTIVE","remarks":"","created_at":"2026-09-08 07:32:20","updated_at":"2026-09-08 07:52:04","username":"envrh9","ecm_no":"1","purpose":"Auto silt stopper"},{"database":"envcctv_ktccr211","id":2,"dtu_no":"","project_name":"KTC CR211","sim_number":"896503012509082608","mobile_number":"88670611","telco":"","activation_date":"2026-03-22","expiry_date":"2027-03-22","status":"ACTIVE","remarks":"","created_at":"2026-09-08 07:34:36","updated_at":"2026-09-08 07:52:24","username":"envrh9","ecm_no":"2","purpose":"Auto silt stopper"},{"database":"envcctv_ktccr211","id":3,"dtu_no":"","project_name":"KTC CR211","sim_number":"896503012509082609","mobile_number":"88674258","telco":"","activation_date":"2026-04-08","expiry_date":"2027-04-08","status":"ACTIVE","remarks":"","created_at":"2026-09-08 07:36:09","updated_at":"2026-09-08 07:52:44","username":"envrh9","ecm_no":"3","purpose":"Auto silt stopper"},{"database":"envcctv_ktccr211","id":4,"dtu_no":"","project_name":"KTC CR211","sim_number":"896503012509082862","mobile_number":"88678559","telco":"","activation_date":"2026-04-08","expiry_date":"2027-04-08","status":"ACTIVE","remarks":"","created_at":"2026-09-08 07:37:43","updated_at":"2026-09-08 07:52:57","username":"envrh9","ecm_no":"5","purpose":"Auto silt stopper"},{"database":"envcctv_ktccr211","id":5,"dtu_no":"","project_name":"KTC CR211","sim_number":"896503012405052324","mobile_number":"87680967","telco":"","activation_date":"2026-03-16","expiry_date":"2027-03-16","status":"ACTIVE","remarks":"","created_at":"2026-09-08 07:39:21","updated_at":"2026-09-08 07:53:13","username":"envrh9","ecm_no":"6","purpose":"Auto silt stopper"},{"database":"envcctv_ktct313","id":1,"dtu_no":"","project_name":"KTC T313","sim_number":"896503012405052326","mobile_number":"87845695","telco":"","activation_date":"2024-12-20","expiry_date":"2027-09-05","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:30:36","updated_at":"2026-09-08 09:30:36","username":"envrh13","ecm_no":"1","purpose":"Auto silt stopper"},{"database":"envcctv_nus","id":1,"dtu_no":"","project_name":"NUS","sim_number":"896503012405052328","mobile_number":"87809361","telco":"","activation_date":"2025-09-01","expiry_date":"2027-09-01","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:26:10","updated_at":"2026-10-15 09:13:35","username":"envrh14","ecm_no":"1","purpose":"Auto silt stopper"},{"database":"envcctv_qjn9c10","id":1,"dtu_no":"","project_name":"QJ N9C10","sim_number":"896503012603011181","mobile_number":"87521384","telco":"","activation_date":"2026-09-07","expiry_date":"2027-09-07","status":"ACTIVE","remarks":"","created_at":"2026-09-08 10:16:29","updated_at":"2026-09-08 10:16:29","username":"envrh19","ecm_no":"1","purpose":"Auto silt stopper"},{"database":"envcctv_sscr112","id":1,"dtu_no":"","project_name":"CR112","sim_number":"896503012307098158","mobile_number":"87684303","telco":"","activation_date":"2025-11-10","expiry_date":"2026-11-10","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:00:08","updated_at":"2026-09-08 08:10:33","username":"envrh12","ecm_no":"1","purpose":"Auto silt stopper"},{"database":"envcctv_sscr112","id":2,"dtu_no":"","project_name":"CR112","sim_number":"896503012307098159","mobile_number":"87689565","telco":"","activation_date":"2025-11-10","expiry_date":"2026-11-10","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:12:09","updated_at":"2026-09-08 08:12:09","username":"envrh12","ecm_no":"2","purpose":"Auto silt stopper"},{"database":"envcctv_sscr112","id":3,"dtu_no":"","project_name":"CR112","sim_number":"896503012405052331","mobile_number":"87480236","telco":"","activation_date":"2026-03-22","expiry_date":"2027-03-22","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:14:23","updated_at":"2026-09-08 08:14:23","username":"envrh12","ecm_no":"3","purpose":"Auto silt stopper"},{"database":"envcctv_sscr112","id":4,"dtu_no":"","project_name":"CR112","sim_number":"896503012307098157","mobile_number":"87933921","telco":"","activation_date":"2025-11-10","expiry_date":"2026-11-10","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:16:48","updated_at":"2026-09-08 08:16:48","username":"envrh12","ecm_no":"4","purpose":"Auto silt stopper"},{"database":"envcctv_sscr112","id":5,"dtu_no":"","project_name":"CR112","sim_number":"896503012307098161","mobile_number":"87425648","telco":"","activation_date":"2025-11-10","expiry_date":"2026-11-10","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:19:02","updated_at":"2026-09-08 08:19:02","username":"envrh12","ecm_no":"5","purpose":"Auto silt stopper"},{"database":"envcctv_sscr112","id":6,"dtu_no":"","project_name":"CR112","sim_number":"896503012307098160","mobile_number":"87422093","telco":"","activation_date":"2025-11-10","expiry_date":"2026-11-10","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:22:50","updated_at":"2026-09-08 08:22:50","username":"envrh12","ecm_no":"6","purpose":"Auto silt stopper"},{"database":"envcctv_sscr112","id":7,"dtu_no":"","project_name":"CR112","sim_number":"896503012405052323","mobile_number":"89237943","telco":"","activation_date":"2025-11-10","expiry_date":"2026-11-10","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:25:27","updated_at":"2026-09-08 08:33:54","username":"envrh12","ecm_no":"7","purpose":"Auto silt stopper"},{"database":"envcctv_ssn106","id":1,"dtu_no":"","project_name":"N106","sim_number":"896503012509082606","mobile_number":"88671906","telco":"","activation_date":"2026-02-12","expiry_date":"2027-02-12","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:37:16","updated_at":"2026-09-08 08:37:16","username":"samsungn106","ecm_no":"5","purpose":"Auto silt stopper"},{"database":"envcctv_ssn106","id":2,"dtu_no":"","project_name":"N106","sim_number":"896503012509082615","mobile_number":"88678569","telco":"","activation_date":"2026-02-12","expiry_date":"2027-02-12","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:39:22","updated_at":"2026-09-08 08:39:22","username":"samsungn106","ecm_no":"11","purpose":"Auto silt stopper"},{"database":"envcctv_ssn106","id":3,"dtu_no":"","project_name":"N106","sim_number":"896503012509082614","mobile_number":"88674635","telco":"","activation_date":"2026-02-12","expiry_date":"2027-02-12","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:40:36","updated_at":"2026-09-08 08:40:36","username":"samsungn106","ecm_no":"16","purpose":"Auto silt stopper"},{"database":"envcctv_ssn106","id":4,"dtu_no":"","project_name":"N106","sim_number":"896503012405052329","mobile_number":"89503721","telco":"","activation_date":"2026-02-12","expiry_date":"2027-02-12","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:42:38","updated_at":"2026-09-08 08:42:38","username":"samsungn106","ecm_no":"18","purpose":"Auto silt stopper"},{"database":"envcctv_ssn106","id":5,"dtu_no":"","project_name":"N106","sim_number":"896503012509082613","mobile_number":"88671514","telco":"","activation_date":"2026-02-12","expiry_date":"2027-02-12","status":"ACTIVE","remarks":"","created_at":"2026-09-08 08:44:02","updated_at":"2026-09-08 08:44:02","username":"samsungn106","ecm_no":"22","purpose":"Auto silt stopper"},{"database":"envcctv_tss1","id":1,"dtu_no":"","project_name":"TSS 1","sim_number":"896503012509082867","mobile_number":"88671703","telco":"","activation_date":"2026-07-03","expiry_date":"2027-07-03","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:58:12","updated_at":"2026-09-08 09:58:12","username":"envrh2","ecm_no":"1","purpose":"TSS1-Redhorn"},{"database":"envcctv_tss2","id":1,"dtu_no":"","project_name":"TSS 2","sim_number":"896503012509082865","mobile_number":"89523995","telco":"","activation_date":"2026-07-10","expiry_date":"2027-07-10","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:56:00","updated_at":"2026-09-08 09:56:00","username":"envrh3","ecm_no":"1","purpose":"TSS2-Redhorn"},{"database":"envcctv_tss3","id":1,"dtu_no":"","project_name":"TSS 3","sim_number":"896503012509082864","mobile_number":"80262051","telco":"","activation_date":"2026-07-30","expiry_date":"2027-07-30","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:52:02","updated_at":"2026-09-08 09:52:02","username":"envrh4","ecm_no":"1","purpose":"TSS3-Redhorn"},{"database":"envcctv_tss4","id":1,"dtu_no":"","project_name":"TSS 4","sim_number":"896503012603011179","mobile_number":"89998055","telco":"","activation_date":"2026-08-05","expiry_date":"2027-08-05","status":"ACTIVE","remarks":"","created_at":"2026-09-08 09:53:29","updated_at":"2026-09-08 09:53:29","username":"envrh4","ecm_no":"2","purpose":"TSS4-Redhorn"},{"database":"envcctv_tss5","id":1,"dtu_no":"","project_name":"TSS 5","sim_number":"896503012603011180","mobile_number":"89992096","telco":"","activation_date":"2026-08-03","expiry_date":"2027-08-03","status":"ACTIVE","remarks":"","created_at":"2026-09-08 10:00:39","updated_at":"2026-09-08 10:00:39","username":"envrh5","ecm_no":"1","purpose":"TSS5-Redhorn"},{"database":"envcctv_dtu1","id":1,"dtu_no":"dtu1","project_name":"KTC-MOH-SGH (PHASE 2A)","sim_number":"896503012603011188","mobile_number":"89997440","telco":"","activation_date":"2026-10-14","expiry_date":"2027-10-14","status":"ACTIVE","remarks":"","created_at":"2026-09-17 07:32:24","updated_at":"2026-10-15 08:33:01","username":"","ecm_no":"","purpose":""}],"database_errors":[],"diagnostics":{"dtu_range":"1-100","databases_connected":32,"sim_tables":31,"unavailable_dtu_databases":["envcctv_dtu9","envcctv_dtu10","envcctv_dtu11","envcctv_dtu12","envcctv_dtu13","envcctv_dtu14","envcctv_dtu15","envcctv_dtu16","envcctv_dtu17","envcctv_dtu18","envcctv_dtu19","envcctv_dtu20","envcctv_dtu21","envcctv_dtu22","envcctv_dtu23","envcctv_dtu24","envcctv_dtu25","envcctv_dtu26","envcctv_dtu27","envcctv_dtu28","envcctv_dtu29","envcctv_dtu30","envcctv_dtu31","envcctv_dtu32","envcctv_dtu33","envcctv_dtu34","envcctv_dtu35","envcctv_dtu36","envcctv_dtu37","envcctv_dtu38","envcctv_dtu39","envcctv_dtu40","envcctv_dtu41","envcctv_dtu42","envcctv_dtu43","envcctv_dtu44","envcctv_dtu45","envcctv_dtu46","envcctv_dtu47","envcctv_dtu48","envcctv_dtu49","envcctv_dtu50","envcctv_dtu51","envcctv_dtu52","envcctv_dtu53","envcctv_dtu54","envcctv_dtu55","envcctv_dtu56","envcctv_dtu57","envcctv_dtu58","envcctv_dtu59","envcctv_dtu60","envcctv_dtu61","envcctv_dtu62","envcctv_dtu63","envcctv_dtu64","envcctv_dtu65","envcctv_dtu66","envcctv_dtu67","envcctv_dtu68","envcctv_dtu69","envcctv_dtu70","envcctv_dtu71","envcctv_dtu72","envcctv_dtu73","envcctv_dtu74","envcctv_dtu75","envcctv_dtu76","envcctv_dtu77","envcctv_dtu78","envcctv_dtu79","envcctv_dtu80","envcctv_dtu81","envcctv_dtu82","envcctv_dtu83","envcctv_dtu84","envcctv_dtu85","envcctv_dtu86","envcctv_dtu87","envcctv_dtu88","envcctv_dtu89","envcctv_dtu90","envcctv_dtu91","envcctv_dtu92","envcctv_dtu93","envcctv_dtu94","envcctv_dtu95","envcctv_dtu96","envcctv_dtu97","envcctv_dtu98","envcctv_dtu99","envcctv_dtu100"],"tables_missing_or_unreadable":["envcctv_redhorn"]}}