SQL and MS Access Database clean up, security audit, and compression analysis and other tasks
by Mountain Computers Inc., Publication Date: Saturday, December 11, 2021
View Count: 784, Keywords: SQL, MS Access, Archive, Compression, Cleanup, Audit, Security Analysis, Hashtags: #SQL #MSAccess #Archive #Compression #Cleanup #Audit #SecurityAnalysis
Did an analysis of some SQL and MS Access databases that I was cleaned up and found the top IP addresses down to 1000 count over a period of time. the irony of some of these sources.
Some of these databases have 20+ years of history and road mileage so no real worries in taking the data offline and running reports and posting static values instead of having the business and reporting statistics queries sift 20 years of logs within seconds. good stuff though.
I handed over the IP traffic, logs and sources and activities to the associated ip registrars and noc abuse teams for further investigation yet it was fun to see where these folks were coming from, going after, at.
once you do the clean up, indexing and compression, etc... leave your original databases in archive for forensic further analysis and let these source ip's get listed for other noc investigators.
more to come...
ip log count
216.244.66.248 31735
157.90.181.147 21056
216.18.204.210 18330
144.76.176.171 17935
148.251.8.250 17581
148.251.69.139 16364
148.251.244.137 16306
144.76.120.197 15616
148.251.9.145 15259
144.76.60.198 15213
213.239.216.194 14820
144.76.96.236 14105
92.220.10.100 13926
78.46.62.249 13706
144.76.137.254 12997
144.76.118.82 12504
78.46.61.245 12190
144.76.14.153 11135
54.36.148.172 10982
144.76.186.38 10465
148.251.195.14 9972
54.36.148.137 9938
149.202.82.11 9382
178.151.245.174 9187
148.251.120.201 9099
144.76.200.68 8627
192.99.37.116 8604
37.57.218.243 8376
157.90.181.207 7940
136.243.144.81 7855
173.208.206.50 7724
192.99.15.33 7507
144.76.38.10 7417
144.76.38.40 6778
192.99.15.29 6657
192.99.10.170 6525
144.76.3.131 6486
192.99.15.199 6474
88.198.33.145 6362
144.76.71.176 6345
54.36.148.173 6342
78.46.176.21 6314
176.9.58.227 6175
192.99.101.79 6017
204.12.197.234 5898
158.69.243.99 5826
78.46.149.254 5752
160.153.209.41 5655
54.36.148.169 5621
192.151.157.210 5583
167.114.211.237 5509
192.99.7.182 5379
192.99.4.140 5339
192.99.14.135 5322
167.114.116.38 5272
192.99.14.130 5272
5.9.108.254 5241
144.76.6.230 5219
69.30.226.234 5213
167.114.158.215 5104
192.99.37.138 5070
178.63.26.114 4999
144.76.29.149 4936
144.76.7.79 4888
192.99.13.228 4872
192.99.13.88 4867
144.76.40.222 4836
178.63.87.197 4821
173.208.130.202 4797
192.99.6.138 4734
192.99.13.133 4720
158.69.245.219 4691
135.181.9.124 4649
144.76.4.41 4639
167.114.159.99 4637
192.99.5.225 4617
204.12.226.26 4589
3.131.128.189 4557
192.99.4.168 4557
114.119.156.27 4495
114.119.140.38 4466
144.76.91.79 4463
114.119.138.107 4459
114.119.131.163 4457
114.119.145.47 4450
167.114.103.160 4426
114.119.151.5 4425
78.46.63.108 4394
114.119.156.95 4390
178.150.14.250 4366
114.119.132.250 4361
114.119.142.94 4333
114.119.159.123 4316
64.20.43.211 4246
144.76.72.99 4224
85.10.199.185 4218
5.9.66.153 4200
192.99.4.163 4138
47.92.7.94 4137
167.114.100.201 4070
51.210.161.26 4055
158.69.243.115 4042
144.76.29.148 4007
192.95.29.186 4006
144.76.81.229 3955
144.76.67.108 3920
138.201.117.67 3917
136.243.70.151 3906
192.99.160.200 3899
192.99.9.25 3881
5.9.70.72 3858
5.9.155.226 3824
5.9.61.101 3768
5.9.154.68 3744
167.114.116.25 3733
5.9.141.8 3638
5.9.77.102 3634
192.99.5.48 3600
192.99.5.228 3596
192.99.10.93 3553
5.9.154.69 3539
95.91.41.38 3519
5.9.144.234 3433
95.216.38.186 3398
167.114.173.115 3386
192.151.145.178 3372
192.99.14.117 3370
167.114.159.183 3341
62.138.2.243 3338
95.91.76.109 3325
167.114.64.97 3296
54.36.148.176 3264
158.69.245.214 3242
144.76.3.79 3240
5.9.71.213 3224
167.114.101.80 3189
5.9.140.242 3159
167.114.101.65 3159
5.9.156.20 3114
192.99.7.128 3069
5.9.155.37 3062
54.36.148.246 3054
5.9.98.234 3042
158.69.243.140 3036
5.9.156.121 3035
81.109.86.251 2965
54.36.148.126 2949
5.9.156.30 2934
54.36.148.6 2925
5.9.112.210 2920
51.89.208.17 2878
192.99.13.75 2856
173.208.200.154 2809
192.99.6.226 2797
51.89.203.220 2756
62.171.159.200 2747
78.46.85.236 2745
192.99.36.166 2735
167.114.158.241 2728
95.91.76.137 2701
95.91.76.136 2686
202.61.253.63 2660
167.114.209.104 2650
192.99.10.39 2645
176.9.25.107 2644
5.9.88.113 2643
66.249.79.251 2618
5.9.97.200 2597
201.150.35.113 2521
176.31.104.153 2500
51.104.44.103 2459
5.9.138.189 2430
158.69.245.202 2429
173.249.24.3 2413
5.9.107.211 2394
5.9.158.195 2387
192.99.10.47 2311
51.89.207.179 2307
208.110.93.78 2299
164.68.119.249 2226
211.149.214.188 2200
167.114.157.181 2197
158.69.243.108 2195
207.180.201.192 2165
5.9.70.113 2159
213.136.92.122 2158
209.18.90.60 2112
5.9.61.232 2108
5.9.148.241 2107
95.216.157.227 2089
159.69.189.196 2089
159.69.187.108 2089
138.201.95.44 2089
69.30.213.82 2084
173.249.30.147 2081
207.180.245.134 2069
95.216.157.225 2057
176.31.125.95 2038
158.69.243.138 2025
159.69.117.170 2009
5.9.70.117 1965
159.69.189.215 1961
64.62.210.35 1957
66.249.73.217 1956
207.180.218.247 1939
207.180.226.173 1936
192.99.4.151 1903
204.12.220.106 1902
198.204.243.138 1882
167.86.74.24 1875
192.99.13.186 1870
130.255.162.169 1869
69.30.210.242 1861
122.51.242.69 1843
173.212.220.26 1818
62.210.139.231 1802
63.141.231.10 1794
51.255.162.43 1792
164.68.117.152 1772
178.63.34.189 1771
207.244.157.10 1765
110.164.217.55 1749
198.204.244.90 1723
13.66.139.87 1715
193.32.249.166 1712
51.222.253.10 1698
51.222.253.2 1688
51.222.253.7 1686
5.189.152.91 1673
51.222.253.16 1671
51.222.253.4 1670
51.222.253.11 1669
213.136.75.74 1668
51.222.253.20 1664
51.222.253.1 1663
51.222.253.14 1662
167.114.101.143 1657
51.222.253.8 1649
51.222.253.6 1646
51.222.253.15 1635
51.222.253.17 1626
51.222.253.12 1625
51.222.253.5 1624
114.119.162.241 1624
51.222.253.19 1618
51.222.253.13 1618
51.222.253.9 1617
85.10.207.195 1613
114.119.163.254 1613
114.119.161.133 1612
114.119.165.126 1607
173.249.16.207 1607
114.119.160.246 1604
107.150.59.98 1596
114.119.160.172 1592
114.119.161.81 1576
114.119.163.44 1573
51.222.253.3 1558
216.18.204.200 1558
114.119.163.65 1554
51.222.253.18 1535
95.216.157.230 1535
144.91.125.197 1535
144.91.107.187 1532
5.9.151.57 1524
82.193.102.149 1521
114.119.164.178 1518
173.212.215.43 1506
173.208.218.130 1501
149.202.86.61 1500
119.28.193.86 1494
95.216.1.46 1488
66.249.79.253 1484
173.249.7.244 1482
198.27.70.196 1479
192.151.145.82 1475
173.234.153.122 1471
139.28.238.151 1464
34.239.95.80 1462
148.251.131.16 1441
135.181.44.24 1432
69.30.221.250 1424
161.97.135.248 1424
69.30.198.186 1418
129.226.52.232 1407
144.91.125.96 1389
95.216.2.253 1387
157.55.39.57 1375
207.46.13.88 1371
173.212.246.178 1362
207.46.13.64 1345
148.251.92.39 1343
148.72.216.28 1338
23.22.35.162 1327
95.91.74.120 1316
13.66.139.41 1313
95.91.107.69 1312
3.224.220.101 1308
148.251.10.183 1302
103.115.176.13 1300
69.227.151.150 1293
207.180.220.114 1289
52.70.240.171 1281
173.249.63.71 1263
204.12.208.154 1260
192.151.152.98 1233
95.91.110.121 1211
167.86.79.150 1204
173.212.216.3 1193
66.249.79.225 1191
95.91.33.17 1189
173.212.241.58 1164
40.77.167.103 1144
173.212.242.224 1142
173.212.224.157 1132
148.251.70.179 1131
173.208.198.162 1128
164.68.121.239 1120
95.216.20.54 1102
173.212.229.76 1089
45.66.191.42 1075
69.30.205.218 1074
213.109.164.22 1074
198.27.66.59 1071
173.212.222.108 1071
150.95.116.96 1065
167.86.70.217 1062
95.216.9.239 1040
192.99.161.45 1039
35.200.192.236 1037
40.77.167.75 1022
178.210.90.252 1022
207.46.13.105 1021
207.46.13.94 1008
93.188.2.5 1005
148.251.125.12 1005
62.210.143.6 1000
if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.
© 2024 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.