<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div class="">Mike,</div>
<div class=""><br class="">
</div>
<div class="">We have no regular processes to delete orphaned customer records. In our analysis of the growth of our data set, orphaned records do not constitute an area of excessive growth and therefore instituting a regular process to purge them has not been
implemented.</div>
<div class=""><br class="">
</div>
<div class="">Once unlinked from a network, a customer record cannot be easily found except for by a lookup of its handle. There is no API function to list orphaned records.</div>
<div class=""><br class="">
</div>
<div class="">I hope that answers your questions.</div>
<div class=""><br class="">
</div>
<div class="">Andy Newton,</div>
<div class="">ARIN</div>
<br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Jan 2, 2015, at 8:24 PM, Mike Joseph <<a href="mailto:mjoseph@google.com" class="">mjoseph@google.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">Hey folks,
<div class=""><br class="">
</div>
<div class="">I have a few questions about Customer records in the ARIN DB and how orphaned ones are handled. Specifically, I'm asking about Customer records in the following situations:</div>
<div class="">
<ul class="">
<li class="">Customer record created (POST <span style="font-family: arial, helvetica, sans-serif; font-size: 11.5px; line-height: 16px; background-color: rgb(237, 237, 237);" class="">/rest/net/PARENTNETHANDLE/customer</span>) but no reassignment made</li><li class="">Simple reassignment deleted (DELETE <span style="font-family: arial, helvetica, sans-serif; font-size: 11.5px; line-height: 16px; background-color: rgb(237, 237, 237);" class="">/rest/net/NETHANDLE</span>)
<b class="">without</b> explicit deletion of the customer record (DELETE <span style="font-family: arial, helvetica, sans-serif; font-size: 11.5px; line-height: 16px; background-color: rgb(237, 237, 237);" class="">/rest/customer/CUSTOMERHANDLE</span>)</li></ul>
<div class="">I know that the documentation admonishes developers not to get into this situation and to be fastidious about cleaning up Customer records, but of course it can happen. And I've tested in both scenarios (knowing the Customer record ID #) that
the record persists at least for a while.</div>
<div class=""><br class="">
</div>
<div class="">So, my questions are:</div>
<div class="">
<ol class="">
<li class="">What happens to these orphaned records?</li><li class="">Does ARIN make any effort to remove them?</li><li class="">If I wanted to clean ours up, how would I even find them? I can't find an API call to find Customer records by NET.</li></ol>
<div class="">Thanks.</div>
</div>
<div class=""><br class="">
</div>
<div class="">-MJ</div>
<div class=""><br class="">
</div>
-- <br class="">
<div class="gmail_signature">
<div dir="ltr" class=""><br class="">
<table cellspacing="0" cellpadding="0" style="font-family:Times" class="">
<tbody class="">
<tr style="color:rgb(85,85,85);font-family:sans-serif;font-size:small" class="">
<td nowrap="" style="border-top-style:solid;border-top-color:rgb(213,15,37);border-top-width:2px" class="">
Mike Joseph |</td>
<td nowrap="" style="border-top-style:solid;border-top-color:rgb(51,105,232);border-top-width:2px" class="">
Manager, Sustaining Engineering & Operations |</td>
<td nowrap="" style="border-top-style:solid;border-top-color:rgb(0,153,57);border-top-width:2px" class="">
<a href="mailto:mjoseph@google.com" target="_blank" class="">mjoseph@google.com</a> |</td>
<td nowrap="" style="border-top-style:solid;border-top-color:rgb(238,178,17);border-top-width:2px" class="">
+1-650-214-4543</td>
</tr>
</tbody>
</table>
<br class="">
</div>
</div>
</div>
</div>
_______________________________________________<br class="">
arin-tech-discuss mailing list<br class="">
<a href="mailto:arin-tech-discuss@arin.net" class="">arin-tech-discuss@arin.net</a><br class="">
http://lists.arin.net/mailman/listinfo/arin-tech-discuss<br class="">
</div>
</blockquote>
</div>
<br class="">
</body>
</html>