IPCC help

[chris.damore]

I need to look to see if certain calling numbers called in on certain dates. And see who handled the call. Can someone tell me how to do this in IPCC?

Thanks,

[rossporubski · Accepted solution]

Logon to your publisher server and open query analyzer. Select from the db drop down list CDR

Enter the following:

select * from CallDetailRecord where finalcalledpartynumber='Enter here the specific number dialed' and dateTimeConnect > '1164412800' and dateTimeConnect < '1164585600'

The datetimeconnect is in Julian date format between two specific tims and dates. You can use this to get your Julian date and time:

http://www.minelinks.com/calendar_converter.html

[chris.damore]

Can you be a little more specific? I don't see the fields you list above when I go into SQL query analyzer.

Thanks,

Chris

[chris.damore]

I need to search for calls made from a specific number. Not to a specific number.

[Muhammad Raza]

Yes you can use SQL query analyzer to find your required info from HDS