
Sort of off-topic, but sort of on. Looking for something that I can plop in some CDRs and paint a nice pretty heat chart picture of where calls are going. Anyone ever undertaken a similar task, if so, would you have a software you'd recommend. Looking to "heat chart" where fraudelent calls are going. -- =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ J. Oquendo SGFA, SGFE, C|EH, CNDA, CHFI, OSCP, CPT, RWSP, GREM "Where ignorance is our master, there is no possibility of real peace" - Dalai Lama 42B0 5A53 6505 6638 44BB 3943 2BF7 D83F 210A 95AF http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x2BF7D83F210A95AF

I have done this with Microsoft map point, though to be honest I have found that its easiest to just do a pie chart of the fraud destination distribution. The most difficult part is getting the country names into the format that Map point wants to see. Getting more granular than country outside north america is excruciating. On 01/09/2014 08:09 AM, J. Oquendo wrote:
Sort of off-topic, but sort of on.
Looking for something that I can plop in some CDRs and paint a nice pretty heat chart picture of where calls are going. Anyone ever undertaken a similar task, if so, would you have a software you'd recommend.
Looking to "heat chart" where fraudelent calls are going.

This is one of those things I've often thought about doing but never found the time to do it. Would make a slick addition to a NOC to view traffic like this real-time. If you come come up with something, let me know. - Chris On 9 Jan 2014, at 11:09, J. Oquendo wrote:
Sort of off-topic, but sort of on.
Looking for something that I can plop in some CDRs and paint a nice pretty heat chart picture of where calls are going. Anyone ever undertaken a similar task, if so, would you have a software you'd recommend.
Looking to "heat chart" where fraudelent calls are going.
-- =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ J. Oquendo SGFA, SGFE, C|EH, CNDA, CHFI, OSCP, CPT, RWSP, GREM
"Where ignorance is our master, there is no possibility of real peace" - Dalai Lama
42B0 5A53 6505 6638 44BB 3943 2BF7 D83F 210A 95AF http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x2BF7D83F210A95AF _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops

Maybe try TransNexus CDRAnalyzer? http://www.transnexus.com/index.php/cdranalyzer If they don't do exactly what you are looking for, they'd probably be willing to add it. There is a free trial and they are good guys over there. Good luck, -Scott On 01/09/2014 03:42 PM, Christopher Aloi wrote:
This is one of those things I've often thought about doing but never found the time to do it.
Would make a slick addition to a NOC to view traffic like this real-time.
If you come come up with something, let me know.
- Chris
On 9 Jan 2014, at 11:09, J. Oquendo wrote:
Sort of off-topic, but sort of on.
Looking for something that I can plop in some CDRs and paint a nice pretty heat chart picture of where calls are going. Anyone ever undertaken a similar task, if so, would you have a software you'd recommend.
Looking to "heat chart" where fraudelent calls are going.
-- =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ J. Oquendo SGFA, SGFE, C|EH, CNDA, CHFI, OSCP, CPT, RWSP, GREM
"Where ignorance is our master, there is no possibility of real peace" - Dalai Lama
42B0 5A53 6505 6638 44BB 3943 2BF7 D83F 210A 95AF http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x2BF7D83F210A95AF _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops
VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops

On Fri, 10 Jan 2014, Scott Berkman wrote:
Maybe try TransNexus CDRAnalyzer? http://www.transnexus.com/index.php/cdranalyzer
If they don't do exactly what you are looking for, they'd probably be willing to add it. There is a free trial and they are good guys over there.
Yea, we use TransNexus, kudos to those guys (James, etc). They are on par 24x7 when we need something. I was thinking something more visual, which perhaps forks off another mail I could send, but opt to attach it here... I am looking for something visual... Something where I can just plop open a global map, where a bubble would say: "oh yea, in country X, there was a lot of fraud destined there" where using this heatmap, one could click a hotspot, and see endpoint calls to block out those area codes, or numbers. Would be community driven, and free to trusted users kind of thing. Think: "Arbor Networks" meets Open Source for VoIP. -- =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ J. Oquendo SGFA, SGFE, C|EH, CNDA, CHFI, OSCP, CPT, RWSP, GREM "Where ignorance is our master, there is no possibility of real peace" - Dalai Lama 42B0 5A53 6505 6638 44BB 3943 2BF7 D83F 210A 95AF http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x2BF7D83F210A95AF

