Spreadsheet: 550181d1512141831-very-basic-how-to-display-call-log-data-starting-with-time-of-calls-exportmessagesexample
Sheet: ExportMessages

Date | Facility | Severity | Host | Syslogtag | ProcessID | Messagetype | Message
2017-12-01 08:24:11 | 23 | 7 | REDACTED | SMDR: |  | 1 | 475005     12/01/2017 08:23:09 00:02 00:00:00 0:00:01:02 0    I T02 00/01 User1, Unique1     1062            01/01 T03             9799123         Y 9799123         N  v2
2017-12-01 08:23:31 | 23 | 7 | REDACTED | SMDR: |  | 1 | 475006     12/01/2017 08:23:31 00:06 00:00:00 0:00:00:00 0    I T02 00/01 User2, Unique2 1079            01/01 T03             5138874         Y 5138874         N  v2
2017-12-01 08:22:38 | 23 | 7 | REDACTED | SMDR: |  | 1 | 475004     12/01/2017 08:21:56 00:03 00:00:00 0:00:00:42 0    E T03 01/01 User3, Unique3     [PHONE]      00/01 T02             1065            Y 1065            N  v2
2017-12-01 08:20:22 | 23 | 7 | REDACTED | SMDR: |  | 1 | 475003     12/01/2017 08:20:09 00:02 00:00:00 0:00:00:13 0    E T03 01/01 User3, Unique3     [PHONE]      00/01 T02             1065            Y 1065            N  v2
2017-12-01 08:17:03 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474997     12/01/2017 08:13:41 00:03 00:00:00 0:00:03:22 0    I T02 00/01 User4, Unique4 1028            01/01 T03             [PHONE]     Y [PHONE]     N  v2
2017-12-01 08:16:10 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474998     12/01/2017 08:15:58 00:00 [NAME] 0:00:00:12 0    I T03 01/01 User5, Unique5    [PHONE]      00/01 T02             vm-1078         Y 1078            F  v2
2017-12-01 08:15:59 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474998     12/01/2017 08:15:59 00:12 00:00:00 0:00:00:00 0    I T03 01/01 User5, Unique5    [PHONE]      00/00 T02             1078            N 1078            F  v2
2017-12-01 08:15:58 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474996     12/01/2017 08:13:13 00:15 00:00:00 0:00:02:45 0    I T02 00/01 [NAME], Unique6  1078            01/01 T03             6993191         Y 6993191         N  v2
2017-12-01 08:15:46 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474998     12/01/2017 08:15:26 00:02 00:00:00 0:00:00:20 0    I T03 01/01 User7, Unique7    [PHONE]      00/01 T02             1098            N 1098            F  v2
2017-12-01 08:15:27 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474998     12/01/2017 08:15:25 00:00 00:00:00 0:00:00:02 0    E T03 01/01 User7, Unique7    [PHONE]      00/01 T02             1330            N 1330            N  v2
2017-12-01 08:15:22 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474995     12/01/2017 08:09:38 00:07 00:00:00 0:00:05:44 0    I T02 00/01 User8, Unique8    1051            01/01 T03             2746621         Y 2746621         N  v2
2017-12-01 08:14:12 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474986     12/01/2017 08:07:58 00:06 00:00:00 0:00:06:14 0    I T03 01/01 WIRELESS CALLER [PHONE]      00/01 T02             1014            Y 1014            F  v2
2017-12-01 08:12:35 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474984     12/01/2017 08:01:49 00:16 00:00:00 0:00:10:46 0    I [NAME], Unique9 1048            01/01 T03             4703746         Y 4703746         N  v2
2017-12-01 08:09:42 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474991     12/01/2017 08:07:40 00:22 [NAME] 0:00:02:02 0    I T02 00/01 User10, Unique10 1089            01/01 T03             5931510         Y 5931510         N  v2
2017-12-01 08:08:31 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474989     12/01/2017 08:08:15 00:00 00:00:00 0:00:00:16 0    I T03 01/01 User11, Unique11 [PHONE]      00/01 T02             vm-1078         Y 1078            F  v2
2017-12-01 08:08:16 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474989     12/01/2017 08:08:16 00:23 00:00:00 0:00:00:00 0    I T03 01/01 User11, Unique11 [PHONE]      00/00 T02             1078            N 1078            F  v2
2017-12-01 08:07:59 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474986     12/01/2017 08:07:37 00:02 00:00:00 0:00:00:22 0    I T03 01/01 WIRELESS CALLER [PHONE]      00/01 T02             1083            N 1083            F  v2
2017-12-01 08:07:52 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474989     12/01/2017 08:07:38 00:02 00:00:00 0:00:00:14 0    I T03 01/01 User11, Unique11 [PHONE]      00/01 T02             1098            N 1098            F  v2
2017-12-01 08:07:46 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474985     12/01/2017 08:06:41 00:30 00:00:00 0:00:01:05 0    I T02 00/01 User12, Unique12 1038            01/01 T03             4411661         Y 4411661         N  v2
2017-12-01 08:07:39 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474989     12/01/2017 08:07:37 00:00 [NAME] 0:00:00:02 0    E T03 01/01 User11, Unique11 [PHONE]      00/01 T02             1330            N 1330            N  v2
2017-12-01 08:07:38 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474986     12/01/2017 08:07:15 00:03 00:00:00 0:00:00:23 0    I T03 01/01 WIRELESS CALLER [PHONE]      00/01 T02             1098            N 1098            F  v2
2017-12-01 08:07:16 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474986     12/01/2017 08:07:14 00:00 [NAME] 0:00:00:02 0    E T03 01/01 WIRELESS CALLER [PHONE]      00/01 T02             1330            N 1330            N  v2
2017-12-01 08:00:55 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474982     12/01/2017 08:00:47 00:01 [NAME] 0:00:00:08 0    I T03 01/01                 [PHONE]      00/01 T02             1098            Y 1098            F  v2
2017-12-01 08:00:48 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474982     12/01/2017 08:00:45 00:00 00:00:00 0:00:00:03 0    E T03 01/01                 [PHONE]      00/01 T02             1330            N 1330            N  v2
2017-12-01 08:00:26 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474981     12/01/2017 07:59:00 00:07 00:00:00 0:00:01:26 0    I T02 00/01 User13, Unique13   1057            01/01 T03             [PHONE]     Y [PHONE]     N  v2
2017-12-01 07:57:30 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474979     12/01/2017 07:57:23 00:00 00:00:00 0:00:00:07 0    E T03 01/01 User14, Unique14 [PHONE]      00/01 T02             vm-1029         Y 1029            F  v2
2017-12-01 07:57:24 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474979     12/01/2017 07:57:24 00:24 00:00:00 0:00:00:00 0    E T03 01/01 User14, Unique14 [PHONE]      00/00 T02             1029            N 1029            N  v2
2017-12-01 07:50:34 | 23 | 7 | REDACTED | SMDR: |  | 1 | 474978     12/01/2017 07:49:13 00:13 00:00:00 0:00:01:21 0    I T02 00/01 User15, Unique15 1063            01/01 T03             3335102         Y 3335102         N  v2