Total Items: 106116
| EscalationLevel | LatestCall | LatestChat | LatestSms | LatestEmail | LatestFax | Campaign | IsOpen | Customer | LatestTicket | CreatedAt | UpdatedAt | Subject | Description | Priority | Disposition | ConversationType | Parent | Account | OpenedBy | AssignedTo | Region | Department | QueryType | SubQueryType | Escalation | EscalationCron | History | CreatedBy | UpdatedBy | Category | Subcategory | CreatedBy1 | UpdatedBy1 | ResolvedAt | Thread | ResolvedBy | WasCreatedByCustomer | HasIvrcall | Creator | Updator | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2246 | 3/10/2021 9:35:36 AM | 3/28/2022 7:23:36 AM | water | requested a report from water works<br/><b>Monitoring Reason</b>: [requested a report from water works] | 21 | 3 | 2037 | 2 | 23 | 1 | 100 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-03-10T09:35:21.119Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T07:57:01.377Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T08:31:31.278Z"}] | 1 | 96 | 20 | 20 | |||||||||||||||||||||||||
| 2251 | 3/10/2021 9:34:42 AM | 5/19/2022 1:22:29 PM | Plumbers Letter | WATER QUERY<div><br></div><div>Plumbers letter with repairs dated April 2021. </div><div>Consumer e-mail 11 August 2021 advising that consumption ha snot dropped. Unable to proceed with leak rebate</div><div><br></div><div><p class="MsoNormal"><span lang="EN-ZA">“Plumbers letter was received for repairs dated April 2021, but consumption has not dropped since date of repairs and therefore does not warrant a leak credit adjustment.<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-ZA">Consumer to appoint a plumber to check if any other existing leaks”<o:p></o:p></span></p></div> | 27 | 3 | 2036 | 37 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-03-10T09:31:11.242Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-11T12:25:24.241Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-14T08:13:01.198Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-14T08:14:54.090Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T07:58:21.734Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T08:30:58.330Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-18T07:55:51.373Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-20T07:52:33.843Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2022-02-05T10:28:21.400Z"},{"op":"R","uid":"218","un":"siyabulelas","dt":"2022-05-19T13:22:30.195Z"}] | 1 | 96 | 17 | 5/19/2022 1:22:29 PM | 37 | 17 | ||||||||||||||||||||||
| 2250 | 3/10/2021 9:28:45 AM | 2/2/2022 12:28:44 PM | High water consumption | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 4 | 3 | 72 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-10T09:28:30.019Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T07:59:08.948Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T09:02:25.116Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T09:02:33.900Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 2249 | 3/10/2021 9:25:13 AM | 3/2/2022 8:22:38 AM | WATER QUERY | Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query. | 4 | 3 | 2035 | 37 | 2 | 23 | 1 | 67 | 1031 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-03-10T09:21:43.034Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T07:59:30.841Z"}] | 9 | 123 | 20 | 3/2/2022 8:22:38 AM | 37 | 20 | |||||||||||||||||||||
| 103 | 3/10/2021 9:24:20 AM | 2/24/2022 10:34:50 AM | SEWERAGE DRAIN BLOCKED | sewerage drain blocked,kindly investigate and resolve. | 27 | 3 | 119 | 26 | 2 | 23 | 77 | 58 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-03-10T09:20:47.828Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:36:45.295Z"}] | 77 | 58 | 2/24/2022 10:34:50 AM | 26 | 20 | |||||||||||||||||||||||
| 2248 | 3/10/2021 9:08:04 AM | 2/2/2022 12:28:44 PM | Transfer charges to owner's account | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 4 | 3 | 72 | 2 | 23 | 77 | 76 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-10T09:07:49.655Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T07:59:53.035Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T09:03:34.305Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 2247 | 3/10/2021 9:05:53 AM | 2/2/2022 12:28:44 PM | High water consumption | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 4 | 3 | 72 | 2 | 23 | 1 | 67 | 1030 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-10T09:05:37.523Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T08:00:38.390Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T09:04:29.825Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | ||||||||||||||||||||||
| 2245 | 3/10/2021 9:01:10 AM | 11/13/2022 5:57:28 AM | Leak | Leak<br><b>Monitoring Reason</b>: [need more readings]<div>Account does not qualify for leak rebate<br><div><br></div><div>6months policy done for period 2021/08</div><br><b>Journal Number</b>: [782531]</div> | 27 | 3 | 2034 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-03-10T09:00:55.361Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T08:01:07.041Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T08:30:14.002Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T09:05:56.408Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-18T09:17:59.711Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-01-05T13:25:54.353Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-03T08:43:46.717Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-03T08:46:10.849Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-04T14:13:12.423Z"}] | 1 | 96 | 11 | 6/30/2022 1:27:34 PM | 134175 | 7 | 3 | |||||||||||||||||||||
| 2243 | 3/10/2021 8:57:46 AM | 3/28/2022 7:23:36 AM | Leak | Leak<br/><b>Journal Number</b>: [011889] | 27 | 3 | 2033 | 13 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-03-10T08:57:30.518Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T08:01:28.228Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T08:30:03.921Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2022-02-19T09:08:57.897Z"}] | 1 | 96 | 6 | 3/28/2022 7:23:36 AM | 13 | 6 | ||||||||||||||||||||||
| 2244 | 3/10/2021 8:57:35 AM | 2/2/2022 12:28:44 PM | High water consumption | Kindly investigate high water charges raised on this account. | 3 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-10T08:57:20.290Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T08:02:05.306Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-29T11:49:07.206Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-29T11:49:42.027Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-29T11:50:39.127Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-29T12:09:00.582Z"}] | 77 | 67 | 10 | ||||||||||||||||||||||||||||
| 2242 | 3/10/2021 8:54:06 AM | 3/28/2022 7:10:22 AM | water query 6 month | water query 6 month<div><b>Journal Number</b>: [784731]<br></div><div><br></div><div>6months policy for period 2020/09</div> | 24 | 3 | 2032 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-03-10T08:53:50.512Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-03-10T08:54:02.044Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-23T07:38:33.111Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T08:02:25.413Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-18T09:53:10.145Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-19T08:58:39.602Z"}] | 1 | 101 | 11 | 11 | |||||||||||||||||||||||||
| 2241 | 3/10/2021 8:48:18 AM | 3/2/2022 8:22:38 AM | WATER QUERY | Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query. | 4 | 3 | 2031 | 37 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-03-10T08:44:47.724Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-07-05T09:24:30.041Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T08:02:46.748Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T08:29:22.697Z"}] | 9 | 123 | 20 | 3/2/2022 8:22:38 AM | 37 | 20 | ||||||||||||||||||||||
| 2240 | 3/10/2021 8:44:28 AM | 3/28/2022 7:23:36 AM | Leak | Leak<br/><b>Journal Number</b>: [014089] | 28 | 3 | 2030 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-03-10T08:44:13.174Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-06-09T11:18:44.180Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-06-30T12:24:27.137Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T08:03:15.121Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T08:28:55.361Z"}] | 1 | 96 | 20 | 20 | |||||||||||||||||||||||||
| 2239 | 3/10/2021 8:42:44 AM | 4/12/2022 9:47:18 AM | WATER QUERY | WATER QUERY,PLUMBERS LETTER SUBMITTED<br/><b>Journal Number</b>: [747917]<br/><b>Journal Amount</b>: [97802.22] | 27 | 3 | 2029 | 10 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-03-10T08:39:14.132Z"},{"op":"R","uid":"37","un":"sokanan","dt":"2021-03-10T08:40:32.664Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-09-01T07:42:05.778Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-25T09:41:22.141Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T08:03:37.286Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T08:28:31.441Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2022-02-08T07:30:00.353Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2022-02-21T09:22:08.013Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2022-03-01T11:16:33.763Z"}] | 1 | 96 | 2 | 4/12/2022 9:47:18 AM | 10 | 2 | ||||||||||||||||||||||
| 2237 | 3/10/2021 8:41:06 AM | 3/28/2022 7:10:22 AM | LEAK CR PASSED | LEAK CR PASSED<br/><b>Journal Number</b>: [427598] | 27 | 3 | 2028 | 11 | 4 | 23 | 1 | 96 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-03-10T08:40:50.647Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T10:51:04.841Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-14T08:17:15.801Z"}] | 1 | 96 | 17 | 3/28/2022 7:10:22 AM | 11 | 17 | ||||||||||||||||||||||
| 2238 | 3/10/2021 8:40:56 AM | 3/28/2022 7:08:29 AM | 6 MONTHS POLICY JOURNAL DONE | 6 MONTHS POLICY JOURNAL DONE <br/><b>Journal Number</b>: [427610] | 27 | 3 | 2027 | 6 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-10T08:40:41.262Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-10T08:41:12.560Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-10T08:41:17.058Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T08:07:26.241Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-04T09:16:40.416Z"}] | 1 | 101 | 11 | 3/28/2022 7:08:29 AM | 6 | 11 | ||||||||||||||||||||||
| 2236 | 3/10/2021 8:40:19 AM | 3/28/2022 7:23:36 AM | water query 6 month policy | water query <br><b>Journal Number</b>: [undefined]<div><br></div><div>6moths policy done for 2019/03 period</div> | 24 | 3 | 2026 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-03-10T08:40:03.798Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T07:12:40.900Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-17T07:59:30.336Z"}] | 1 | 101 | 11 | 11 | |||||||||||||||||||||||||
| 2235 | 3/10/2021 8:35:14 AM | 3/28/2022 6:33:19 AM | Leak | Leak<br/><b>Journal Number</b>: [931661] | 27 | 3 | 2025 | 3 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-03-10T08:34:59.054Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-04-19T06:28:46.625Z"}] | 1 | 96 | 3/28/2022 6:33:19 AM | 3 | 3 | |||||||||||||||||||||||
| 2230 | 3/10/2021 8:34:07 AM | 2/2/2022 12:28:44 PM | High water consumption query | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 4 | 3 | 72 | 2 | 23 | 1 | 67 | 1026 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-10T08:33:52.042Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T08:07:56.356Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T09:15:13.164Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T09:15:23.230Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | ||||||||||||||||||||||
| 2234 | 3/10/2021 8:32:23 AM | 2/16/2022 9:04:39 AM | no services billed | please charge services,<div>ACCOUNT IN ORDER.</div> | 27 | 3 | 2024 | 82 | 4 | 23 | 1 | 58 | 1947 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-10T08:32:24.780Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-04-20T08:40:23.305Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-04-20T08:40:41.846Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-11T10:35:05.397Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-17T09:31:49.324Z"}] | 1 | 113 | 12 | 2/16/2022 9:04:39 AM | 194 | 12 |