peeringdb / admincom

Track issues specific to AC work
3 stars 1 forks source link

Batch delete networks #204

Closed arnoldnipper closed 6 years ago

arnoldnipper commented 6 years ago

Asbjørn Sloth Tønnesen asbjorn@asbjorn.st reported in DeskPRO ticket 19985 of a bunch of networks which are not longer assigned by any RIR but still in PeeringDB (see file attched).

These /net have been removed as well as the /org if there was no other record (fac, ix) hanging off. 20180721_unassigned_and_not_seen_in_2018.txt

Log of operation: ASN 2133 is not assigned by any RIR deleting /net/11850 deleting /org/15596 ASN 5557 is not assigned by any RIR deleting /net/192 deleting /org/265 ASN 6760 is not assigned by any RIR deleting /net/2161 deleting /org/1983 ASN 6770 is not assigned by any RIR deleting /net/253 deleting /org/342 ASN 6824 is not assigned by any RIR deleting /net/3941 deleting /org/3894 ASN 7615 is not assigned by any RIR deleting /net/2610 deleting /org/2236 ASN 8514 is not assigned by any RIR deleting /net/300 deleting /org/407 ASN 8527 is not assigned by any RIR deleting /net/485 deleting /org/6337 ASN 8939 is not assigned by any RIR deleting /net/1978 deleting /org/1875 ASN 10075 is not assigned by any RIR deleting /net/1595 deleting /org/1634 ASN 10122 is not assigned by any RIR deleting /net/14606 deleting /org/17943 ASN 12295 is not assigned by any RIR deleting /net/106 deleting /org/137 ASN 12359 is not assigned by any RIR deleting /net/384 deleting /org/511 ASN 12452 is not assigned by any RIR deleting /net/2329 deleting /org/2087 ASN 12477 is not assigned by any RIR deleting /net/11303 deleting /org/15118 ASN 12932 is not assigned by any RIR deleting /net/574 deleting /org/784 ASN 15837 is not assigned by any RIR deleting /net/280 deleting /org/381 ASN 16090 is not assigned by any RIR deleting /net/1105 deleting /org/1325 ASN 16318 is not assigned by any RIR deleting /net/803 deleting /org/1035 ASN 20639 is not assigned by any RIR deleting /net/2375 deleting /org/2113 ASN 20680 is not assigned by any RIR deleting /net/2336 deleting /org/2093 ASN 20834 is not assigned by any RIR deleting /net/87 deleting /org/114 ASN 20920 is not assigned by any RIR deleting /net/643 deleting /org/871 ASN 20923 is not assigned by any RIR deleting /net/1318 deleting /org/1463 ASN 21055 is not assigned by any RIR deleting /net/1104 deleting /org/1323 ASN 22059 is not assigned by any RIR deleting /net/1038 deleting /org/1266 ASN 22119 is not assigned by any RIR deleting /net/15645 deleting /org/18915 ASN 24373 is not assigned by any RIR deleting /net/8773 deleting /org/12503 ASN 24457 is not assigned by any RIR deleting /net/2827 deleting /org/11446 ASN 25489 is not assigned by any RIR deleting /net/1385 deleting /org/1503 ASN 27525 is not assigned by any RIR deleting /net/8710 deleting /org/12455 ASN 28168 is not assigned by any RIR deleting /net/4154 deleting /org/8597 ASN 28632 is not assigned by any RIR deleting /net/5710 deleting /org/8334 ASN 28796 is not assigned by any RIR deleting /net/297 deleting /org/405 ASN 28986 is not assigned by any RIR deleting /net/1085 deleting /org/1307 ASN 29158 is not assigned by any RIR deleting /net/471 deleting /org/638 ASN 29279 is not assigned by any RIR deleting /net/1417 deleting /org/1519 ASN 30705 is not assigned by any RIR deleting /net/4876 deleting /org/6571 ASN 30913 is not assigned by any RIR deleting /net/920 deleting /org/1165 ASN 31157 is not assigned by any RIR deleting /net/305 deleting /org/418 ASN 31255 is not assigned by any RIR deleting /net/2321 deleting /org/2082 ASN 31265 is not assigned by any RIR deleting /net/265 deleting /org/360 ASN 31339 is not assigned by any RIR deleting /net/1106 deleting /org/1326 ASN 31523 is not assigned by any RIR deleting /net/2415 deleting /org/2134 ASN 31807 is not assigned by any RIR deleting /net/11823 deleting /org/15571 ASN 33031 is not assigned by any RIR deleting /net/4523 deleting /org/5537 ASN 33929 is not assigned by any RIR deleting /net/15013 deleting /org/18322 ASN 34109 is not assigned by any RIR deleting /net/2110 deleting /org/16828 ASN 34159 is not assigned by any RIR deleting /net/579 deleting /org/792 ASN 34242 is not assigned by any RIR deleting /net/527 deleting /org/713 ASN 34313 is not assigned by any RIR deleting /net/1880 deleting /org/1811 ASN 34567 is not assigned by any RIR deleting /net/2586 deleting /org/2224 ASN 34763 is not assigned by any RIR deleting /net/649 deleting /org/880 ASN 34806 is not assigned by any RIR deleting /net/905 deleting /org/1145 ASN 35112 is not assigned by any RIR deleting /net/3466 deleting /org/2977 ASN 35406 is not assigned by any RIR deleting /net/534 deleting /org/5259 ASN 35591 is not assigned by any RIR deleting /net/1603 deleting /org/1641 ASN 35616 is not assigned by any RIR deleting /net/1558 deleting /org/1617 ASN 35746 is not assigned by any RIR deleting /net/858 deleting /org/1109 ASN 35751 is not assigned by any RIR deleting /net/706 deleting /org/938 ASN 37268 is not assigned by any RIR deleting /net/8815 deleting /org/12477 ASN 38281 is not assigned by any RIR deleting /net/1431 deleting /org/1532 ASN 38828 is not assigned by any RIR deleting /net/4242 deleting /org/4776 ASN 39117 is not assigned by any RIR deleting /net/2738 deleting /org/3692 ASN 42675 is not assigned by any RIR deleting /net/8013 deleting /org/10975 ASN 45180 is not assigned by any RIR deleting /net/2373 deleting /org/3240 ASN 45435 is not assigned by any RIR deleting /net/2001 deleting /org/1888 ASN 45482 is not assigned by any RIR deleting /net/2047 deleting /org/1914 ASN 45646 is not assigned by any RIR deleting /net/2678 deleting /org/3766 ASN 45831 is not assigned by any RIR deleting /net/5867 deleting /org/8173 ASN 45957 is not assigned by any RIR deleting /net/5877 deleting /org/8388 ASN 51563 is not assigned by any RIR deleting /net/12572 deleting /org/16202 ASN 51787 is not assigned by any RIR deleting /net/ The requested URL /api/net/ was not found on this server. jq: error: Cannot iterate over null jq: error: Cannot iterate over null deleting /org/ the requested URL /api/org/ was not found on this server. ASN 52919 is not assigned by any RIR deleting /net/5126 deleting /org/7404 ASN 53226 is not assigned by any RIR deleting /net/7420 deleting /org/11010 ASN 54603 is not assigned by any RIR deleting /net/8684 deleting /org/12334 ASN 55452 is not assigned by any RIR deleting /net/4578 deleting /org/6528 ASN 55800 is not assigned by any RIR deleting /net/3541 deleting /org/3075 ASN 56049 is not assigned by any RIR deleting /net/4891 deleting /org/6638 ASN 56727 is not assigned by any RIR deleting /net/5462 deleting /org/7671 ASN 57413 is not assigned by any RIR deleting /net/4395 deleting /org/5208 ASN 58531 is not assigned by any RIR deleting /net/4671 deleting /org/6387 ASN 59344 is not assigned by any RIR deleting /net/6860 deleting /org/9732 ASN 60134 is not assigned by any RIR deleting /net/8516 deleting /org/12003 ASN 63157 is not assigned by any RIR deleting /net/7493 deleting /org/10355 ASN 63294 is not assigned by any RIR deleting /net/8791 deleting /org/12460 ASN 63990 is not assigned by any RIR deleting /net/9936 deleting /org/13906 ASN 64068 is not assigned by any RIR deleting /net/9145 deleting /org/12981 ASN 64094 is not assigned by any RIR deleting /net/11849 deleting /org/13444 ASN 64952 is not assigned by any RIR deleting /net/862 deleting /org/1113 ASN 65536 is not assigned by any RIR deleting /net/666 deleting /org/5820 ASN 99999 is not assigned by any RIR deleting /net/1351 deleting /org/8942 ASN 131321 is not assigned by any RIR deleting /net/12732 deleting /org/16344 ASN 131478 is not assigned by any RIR deleting /net/10792 deleting /org/14640 ASN 132514 is not assigned by any RIR deleting /net/5728 deleting /org/8058 ASN 135412 is not assigned by any RIR deleting /net/10902 deleting /org/14743 ASN 135554 is not assigned by any RIR deleting /net/12729 deleting /org/16341 ASN 135555 is not assigned by any RIR deleting /net/10995 deleting /org/14826 ASN 135562 is not assigned by any RIR deleting /net/10977 deleting /org/14801 ASN 196650 is not assigned by any RIR deleting /net/3788 deleting /org/3560 ASN 197043 is not assigned by any RIR deleting /net/5964 deleting /org/8311 ASN 198831 is not assigned by any RIR deleting /net/7217 deleting /org/9899 ASN 201690 is not assigned by any RIR deleting /net/8128 deleting /org/11359 ASN 205396 is not assigned by any RIR deleting /net/14624 ASN 262976 is not assigned by any RIR deleting /net/10478 deleting /org/14339 ASN 264179 is not assigned by any RIR deleting /net/9503 deleting /org/13435 ASN 264445 is not assigned by any RIR deleting /net/14044 deleting /org/17539

