Spreadsheet: 815751d1675182001-ip-address-set-value-rank-pull-out-list-test-data
Sheet: Sheet 1

Table 1
Issue | Action | Date Time | [NAME] | Message | IP | Weighted Value |  | Report Single IP | Report Weighted Value |  | Report Single IP | Report Weighted Value
Warning | Connection | 2023/01/26 04:28:11 | zzx | User [zzx] from [a4.a6.a.a42] failed to log in via [SSH] due to authorization failure. |  |  |  | dd4.dd.ww.dd | 6 |  | dd4.dd.ww.dd | 6
Warning | Connection | 2023/01/26 04:22:49 | zzx | User [zzx] from [a6.a01.a0.aee] failed to log in via [SSH] due to authorization failure. |  |  |  | b9.a26.c4.a4 | 3 |  | dd4.dd.ww.dd | 6
Warning | Connection | 2023/01/26 04:dd:36 | zzx | User [zzx] from [a4.a81.a25.a52] failed to log in via [SSH] due to authorization failure. |  |  |  | d9.z26.x4.a4 | 3 |  | dd4.dd.ww.dd | 6
Warning | Connection | 2023/01/26 03:53:09 | zyfwp | User [zyfwp] from [b9.a26.c4.a4] failed to log in via [SSH] due to authorization failure. |  |  |  | x9.z26.w4.a4 | 3 |  | dd4.dd.ww.dd | 6
Warning | Connection | 2023/01/26 03:53:04 | zyfwp | User [zyfwp] from [b9.a26.c4.a4] failed to log in via [SSH] due to authorization failure. |  |  |  | a6.a01.a0.aee | 2 |  | dd4.dd.ww.dd | 6
Warning | Connection | 2023/01/26 03:52:58 | zyfwp | User [zyfwp] from [b9.a26.c4.a4] failed to log in via [SSH] due to authorization failure. |  |  |  | 1ff.dr.dr.1gg | 2 |  | dd4.dd.ww.dd | 6
Warning | Connection | 2023/01/23 17:55:02 | zyfwp | User [zyfwp] from [d9.z26.x4.a4] failed to log in via [SSH] due to authorization failure. |  |  |  | ddd.hhh.uu.fp0 | 2 |  | x9.z26.w4.ww4 | 3
Warning | Connection | 2023/01/23 17:54:57 | zyfwp | User [zyfwp] from [d9.z26.x4.a4] failed to log in via [SSH] due to authorization failure. |  |  |  | then all the IPs with 1 as a weighted value | 1 |  | x9.z26.w4.ww4 | 3
Warning | Connection | 2023/01/23 17:54:47 | zyfwp | User [zyfwp] from [d9.z26.x4.a4] failed to log in via [SSH] due to authorization failure. |  |  |  |  | 1 |  | x9.z26.w4.ww4 | 3
Warning | Connection | 2023/01/25 [NAME] | zyfwp | User [zyfwp] from [[NAME]] failed to log in via [SSH] due to authorization failure. |  |  |  |  | 1 |  | b9.a26.c4.a4 | 3
Warning | Connection | 2023/01/25 03:45:29 | zyfwp | User [zyfwp] from [[NAME]] failed to log in via [SSH] due to authorization failure. |  |  |  |  | 1 |  | b9.a26.c4.a4 | 3
Warning | Connection | 2023/01/25 03:45:24 | zyfwp | User [zyfwp] from [[NAME]] failed to log in via [SSH] due to authorization failure. |  |  |  |  | 1 |  | b9.a26.c4.a4 | 3
Warning | Connection | 2023/01/24 dd:36:44 | zyc | User [zyc] from [ss9.z26.w4.w4] failed to log in via [SSH] due to authorization failure. |  |  |  |  | 1 |  | d9.z26.x4.a4 | 3
Warning | Connection | 2023/01/24 dd:32:35 | zyc | User [zyc] from [ee9.hh6.w4.w4] failed to log in via [SSH] due to authorization failure. |  |  |  |  | 1 |  | d9.z26.x4.a4 | 3
Warning | Connection | 2023/01/26 04:45:51 | zxc | User [zxc] from [t9.tt6.wt4.wt4] failed to log in via [SSH] due to authorization failure. |  |  |  | Until no more exist | Until no more exist |  | d9.z26.x4.a4 | 3
Warning | Connection | 2023/01/26 04:25:21 | zxc | User [zxc] from [u9.uu6.u4.u4] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ddd.hhh.uu.fp0 | 2
Warning | Connection | 2023/01/24 [NAME] | zxc | User [zxc] from [zz9.zz6.z4.z4] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | a6.a01.a0.aee | 2
Warning | Connection | 2023/01/24 08:19:32 | zx | User [zx] from [d9.zd6.zd4.z4] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | a6.a01.a0.aee | 2
Warning | Connection | 2023/01/24 09:01:56 | zx | User [zx] from [v9.zv6.v4.vb4] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | 1ff.dr.dr.1gg | 2
Warning | Connection | 2023/01/24 08:55:51 | zx | User [zx] from [vw4.vw6.v.v] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | 1ff.dr.dr.1gg | 2
Warning | Connection | 2023/01/24 09:08:33 | zx | User [zx] from [fff.f2.f5.f6] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ddd.hhh.uu.fp0 | 2
Warning | Connection | 2023/01/24 08:45:52 | zx | User [zx] from [dsf.jk.dfg.ppp] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | 1ee.ggg.1tf.1wd | 1
Warning | Connection | 2023/01/24 08:41:09 | zx | User [zx] from [gfh.tf.lak.lak] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ww.sl3.ksd.hh | 1
Warning | Connection | 2023/01/24 14:42:49 | [NAME] | User [zsw] from [ppp.pwp.pft.wdz] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | 1ee.rt.ll.1dd | 1
Warning | Connection | 2023/01/24 15:02:25 | [NAME] | User [zsw] from [dd.gg.g.wdf] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ddd.hhh.kh.61 | 1
Warning | Connection | 2023/01/26 08:57:03 | zs | User [zs] from [wd.ddf.ggg.hhh] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | dd.wd.ddg.ll | 1
Warning | Connection | 2023/01/26 08:43:39 | zs | User [zs] from [gfh.zz.jhs.dd] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ddf.89.232.klm | 1
Warning | Connection | 2023/01/26 08:44:05 | zs | User [zs] from [lbu.wry.zs.pao] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ppp.pwp.fp4.jjj | 1
Warning | Connection | 2023/01/26 04:30:44 | [NAME] | User [zq] from [ou.kdu.1jk.dd] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ff.sdu.dd.uy | 1
Warning | Connection | 2023/01/26 04:40:57 | [NAME] | User [zq] from [ff.k3g.fp.sl] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ff.ky.r9.zs | 1
Warning | Connection | 2023/01/26 04:48:51 | [NAME] | User [zq] from [ww.klm.r.ksd] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | [NAME] | 1
Warning | Connection | 2023/01/26 04:26:55 | [NAME] | User [zq] from [n.k3g.kdt.hh] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | kjh.sdf.pwd.pp | 1
Warning | Connection | 2023/01/26 04:43:07 | [NAME] | User [zq] from [lll.hdo.kl.g5] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | lll.hdo.kl.g5 | 1
Warning | Connection | 2023/01/26 04:20:53 | [NAME] | User [zq] from [1ee.ggg.1tf.1wd] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | d9.zd6.zd4.z4 | 1
Warning | Connection | 2023/01/26 04:45:15 | [NAME] | User [zq] from [1ff.dr.dr.1gg] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | [NAME] | 1
Warning | Connection | 2023/01/26 04:30:49 | [NAME] | User [zq] from [dd4.dd.ww.dd] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | v9.zv6.v4.vb4 | 1
Warning | Connection | 2023/01/24 17:15:40 | zookeeper | User [zookeeper] from [ww.sl3.ksd.hh] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | fff.f2.f5.f6 | 1
Warning | Connection | 2023/01/23 18:40:50 | zookeeper | User [zookeeper] from [dd4.dd.ww.dd] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | vw4.vw6.v.v | 1
Warning | Connection | 2023/01/23 16:57:46 | zookeeper | User [zookeeper] from [dd4.dd.ww.dd] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | u9.uu6.u4.u4 | 1
Warning | Connection | 2023/01/26 04:14:14 | znc | User [znc] from [a6.a01.a0.aee] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | a4.a81.a25.a52 | 1
Warning | Connection | 2023/01/26 04:08:44 | znc | User [znc] from [dd4.dd.ww.dd] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | a4.a6.a.a42 | 1
Warning | Connection | 2023/01/26 04:01:51 | znc | User [znc] from [dd4.dd.ww.dd] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ss9.z26.w4.w4 | 1
Warning | Connection | 2023/01/24 04:39:34 | zl | User [zl] from [dd4.dd.ww.dd] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | t9.tt6.wt4.wt4 | 1
Warning | Connection | 2023/01/24 14:19:40 | zjq | User [zjq] from [ddd.hhh.uu.fp0] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ee9.hh6.w4.w4 | 1
Warning | Connection | 2023/01/24 14:36:42 | zimbra | User [zimbra] from [ff.ky.r9.zs] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ou.kdu.1jk.dd | 1
Warning | Connection | 2023/01/24 14:11:34 | zimbra | User [zimbra] from [ff.sdu.dd.uy] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | [NAME] | 1
Warning | Connection | 2023/01/24 dd:59:33 | zimbra | User [zimbra] from [kjh.sdf.pwd.pp] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ff.k3g.fp.sl | 1
Warning | Connection | 2023/01/24 dd:53:37 | zimbra | User [zimbra] from [lap.r.r.ssu] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | n.k3g.kdt.hh | 1
Warning | Connection | 2023/01/24 dd:51:44 | zimbra | User [zimbra] from [ppp.pwp.fp4.jjj] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ww.klm.r.ksd | 1
Warning | Connection | 2023/01/24 14:14:43 | zimbra | User [zimbra] from [ddd.hhh.kh.61] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | gfh.zz.jhs.dd | 1
Warning | Connection | 2023/01/24 14:01:55 | zimbra | User [zimbra] from [1ee.rt.ll.1dd] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | gfh.tf.lak.lak | 1
Warning | Connection | 2023/01/24 14:22:25 | zimbra | User [zimbra] from [1ff.dr.dr.1gg] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | dsf.jk.dfg.ppp | 1
Warning | Connection | 2023/01/24 14:05:26 | zimbra | User [zimbra] from [ddf.89.232.klm] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | ppp.pwp.pft.wdz | 1
Warning | Connection | 2023/01/24 14:11:39 | zimbra | User [zimbra] from [ddd.hhh.uu.fp0] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | wd.ddf.ggg.hhh | 1
Warning | Connection | 2023/01/24 14:40:36 | zimbra | User [zimbra] from [dd.wd.ddg.ll] failed to log in via [SSH] due to authorization failure. |  |  |  |  |  |  | dd.gg.g.wdf | 1