Re: query for all as in a ripe database?


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