<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On May 10, 2013, at 9:37 AM, Tore Anderson <<a href="mailto:tore@fud.no">tore@fud.no</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; ">ŤHow many IPv4 PA Assignments have been made by RIPE NCC LIRs since the</span><br style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; ">14th of September 2012? (If possible, but less important: How many</span><br style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; ">addresses did these assignments consist of, in total?)ť</span></blockquote></div><br><div><div>Hi Tore,</div><div><br></div><div>Under 20,549 Allocations provided by RIPE NCC (total of 594,469,888 addresses), there are 3,596,598 first level child assignment objects (total of 459,629,744 addresses) and out of those, 251,254 objects (total of 26,147,674 addresses) are created on or after 14th of September 2012.</div><div><br></div><div>Here is how I did generate the numbers using the standard whois:</div><div><br></div><div>a) I have downloaded latest version of RIPE NCC Delegated extended stats file (<a href="ftp://ftp.ripe.net/ripe/stats/delegated-ripencc-extended-latest">ftp://ftp.ripe.net/ripe/stats/delegated-ripencc-extended-latest</a>)</div><div>b) For each IPv4 resource in the file with the status "allocated" I have queried the RIPE Database for one level more specific "inetnum" objects</div><div>c) For each of those objects, I have ran a "--list-versions" query, picked the first revision and compared the date with 14th of September 2012</div><div><br></div><div>Kind Regards,</div><div>Kaveh.</div><div><br></div><div>---</div><div>Kaveh Ranjbar,</div><div>RIPE NCC Database Group Manager</div></div><div><br></div></body></html>