<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
Well, more clearly - You can tell when they ported last. Ideally if you have cleaned up the switch recently, there would not be more than one port between now and then.
<div><br>
</div>
<div>If you waited so long that the customer has changed carriers more than once, well...<br>
<div><br>
<blockquote type="cite">
<div>On Feb 23, 2023, at 10:28 AM, Paul Timmins via VoiceOps <voiceops@voiceops.org> wrote:</div>
<br class="Apple-interchange-newline">
<div>
<div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
Correct. I can't imagine much why it matters when they left if you're just trying to clean up the meta, but I'd talk to the NPAC because they have the historical data and may have some other way to share it.<br>
<div><br>
<blockquote type="cite">
<div>On Feb 23, 2023, at 9:10 AM, Mike Hammett <voiceops@ics-il.net> wrote:</div>
<br class="Apple-interchange-newline">
<div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: arial, helvetica, sans-serif; font-size: 10pt;">
>From what I could tell from the documentation:
<div><br>
</div>
<div>Full is a snapshot of what the status is of everything at this moment.</div>
<div>Delta is what changed between two specified points in time, regardless if it's current or not.</div>
<div><br>
</div>
<div>Is that right?</div>
<div><br>
</div>
<div>Neither would get me a complete history of any particular number, right?</div>
<div><br>
</div>
<div>I'd have to use someone like 10XPeople (suggested to me offlist) to get a complete history? I'm assuming they just collected the day to day changes from the beginning of time to have a complete record.<br>
<br>
<div><span name="x"></span><br>
<br>
-----<br>
Mike Hammett<br>
Intelligent Computing Solutions<br>
<a href="http://www.ics-il.com/">http://www.ics-il.com</a><br>
<br>
<br>
<br>
Midwest Internet Exchange<br>
<a href="http://www.midwest-ix.com/">http://www.midwest-ix.com</a><br>
<br>
<span name="x"></span><br>
</div>
<br>
<hr id="zwchr">
<div style="font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica, Arial, sans-serif; font-size: 12pt;">
<b>From:<span class="Apple-converted-space"> </span></b>"Paul Timmins" <ptimmins@clearrate.com><br>
<b>To:<span class="Apple-converted-space"> </span></b>"Mike Hammett" <voiceops@ics-il.net><br>
<b>Cc:<span class="Apple-converted-space"> </span></b>"VoiceOps" <voiceops@voiceops.org><br>
<b>Sent:<span class="Apple-converted-space"> </span></b>Wednesday, February 22, 2023 6:17:46 PM<br>
<b>Subject:<span class="Apple-converted-space"> </span></b>Re: [VoiceOps] Neustar SOA Archives<br>
<br>
I enjoyed it. You also get the last SV date and version as some of the fields if you want to know how long it's been on-net (or ported out). Handy.<br>
<div><br>
<blockquote>
<div>On Feb 22, 2023, at 7:11 PM, Mike Hammett <voiceops@ics-il.net> wrote:</div>
<br class="Apple-interchange-newline">
<div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: arial, helvetica, sans-serif; font-size: 10pt;">
Oooh, that sounds fun for my dev guys to work with.<br>
<br>
<div><span></span><br>
<br>
-----<br>
Mike Hammett<br>
Intelligent Computing Solutions<br>
<a href="http://www.ics-il.com/" target="_blank">http://www.ics-il.com</a><br>
<br>
<br>
<br>
Midwest Internet Exchange<br>
<a href="http://www.midwest-ix.com/" target="_blank">http://www.midwest-ix.com</a><br>
<br>
<span></span><br>
</div>
<br>
<hr id="zwchr">
<div style="font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica, Arial, sans-serif; font-size: 12pt;">
<b>From:<span class="Apple-converted-space"> </span></b>"Paul Timmins" <ptimmins@clearrate.com><br>
<b>To:<span class="Apple-converted-space"> </span></b>"Mike Hammett" <voiceops@ics-il.net><br>
<b>Cc:<span class="Apple-converted-space"> </span></b>"VoiceOps" <voiceops@voiceops.org><br>
<b>Sent:<span class="Apple-converted-space"> </span></b>Wednesday, February 22, 2023 5:28:06 PM<br>
<b>Subject:<span class="Apple-converted-space"> </span></b>Re: [VoiceOps] Neustar SOA Archives<br>
<br>
Ask to get a BDD set up from the NPAC and you'll have a copy of the regional LNP database every morning, piping fresh. You'l want to write a script or something because the files are a lot too big for something like excel, but a comparison is easy at that point.<br>
<div><br>
<blockquote>
<div>On Feb 22, 2023, at 6:18 PM, Mike Hammett via VoiceOps <voiceops@voiceops.org> wrote:</div>
<br class="Apple-interchange-newline">
<div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: arial, helvetica, sans-serif; font-size: 10pt;">
How many of you are still using Neustar SOA? Any better ways of getting this information?
<div><br>
</div>
<div>After some personnel changes, we're cleaning up our systems. Things haven't been maintained properly over the years.</div>
<div><br>
</div>
<div>We're going through disabled (but not ported away or deleted) numbers in Metaswitch to see what their fate should be.</div>
<div>I ran an SV search for all ported out numbers, exported to Excel, and then had my staff compare that to what we had configured in Metaswitch, along with seeking their recommendation as to whether we set it to ported out, keep it as-is, or delete the entry
entirely. That recommendation would be with our guidance as to when to do what.</div>
<div>I spot checked their recommendations and found some messes. One of which is that the SOA export just managed to skip one line from 2018, so that was fun. Another is that a number that a former customer had doesn't show up on that list for ported out, but
does show up on the ported in list. When I do an SV Query, it shows up as someone else. How can that be congruent?</div>
<div><br>
</div>
<div>Is there a way to get more that current and 1st prior?</div>
<div>Is the SV search supposed to include everyone that ported away from us, or just those that had us as their first prior carrier?</div>
<div><br>
</div>
<div>I'd like to not have them issue an SV query for each potentially ported away number.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
<div><span></span><br>
<br>
-----<br>
Mike Hammett<br>
Intelligent Computing Solutions<br>
<a href="http://www.ics-il.com/" target="_blank">http://www.ics-il.com</a><br>
<br>
<br>
<br>
Midwest Internet Exchange<br>
<a href="http://www.midwest-ix.com/" target="_blank">http://www.midwest-ix.com</a><br>
<br>
<span></span><br>
</div>
<br>
</div>
</div>
<span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;">
<span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">VoiceOps
mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;">
<a href="mailto:VoiceOps@voiceops.org" target="_blank" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;">VoiceOps@voiceops.org</a><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;">
<a href="https://puck.nether.net/mailman/listinfo/voiceops" target="_blank" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;">https://puck.nether.net/mailman/listinfo/voiceops</a></div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
_______________________________________________<br>
VoiceOps mailing list<br>
VoiceOps@voiceops.org<br>
https://puck.nether.net/mailman/listinfo/voiceops<br>
</div>
</blockquote>
</div>
<br>
</div>
</body>
</html>