06-15-2011 11:08 AM - edited 03-16-2019 05:28 AM
Hello,
I am trying to find a number which was dialed from the business. I'm am running a query via SQL Query Analyzer on the Call Manager Server.
I run this query:
select callingPartyNumber,dateTimeOrigination from CallDetailRecord where finalcalledpartynumber='91796000xxxx'
Which is a number in India. Our service provider has provided a detailed report which only shows a call made from our facility to India. Since it's from our Call Manager they cannot provide what line it originated from.
Does my query look correct? I'm not getting any results. I'm also not getting an error either.
Thank you
06-15-2011 01:37 PM
06-16-2011 05:28 AM
Hi Don, thank you for the response. I will try it this morning and report back. Thank you
06-16-2011 05:30 AM
Wow, that entire syntax is used and run against CDR DB?
06-16-2011 07:28 AM
Yeah... It lets you get pretty granular on your search so you don't retrieve a bunch of extraneous data. It also returns each call leg which I've found useful in troubleshooting. Let me know if it works for you.
Don
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide