GoGreen PC Tune-Up™
Learn More

Insta-Install™
this is how ssl encrypt our websites
MTNCOMP | List View | Table View | myBlog (1772 Entries)
myBlog Home

Blog


SQL and MS Access Database clean up, security audit, and compression analysis and other tasks

SQL

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.