Re: query for all as in a ripe database?
-
To: mircea markus mmarkus@localhost
-
From: Shane Kerr shane@localhost
-
Date: Tue, 29 Jul 2003 13:03:18 +0200
-
Cc: db-help@localhost
mircea markus wrote:
I need a list with all AS(as-num) objects in a ripe database. I.E.
obtain a list with all the regitered AS in that specified database.
I would like to know if such a ting is posible, and perhaps some clues
about it..
There is no "give all aut-num objects" query. However, for the RIPE
Database, you can see all of the aut-num objects in an export on our
FTP site:
ftp://ftp.ripe.net/ripe/dbase/split/ripe.db.aut-num.gz
If you are running your own database based on the RIPE software, you
can use the text_export utility to create a similar file from our own
database.
Otherwise, you can write a simple script to do the queries:
$ perl -e 'foreach $as (1..65535) { system("whois -r -Tan AS$as") }'
Remove the lines beginning with '%' and you should have a complete
map. This will take a few minutes to run.
--
Shane Kerr
RIPE NCC