[cisco-voip] CDR report

Thu Mar 30 09:08:40 EST 2006

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 at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Craig M Staffin
Sent: Thursday, March 30, 2006 8:05 AM
To: Lelio Fulgenzi
Cc: cisco-voip-bounces at puck.nether.net; Bill Riley III; Pritchard, Jon;
cisco-voip at 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 at uoguelph.ca> 
Sent by: cisco-voip-bounces at puck.nether.net 

03/29/2006 06:30 PM 

        To:        "Voll, Scott" <Scott.Voll at wesd.org>, "Bill Riley III"
<BRiley at jackhenry.com>, "Pritchard, Jon" <Jon_Pritchard at adp.com> 
        cc:        cisco-voip at 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 at wesd.org> Voll, Scott 
To:  <mailto:lelio at uoguelph.ca> Lelio Fulgenzi ;
<mailto:BRiley at jackhenry.com> Bill Riley III ;
<mailto:Jon_Pritchard at adp.com> Pritchard, Jon 
Cc:  <mailto:cisco-voip at puck.nether.net> cisco-voip at 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 at puck.nether.net>
cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at 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 at puck.nether.net> cisco-voip at 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 at jackhenry.com> Bill Riley III 
To:  <mailto:Jon_Pritchard at adp.com> Pritchard, Jon 
Cc:  <mailto:cisco-voip at puck.nether.net> cisco-voip at 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 at adp.com] 
Sent: Wednesday, March 29, 2006 4:45 PM
To: Bill Riley III
Cc:  <mailto:cisco-voip at puck.nether.net> cisco-voip at 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 at jackhenry.com> BRiley at jackhenry.com>
Subject: [cisco-voip] CDR report
To: < <mailto:cisco-voip at puck.nether.net> cisco-voip at puck.nether.net> 
Message-ID:
< <mailto:13591CB4B2359F4D96E2606DD6B840A0024B7BBD at smoxchg.jhacorp.com>
13591CB4B2359F4D96E2606DD6B840A0024B7BBD at 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 at adp.com> Jon_Pritchard at 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 at puck.nether.net> cisco-voip at puck.nether.net
 <https://puck.nether.net/mailman/listinfo/cisco-voip>
https://puck.nether.net/mailman/listinfo/cisco-voip_________________________
______________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20060330/315c48dc/attachment.html 