http://www.potaroo.net/bgp/rirstats/whoisquery will give you nice one-line entry for each AS with its number, name and description (don't forget to install ripe whois v3 client and change some paths in script for it to work on your system) There is however as you noted a problem with ARIN database as in many places for old AS numbers as-name is "UNSPECIFIED" - for all new AS this is required so its not as much of a problem. The script above deals with that by assigning pseudo-name "ASnumber" for all unspecified names. And unlike geektools, completewhois will do recursive lookup for as in proper database (i.e. "whois -h completewhois.com as3320" in below case) but it just outputs all the data as is and I think for what you wanted, the pataroo script would work best. On Mon, 2 Jun 2003, Mike Leber wrote:
I'm looking for a unified table of AS names or a tool that could be used to generate such a table.
The table at ftp://ftp.arin.net/info/asn.txt only provides ARIN registered AS names, using dig NNNN.rdi.int txt only provides ARIN registered AS names as well, using the geektools whois proxy produces things like:
Checking server [whois.arin.net] Results:
OrgName: RIPE Network Coordination Centre OrgID: RIPE Address: Singel 258 Address: 1016 AB City: Amsterdam StateProv: PostalCode: Country: NL
ASNumber: 3154 - 3353 ASName: RIPE-ASNBLOCK4 ASHandle: AS3154 Comment: These addresses have been further assigned to users in Comment: the RIPE NCC region. Contact information can be found in Comment: the RIPE database at http://www.ripe.net/whois RegDate: 1993-12-10 Updated: 2003-04-25
When a check of RIPE shows:
# whois AS3320 -h whois.ripe.net % This is the RIPE Whois server. % The objects are in RPSL format. % % Rights restricted by copyright. % See http://www.ripe.net/ripencc/pub-services/db/copyright.html
as-block: AS3154 - AS3353 descr: RIPE NCC ASN block remarks: These AS numbers are further assigned by RIPE NCC remarks: to LIRs and end-users in the RIPE NCC region remarks: Please refer to these documents remarks: <http://www.ripe.net/ripe/docs/ir-policies-procedures.html> <http://www.ripe.net/ripe/docs/asnrequestform.html> <http://www.ripe.net/ripe/docs/asnsupport.html> admin-c: CREW-RIPE tech-c: OPS4-RIPE mnt-by: RIPE-NCC-HM-MNT mnt-lower: RIPE-NCC-HM-MNT changed: hostmaster@ripe.net 20010423 changed: hostmaster@ripe.net 20011024 changed: hostmaster@ripe.net 20011120 changed: hostmaster@ripe.net 20020408 source: RIPE
aut-num: AS3320 as-name: UNSPECIFIED descr: Deutsche Telekom AG descr: Internet service provider operations ...more stuff...
Which while you could write a hacked up script that scans for the first description line after finding an aut-num line that was an exact match, leave you wondering questions like is the as-name field unused in the RIPE database (unlike the ARIN database)?
I figure there are several people out that that all must have solved this problem independently, perhaps one of them would share? :) :) :)
Mike.
+----------------- H U R R I C A N E - E L E C T R I C -----------------+ | Mike Leber Direct Internet Connections Voice 510 580 4100 | | Hurricane Electric Web Hosting Colocation Fax 510 580 4151 | | mleber@he.net http://www.he.net | +-----------------------------------------------------------------------+