Hi Bruce,
I'm after a nifty interface which will tell me the following:
Few SQL command will give this information to you. We keep BGP updates daily tables per RRCs. You can get all the prefixes which are seen that day and merge all the data you get and clasify as you want. e.g. to get the list of prefixes on rrc02 at 10th of Nov, 2004, you should type the following SQL commands. You can use abcoude as query server, it's not as loaded as weesp. penguin:arife:~$mysql -u dummy -h abcoude -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 82133 to server version: 3.23.48 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> connect rrc01; Connection id: 82134 Current database: rrc01 mysql> select from_unixtime(utc), prefix from r20041110, prefix where prefix.id=prefix_id; +---------------------+-----------------+ | from_unixtime(utc) | prefix | +---------------------+-----------------+ | 2004-11-10 00:00:17 | 212.53.32.0/19 | | 2004-11-10 00:00:21 | 195.80.226.0/24 | | 2004-11-10 00:00:45 | 195.80.225.0/24 | | 2004-11-10 00:00:45 | 195.80.229.0/24 | | 2004-11-10 00:00:46 | 195.80.225.0/24 | | 2004-11-10 00:01:00 | 195.80.236.0/24 | | 2004-11-10 00:01:15 | 195.49.131.0/24 | | 2004-11-10 00:01:15 | 195.80.228.0/24 | | 2004-11-10 00:01:15 | 195.80.231.0/24 | | 2004-11-10 00:01:15 | 62.89.216.0/23 | +---------------------+-----------------+ 10 rows in set (0.00 sec) mysql> If you would need any help about SQL stuff, let me know. Arife