arnoldnipper commented 6 years ago

Checked the whole DB and additionally deleted:

ASN 2565 is not assigned by any RIR ASN 2565 is not in PeeringDB ASN 32346 is not assigned by any RIR ASN 32346 is not in PeeringDB ASN 46198 is not assigned by any RIR ASN 46198 is not in PeeringDB ASN 46686 is not assigned by any RIR ASN 46686 is not in PeeringDB ASN 65500 is not assigned by any RIR ASN 65500 is not in PeeringDB ASN 99995 is not assigned by any RIR deleting /net/2469 deleting /org/8947 ASN 99996 is not assigned by any RIR deleting /net/1491 deleting /org/8943 ASN 99997 is not assigned by any RIR deleting /net/1979 deleting /org/8944 ASN 99998 is not assigned by any RIR deleting /net/3077 deleting /org/8949 ASN 193324 is not assigned by any RIR deleting /net/4758 deleting /org/11746 ASN 202112 is not assigned by any RIR deleting /net/6967 deleting /org/10382 ASN 204936 is not assigned by any RIR deleting /net/15377 deleting /org/18670 ASN 205407 is not assigned by any RIR deleting /net/14971 deleting /org/18282 ASN 206107 is not assigned by any RIR deleting /net/14475 deleting /org/17823 ASN 221731 is not assigned by any RIR deleting /net/5377 deleting /org/12153 ASN 394719 is not assigned by any RIR deleting /net/9211 deleting /org/12999 ASN 394734 is not assigned by any RIR deleting /net/10113 deleting /org/14031