|
Home > Archive > Voice over IP Cisco > March 2006 > CDR report
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Candace Holman 2006-03-30, 11:58 pm |
| You have to narrow the search and give your customer a couple of
listings. Narrow by 30 days, or one week, and see if it helps.
Candace
>
> ----- Original Message -----
>
> *From:* Bill Riley III <mailto:BRiley@jackhenry.com>
>
> *To:* cisco-voip@puck.nether.net <mailto:cisco-voip@puck.nether.net>
>
> *Sent:* Wednesday, March 29, 2006 4:49 PM
>
> *Subject:* [cisco-voip] CDR report
>
>
>
> I have a customer that wants to get all of the calls a certain group
> of extensions made for the last 60 days. I am using the built in CDR
> analysis and reporting and when I go to CDR>search>by User/Extension
> and put in the extensions I want to search by, 13XX, and the date
> ranges, it only gives me the first 100 rows. How do I increase the
> output so it will not be truncated?
>
>
>
>
>
> Thanks,
>
> Bill Riley
>
>
>
| |
| Pritchard, Jon 2006-03-30, 11:58 pm |
| We limit to 9.911 for many of our customers and in states where it's
required (like California) we label th phones.
Some customers opt for an outdial code of 8 instead of 9. That helps a
lot.
Jon
________________________________
From: Voll, Scott [mailto:Scott.Voll@wesd.org]
Sent: Wednesday, March 29, 2006 3:31 PM
To: Lelio Fulgenzi; Bill Riley III; Pritchard, Jon
Cc: cisco-voip@puck.nether.net
Subject: RE: [cisco-voip] CDR report
I keep them in for slapping the end users who keep calling 911 then
hanging up.
Speaking of that, what does everyone else do? I route both 9.911 and
911. But I'm seeing a lot of 911 calls. Have people moved to dialing
8. rather then 9. or are people not routing 911 and only 9.911.
Scott
________________________________
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Lelio Fulgenzi
Sent: Wednesday, March 29, 2006 3:20 PM
To: Bill Riley III; Pritchard, Jon
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] CDR report
There is a service parameter to enable/disable 0 lenght CDRs. I keep
them in for troubleshooting.
----- Original Message -----
From: Bill Riley III <mailto:BRiley@jackhenry.com>
To: Pritchard, Jon <mailto:Jon_Pritchard@adp.com>
Cc: cisco-voip@puck.nether.net
Sent: Wednesday, March 29, 2006 5:49 PM
Subject: Re: [cisco-voip] CDR report
I used a SQL query and then converted the time in Excel. I took
out the calls that were 0 and less but isn't there a way to stop them
from being logged in the first place.
SELECT dateTimeOrigination, callingPartyNumber,
finalCalledPartyNumber, originalCalledPartyNumber, duration
FROM CallDetailRecord
WHERE (callingPartyNumber LIKE '13%') AND (duration > '0')
AND (dateTimeOrigination < '1143615600') AND (dateTimeOrigination >
'1138777200')
-----Original Message-----
From: Pritchard, Jon [mailto:Jon_Pritchard@adp.com]
Sent: Wednesday, March 29, 2006 4:45 PM
To: Bill Riley III
Cc: cisco-voip@puck.nether.net
Subject: RE: [cisco-voip] CDR report
No dice. We wrote our own. For a third party take a look at
Syn-Apps call accounting. They do good stuff.
Jon
-----------------------------------------------
Date: Wed, 29 Mar 2006 15:49:49 -0600
From: "Bill Riley III" <BRiley@jackhenry.com>
Subject: [cisco-voip] CDR report
To: <cisco-voip@puck.nether.net>
Message-ID:
< 13591CB4B2359F4D96E2606DD6B840A0024B7BBD
@smoxchg.jhacorp.com>
Content-Type: text/plain; charset="us-ascii"
I have a customer that wants to get all of the calls a certain
group of extensions made for the last 60 days. I am using the built in
CDR analysis and reporting and when I go to CDR>search>by User/Extension
and put in the extensions I want to search by, 13XX, and the date
ranges, it only gives me the first 100 rows. How do I increase the
output so it will not be truncated?
Thanks,
Bill Riley
All Content of this document is ADP
Confidential 2006
Jon Pritchard - Sr. Network Engineer
Network Solutions Group
ADP Dealer Services, 2525 SW First Avenue, Portland, OR 97201
phone: (503) 205-4428, fax: (503) 402-3277
email: Jon_Pritchard@adp.com
This message and any attachments are intended only for the use
of the addressee and may contain information that is privileged and
confidential. If the reader of the message is not the intended recipient
or an authorized representative of the intended recipient, you are
hereby notified that any dissemination of this communication is strictly
prohibited. If you have received this communication in error, please
notify us immediately by e-mail and delete the message and any
attachments from your system.
NOTICE: This electronic mail message and any files transmitted
with it are intended exclusively for the individual or entity to which
it is addressed. The message, together with any attachment, may contain
confidential and/or privileged information. Any unauthorized review,
use, printing, saving, copying, disclosure or distribution is strictly
prohibited. If you have received this message in error, please
immediately advise the sender by reply email and delete all copies.
_______________________________________
________
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system.
| |
| Ed Leatherman 2006-03-30, 11:58 pm |
| We route 911 and 9.911 also. We include that as part of training when we
install IP sets, and I also remind all the contact folks once a month in our
maintenance notice. We also stress that even if they dont mean to call it,
to stay on the line and let the dispatcher know they arent having an
emergency. We still get some hang ups to 911 though, i'm not sure what else
to do about it - management doesnt want us changing the dial patterns.
The message about connecting to emergency services is a good idea.
On 3/29/06, Pritchard, Jon <Jon_Pritchard@adp.com> wrote:
>
> We limit to 9.911 for many of our customers and in states where it's
> required (like California) we label th phones.
>
>
>
> Some customers opt for an outdial code of 8 instead of 9. That helps a
> lot.
>
>
>
> Jon
>
>
> ------------------------------
>
> *From:* Voll, Scott [mailto:Scott.Voll@wesd.org]
> *Sent:* Wednesday, March 29, 2006 3:31 PM
>
> *To:* Lelio Fulgenzi; Bill Riley III; Pritchard, Jon
> *Cc:* cisco-voip@puck.nether.net
> *Subject:* RE: [cisco-voip] CDR report
>
>
>
> I keep them in for slapping the end users who keep calling 911 then
> hanging up.
>
>
>
> Speaking of that, what does everyone else do? I route both 9.911 and
> 911. But I'm seeing a lot of 911 calls. Have people moved to dialing 8.
> rather then 9. or are people not routing 911 and only 9.911.
>
>
>
> Scott
>
>
>
>
>
>
> ------------------------------
>
> *From:* cisco-voip-bounces@puck.nether.net [mailto:
> cisco-voip-bounces@puck.nether.net] *On Behalf Of *Lelio Fulgenzi
> *Sent:* Wednesday, March 29, 2006 3:20 PM
> *To:* Bill Riley III; Pritchard, Jon
> *Cc:* cisco-voip@puck.nether.net
> *Subject:* Re: [cisco-voip] CDR report
>
>
>
> There is a service parameter to enable/disable 0 lenght CDRs. I keep them
> in for troubleshooting.
>
>
>
> ----- Original Message -----
>
> *From:* Bill Riley III <BRiley@jackhenry.com>
>
> *To:* Pritchard, Jon <Jon_Pritchard@adp.com>
>
> *Cc:* cisco-voip@puck.nether.net
>
> *Sent:* Wednesday, March 29, 2006 5:49 PM
>
> *Subject:* Re: [cisco-voip] CDR report
>
>
>
> I used a SQL query and then converted the time in Excel. I took out the
> calls that were 0 and less but isn't there a way to stop them from being
> logged in the first place.
>
>
> SELECT dateTimeOrigination, callingPartyNumber,
> finalCalledPartyNumber, originalCalledPartyNumber, duration
> FROM CallDetailRecord
> WHERE (callingPartyNumber LIKE '13%') AND (duration > '0') AND
> (dateTimeOrigination < '1143615600') AND (dateTimeOrigination >
> '1138777200')
>
> -----Original Message-----
> From: Pritchard, Jon [mailto:Jon_Pritchard@adp.com]
> Sent: Wednesday, March 29, 2006 4:45 PM
> To: Bill Riley III
> Cc: cisco-voip@puck.nether.net
> Subject: RE: [cisco-voip] CDR report
>
> No dice. We wrote our own. For a third party take a look at Syn-Apps
> call accounting. They do good stuff.
>
> Jon
>
> -----------------------------------------------
>
> Date: Wed, 29 Mar 2006 15:49:49 -0600
> From: "Bill Riley III" <BRiley@jackhenry.com>
> Subject: [cisco-voip] CDR report
> To: <cisco-voip@puck.nether.net>
> Message-ID:
> < 13591CB4B2359F4D96E2606DD6B840A0024B7BBD
@smoxchg.jhacorp.com>
> Content-Type: text/plain; charset="us-ascii"
>
> I have a customer that wants to get all of the calls a certain group of
> extensions made for the last 60 days. I am using the built in CDR analysis
> and reporting and when I go to CDR>search>by User/Extension and put in the
> extensions I want to search by, 13XX, and the date ranges, it only gives me
> the first 100 rows. How do I increase the output so it will not be
> truncated?
>
>
> Thanks,
>
> Bill Riley
>
>
> All Content of this document is ADP Confidential
> 2006
> Jon Pritchard - Sr. Network Engineer
> Network Solutions Group
> ADP Dealer Services, 2525 SW First Avenue, Portland, OR 97201
> phone: (503) 205-4428, fax: (503) 402-3277
> email: Jon_Pritchard@adp.com
>
>
>
>
>
>
> This message and any attachments are intended only for the use of the
> addressee and may contain information that is privileged and confidential.
> If the reader of the message is not the intended recipient or an authorized
> representative of the intended recipient, you are hereby notified that any
> dissemination of this communication is strictly prohibited. If you have
> received this communication in error, please notify us immediately by e-mail
> and delete the message and any attachments from your system.
>
>
>
> NOTICE: This electronic mail message and any files transmitted with it are
> intended exclusively for the individual or entity to which it is addressed.
> The message, together with any attachment, may contain confidential and/or
> privileged information. Any unauthorized review, use, printing, saving,
> copying, disclosure or distribution is strictly prohibited. If you have
> received this message in error, please immediately advise the sender by
> reply email and delete all copies.
>
>
>
>
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
> ------------------------------
> This message and any attachments are intended only for the use of the
> addressee and may contain information that is privileged and confidential.
> If the reader of the message is not the intended recipient or an authorized
> representative of the intended recipient, you are hereby notified that any
> dissemination of this communication is strictly prohibited. If you have
> received this communication in error, please notify us immediately by e-mail
> and delete the message and any attachments from your system.
>
>
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>
--
Ed Leatherman
IP Telephony Coordinator
West Virginia University
Telecommunications and Network Operations
| |
| Lelio Fulgenzi 2006-03-30, 11:58 pm |
| This could be done by setting up a Unity CallHandler. It means that your emergency calls depend on Unity being up, but it's an option.
The route patterns already have a blocked route annunciator, it shouldn't be too hard to program an allowed route annunciator. ;)
----- Original Message -----
From: Ed Leatherman
To: Pritchard, Jon
Cc: Voll, Scott ; Lelio Fulgenzi ; Bill Riley III ; cisco-voip@puck.nether.net
Sent: Thursday, March 30, 2006 7:57 AM
Subject: Re: [cisco-voip] CDR report
We route 911 and 9.911 also. We include that as part of training when we install IP sets, and I also remind all the contact folks once a month in our maintenance notice. We also stress that even if they dont mean to call it, to stay on the line and let the dispatcher know they arent having an emergency. We still get some hang ups to 911 though, i'm not sure what else to do about it - management doesnt want us changing the dial patterns.
The message about connecting to emergency services is a good idea.
On 3/29/06, Pritchard, Jon <Jon_Pritchard@adp.com > wrote:
We limit to 9.911 for many of our customers and in states where it's required (like California) we label th phones.
Some customers opt for an outdial code of 8 instead of 9. That helps a lot.
Jon
----------------------------------------------------------------------------
From: Voll, Scott [mailto:Scott.Voll@wesd.org]
Sent: Wednesday, March 29, 2006 3:31 PM
To: Lelio Fulgenzi; Bill Riley III; Pritchard, Jon
Cc: cisco-voip@puck.nether.net
Subject: RE: [cisco-voip] CDR report
I keep them in for slapping the end users who keep calling 911 then hanging up.
Speaking of that, what does everyone else do? I route both 9.911 and 911. But I'm seeing a lot of 911 calls. Have people moved to dialing 8. rather then 9. or are people not routing 911 and only 9.911.
Scott
----------------------------------------------------------------------------
From: cisco-voip-bounces@puck.nether.net [mailto: cisco-voip-bounces@puck.nether.net] On Behalf Of Lelio Fulgenzi
Sent: Wednesday, March 29, 2006 3:20 PM
To: Bill Riley III; Pritchard, Jon
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] CDR report
There is a service parameter to enable/disable 0 lenght CDRs. I keep them in for troubleshooting.
----- Original Message -----
From: Bill Riley III
To: Pritchard, Jon
Cc: cisco-voip@puck.nether.net
Sent: Wednesday, March 29, 2006 5:49 PM
Subject: Re: [cisco-voip] CDR report
I used a SQL query and then converted the time in Excel. I took out the calls that were 0 and less but isn't there a way to stop them from being logged in the first place.
SELECT dateTimeOrigination, callingPartyNumber, finalCalledPartyNumber, originalCalledPartyNumber, duration
FROM CallDetailRecord
WHERE (callingPartyNumber LIKE '13%') AND (duration > '0') AND (dateTimeOrigination < '1143615600') AND (dateTimeOrigination > '1138777200')
-----Original Message-----
From: Pritchard, Jon [mailto:Jon_Pritchard@adp.com]
Sent: Wednesday, March 29, 2006 4:45 PM
To: Bill Riley III
Cc: cisco-voip@puck.nether.net
Subject: RE: [cisco-voip] CDR report
No dice. We wrote our own. For a third party take a look at Syn-Apps call accounting. They do good stuff.
Jon
-----------------------------------------------
Date: Wed, 29 Mar 2006 15:49:49 -0600
From: "Bill Riley III" <BRiley@jackhenry.com>
Subject: [cisco-voip] CDR report
To: <cisco-voip@puck.nether.net>
Message-ID:
< 13591CB4B2359F4D96E2606DD6B840A0024B7BBD
@smoxchg.jhacorp.com>
Content-Type: text/plain; charset="us-ascii"
I have a customer that wants to get all of the calls a certain group of extensions made for the last 60 days. I am using the built in CDR analysis and reporting and when I go to CDR>search>by User/Extension and put in the extensions I want to search by, 13XX, and the date ranges, it only gives me the first 100 rows. How do I increase the output so it will not be truncated?
Thanks,
Bill Riley
All Content of this document is ADP Confidential 2006
Jon Pritchard - Sr. Network Engineer
Network Solutions Group
ADP Dealer Services, 2525 SW First Avenue, Portland, OR 97201
phone: (503) 205-4428, fax: (503) 402-3277
email: Jon_Pritchard@adp.com
This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system.
NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies.
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
----------------------------------------------------------------------------
This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system.
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
--
Ed Leatherman
IP Telephony Coordinator
West Virginia University
Telecommunications and Network Operations
| |
| Craig M Staffin 2006-03-30, 11:58 pm |
| Before you make any changes to 911 dialing check with your local laws. I
know in the state of wisconsin we need to route both 9911 and 911. The
only way around this is if there is a sticker on every phone telling the
people otherwise
Craig
"Lelio Fulgenzi" <lelio@uoguelph.ca>
Sent by: cisco-voip-bounces@puck.nether.net
03/29/2006 06:30 PM
To: "Voll, Scott" <Scott.Voll@wesd.org>, "Bill Riley III"
<BRiley@jackhenry.com>, "Pritchard, Jon" <Jon_Pritchard@adp.com>
cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] CDR report
we route both 911 and 9.911.
i think the best thing is to educate people. have announcements made, etc.
something you do once a month or whatever.
you can consider to not mark 911 as urgent so it waits the interdigit
timeout. but some (including me) may not like the idea. i'm guessing a lot
can happen in 15 seconds.
it would be great if there could be a wave file played just before a call
is routed, so it says something like, please wait while your call is
routed to the city emergency services <2 second pause> then route. this
would give them enough time to hang up and not cause any grief.
----- Original Message -----
From: Voll, Scott
To: Lelio Fulgenzi ; Bill Riley III ; Pritchard, Jon
Cc: cisco-voip@puck.nether.net
Sent: Wednesday, March 29, 2006 6:31 PM
Subject: RE: [cisco-voip] CDR report
I keep them in for slapping the end users who keep calling 911 then
hanging up.
Speaking of that, what does everyone else do? I route both 9.911 and 911.
But I'm seeing a lot of 911 calls. Have people moved to dialing 8.
rather then 9. or are people not routing 911 and only 9.911.
Scott
From: cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Lelio Fulgenzi
Sent: Wednesday, March 29, 2006 3:20 PM
To: Bill Riley III; Pritchard, Jon
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] CDR report
There is a service parameter to enable/disable 0 lenght CDRs. I keep them
in for troubleshooting.
----- Original Message -----
From: Bill Riley III
To: Pritchard, Jon
Cc: cisco-voip@puck.nether.net
Sent: Wednesday, March 29, 2006 5:49 PM
Subject: Re: [cisco-voip] CDR report
I used a SQL query and then converted the time in Excel. I took out the
calls that were 0 and less but isn't there a way to stop them from being
logged in the first place.
SELECT dateTimeOrigination, callingPartyNumber,
finalCalledPartyNumber, originalCalledPartyNumber, duration
FROM CallDetailRecord
WHERE (callingPartyNumber LIKE '13%') AND (duration > '0') AND
(dateTimeOrigination < '1143615600') AND (dateTimeOrigination >
'1138777200')
-----Original Message-----
From: Pritchard, Jon [mailto:Jon_Pritchard@adp.com]
Sent: Wednesday, March 29, 2006 4:45 PM
To: Bill Riley III
Cc: cisco-voip@puck.nether.net
Subject: RE: [cisco-voip] CDR report
No dice. We wrote our own. For a third party take a look at Syn-Apps
call accounting. They do good stuff.
Jon
-----------------------------------------------
Date: Wed, 29 Mar 2006 15:49:49 -0600
From: "Bill Riley III" <BRiley@jackhenry.com>
Subject: [cisco-voip] CDR report
To: <cisco-voip@puck.nether.net>
Message-ID:
< 13591CB4B2359F4D96E2606DD6B840A0024B7BBD
@smoxchg.jhacorp.com>
Content-Type: text/plain; charset="us-ascii"
I have a customer that wants to get all of the calls a certain group of
extensions made for the last 60 days. I am using the built in CDR analysis
and reporting and when I go to CDR>search>by User/Extension and put in the
extensions I want to search by, 13XX, and the date ranges, it only gives
me the first 100 rows. How do I increase the output so it will not be
truncated?
Thanks,
Bill Riley
All Content of this document is ADP Confidential
2006
Jon Pritchard - Sr. Network Engineer
Network Solutions Group
ADP Dealer Services, 2525 SW First Avenue, Portland, OR 97201
phone: (503) 205-4428, fax: (503) 402-3277
email: Jon_Pritchard@adp.com
This message and any attachments are intended only for the use of the
addressee and may contain information that is privileged and confidential.
If the reader of the message is not the intended recipient or an
authorized representative of the intended recipient, you are hereby
notified that any dissemination of this communication is strictly
prohibited. If you have received this communication in error, please
notify us immediately by e-mail and delete the message and any attachments
from your system.
NOTICE: This electronic mail message and any files transmitted with it are
intended exclusively for the individual or entity to which it is
addressed. The message, together with any attachment, may contain
confidential and/or privileged information. Any unauthorized review, use,
printing, saving, copying, disclosure or distribution is strictly
prohibited. If you have received this message in error, please immediately
advise the sender by reply email and delete all copies.
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/lis... />
___________
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Philip Walenta 2006-03-30, 11:58 pm |
| Many places move regular dialing to 8, like Scott had mentioned, and leave
911 and 9.911 as the only things that dial by 9.
This has worked successfully in numerous locations.
Only real catch is user re-training. It does take time for folks to get
used to dialing 8.
_____
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Craig M Staffin
Sent: Thursday, March 30, 2006 8:05 AM
To: Lelio Fulgenzi
Cc: cisco-voip-bounces@puck.nether.net; Bill Riley III; Pritchard, Jon;
cisco-voip@puck.nether.net; Voll, Scott
Subject: Re: [cisco-voip] CDR report
Before you make any changes to 911 dialing check with your local laws. I
know in the state of wisconsin we need to route both 9911 and 911. The only
way around this is if there is a sticker on every phone telling the people
otherwise
Craig
"Lelio Fulgenzi" <lelio@uoguelph.ca>
Sent by: cisco-voip-bounces@puck.nether.net
03/29/2006 06:30 PM
To: "Voll, Scott" <Scott.Voll@wesd.org>, "Bill Riley III"
<BRiley@jackhenry.com>, "Pritchard, Jon" <Jon_Pritchard@adp.com>
cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] CDR report
we route both 911 and 9.911.
i think the best thing is to educate people. have announcements made, etc.
something you do once a month or whatever.
you can consider to not mark 911 as urgent so it waits the interdigit
timeout. but some (including me) may not like the idea. i'm guessing a lot
can happen in 15 seconds.
it would be great if there could be a wave file played just before a call is
routed, so it says something like, please wait while your call is routed to
the city emergency services <2 second pause> then route. this would give
them enough time to hang up and not cause any grief.
----- Original Message -----
From: <mailto:Scott.Voll@wesd.org> Voll, Scott
To: <mailto:lelio@uoguelph.ca> Lelio Fulgenzi ;
<mailto:BRiley@jackhenry.com> Bill Riley III ;
<mailto:Jon_Pritchard@adp.com> Pritchard, Jon
Cc: <mailto:cisco-voip@puck.nether.net> cisco-voip@puck.nether.net
Sent: Wednesday, March 29, 2006 6:31 PM
Subject: RE: [cisco-voip] CDR report
I keep them in for slapping the end users who keep calling 911 then hanging
up.
Speaking of that, what does everyone else do? I route both 9.911 and 911.
But I'm seeing a lot of 911 calls. Have people moved to dialing 8. rather
then 9. or are people not routing 911 and only 9.911.
Scott
_____
From: <mailto:cisco-voip-bounces@puck.nether.net>
cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Lelio Fulgenzi
Sent: Wednesday, March 29, 2006 3:20 PM
To: Bill Riley III; Pritchard, Jon
Cc: <mailto:cisco-voip@puck.nether.net> cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] CDR report
There is a service parameter to enable/disable 0 lenght CDRs. I keep them in
for troubleshooting.
----- Original Message -----
From: <mailto:BRiley@jackhenry.com> Bill Riley III
To: <mailto:Jon_Pritchard@adp.com> Pritchard, Jon
Cc: <mailto:cisco-voip@puck.nether.net> cisco-voip@puck.nether.net
Sent: Wednesday, March 29, 2006 5:49 PM
Subject: Re: [cisco-voip] CDR report
I used a SQL query and then converted the time in Excel. I took out the
calls that were 0 and less but isn't there a way to stop them from being
logged in the first place.
SELECT dateTimeOrigination, callingPartyNumber, finalCalledPartyNumber,
originalCalledPartyNumber, duration
FROM CallDetailRecord
WHERE (callingPartyNumber LIKE '13%') AND (duration > '0') AND
(dateTimeOrigination < '1143615600') AND (dateTimeOrigination >
'1138777200')
-----Original Message-----
From: Pritchard, Jon [mailto:Jon_Pritchard@adp.com]
Sent: Wednesday, March 29, 2006 4:45 PM
To: Bill Riley III
Cc: <mailto:cisco-voip@puck.nether.net> cisco-voip@puck.nether.net
Subject: RE: [cisco-voip] CDR report
No dice. We wrote our own. For a third party take a look at Syn-Apps call
accounting. They do good stuff.
Jon
-----------------------------------------------
Date: Wed, 29 Mar 2006 15:49:49 -0600
From: "Bill Riley III" < <mailto:BRiley@jackhenry.com> BRiley@jackhenry.com>
Subject: [cisco-voip] CDR report
To: < <mailto:cisco-voip@puck.nether.net> cisco-voip@puck.nether.net>
Message-ID:
< < mailto:13591CB4B2359F4D96E2606DD6B840A00
24B7BBD@smoxchg.jhacorp.com>
13591CB4B2359F4D96E2606DD6B840A0024B7BBD
@smoxchg.jhacorp.com>
Content-Type: text/plain; charset="us-ascii"
I have a customer that wants to get all of the calls a certain group of
extensions made for the last 60 days. I am using the built in CDR analysis
and reporting and when I go to CDR>search>by User/Extension and put in the
extensions I want to search by, 13XX, and the date ranges, it only gives me
the first 100 rows. How do I increase the output so it will not be
truncated?
Thanks,
Bill Riley
All Content of this document is ADP Confidential 2006
Jon Pritchard - Sr. Network Engineer
Network Solutions Group
ADP Dealer Services, 2525 SW First Avenue, Portland, OR 97201
phone: (503) 205-4428, fax: (503) 402-3277
email: <mailto:Jon_Pritchard@adp.com> Jon_Pritchard@adp.com
This message and any attachments are intended only for the use of the
addressee and may contain information that is privileged and confidential.
If the reader of the message is not the intended recipient or an authorized
representative of the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by e-mail
and delete the message and any attachments from your system.
NOTICE: This electronic mail message and any files transmitted with it are
intended exclusively for the individual or entity to which it is addressed.
The message, together with any attachment, may contain confidential and/or
privileged information. Any unauthorized review, use, printing, saving,
copying, disclosure or distribution is strictly prohibited. If you have
received this message in error, please immediately advise the sender by
reply email and delete all copies.
________________________________________
_______
cisco-voip mailing list
<mailto:cisco-voip@puck.nether.net> cisco-voip@puck.nether.net
<https://puck.nether.net/mailman/listinfo/cisco-voip>
https://puck.nether.net/mailman/lis..._______________
______________________
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
|
|
|
|
|