Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

IPCC help

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,

1 ACCEPTED SOLUTION

Accepted Solutions
New Member

Re: IPCC help

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

4 REPLIES
New Member

Re: IPCC help

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

New Member

Re: IPCC help

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

New Member

Re: IPCC help

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

Re: IPCC help

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

124
Views
0
Helpful
4
Replies
CreatePlease to create content