The google geocode API is pretty easy to work with and their mapping tool has a heatmap API. It sounds like the hard part would be mapping calls to latitude/longitude. On Jan 10, 2014, at 12:42 PM, "J. Oquendo" <joquendo at e-fensive.net> wrote: On Fri, 10 Jan 2014, Scott Berkman wrote:
Maybe try TransNexus CDRAnalyzer? http://www.transnexus.com/index.php/cdranalyzer
If they don't do exactly what you are looking for, they'd probably be willing to add it. There is a free trial and they are good guys over there.
Yea, we use TransNexus, kudos to those guys (James, etc). They are on par 24x7 when we need something. I was thinking something more visual, which perhaps forks off another mail I could send, but opt to attach it here... I am looking for something visual... Something where I can just plop open a global map, where a bubble would say: "oh yea, in country X, there was a lot of fraud destined there" where using this heatmap, one could click a hotspot, and see endpoint calls to block out those area codes, or numbers. Would be community driven, and free to trusted users kind of thing. Think: "Arbor Networks" meets Open Source for VoIP. -- =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ J. Oquendo SGFA, SGFE, C|EH, CNDA, CHFI, OSCP, CPT, RWSP, GREM "Where ignorance is our master, there is no possibility of real peace" - Dalai Lama 42B0 5A53 6505 6638 44BB 3943 2BF7 D83F 210A 95AF http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x2BF7D83F210A95AF _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops

I have a database with the city and/or region information for a significant number of USA and non-USA prefixes at http://help.nyigc.net/e164.mysqldump.gz I don't know how useful it would be because it doesn't contain actual V/H or lat/long information The non-USA/non-Canada information is pulled from various filings at the ITU. The USA/Canada info is pulled from nanpa.com and is available elsewhere. Telcordia LERG Routing Guide has V/H info for USA rate centers, but it can be a bit expensive. My database is *not* pulled from the LERG. Updates and additions in CSV format are welcome and can be sent to me off-list. -----Original Message----- From: VoiceOps [mailto:voiceops-bounces at voiceops.org] On Behalf Of PE Sent: Friday, January 10, 2014 1:22 PM To: J. Oquendo Cc: voiceops at voiceops.org Subject: Re: [VoiceOps] (cross post) VoIP heat charts... The google geocode API is pretty easy to work with and their mapping tool has a heatmap API. It sounds like the hard part would be mapping calls to latitude/longitude. On Jan 10, 2014, at 12:42 PM, "J. Oquendo" <joquendo at e-fensive.net> wrote: On Fri, 10 Jan 2014, Scott Berkman wrote:
Maybe try TransNexus CDRAnalyzer? http://www.transnexus.com/index.php/cdranalyzer
If they don't do exactly what you are looking for, they'd probably be willing to add it. There is a free trial and they are good guys over there.
Yea, we use TransNexus, kudos to those guys (James, etc). They are on par 24x7 when we need something. I was thinking something more visual, which perhaps forks off another mail I could send, but opt to attach it here... I am looking for something visual... Something where I can just plop open a global map, where a bubble would say: "oh yea, in country X, there was a lot of fraud destined there" where using this heatmap, one could click a hotspot, and see endpoint calls to block out those area codes, or numbers. Would be community driven, and free to trusted users kind of thing. Think: "Arbor Networks" meets Open Source for VoIP. -- =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ J. Oquendo SGFA, SGFE, C|EH, CNDA, CHFI, OSCP, CPT, RWSP, GREM "Where ignorance is our master, there is no possibility of real peace" - Dalai Lama 42B0 5A53 6505 6638 44BB 3943 2BF7 D83F 210A 95AF http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x2BF7D83F210A95AF _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops
participants (7)
-
ctaloi@gmail.com
-
EWieling@nyigc.com
-
joquendo@e-fensive.net
-
peeip989@gmail.com
-
ryandelgrosso@gmail.com
-
scott@sberkman.net
-
sil@infiltrated.net