[cisco-voip] CDR report

[Craig M Staffin]

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: Voll, Scott 
To: Lelio Fulgenzi ; Bill Riley III ; Pritchard, Jon 
Cc: 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: 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: 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: Bill Riley III 
To: Pritchard, Jon 
Cc: 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: 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" <BRiley at jackhenry.com>
Subject: [cisco-voip] CDR report
To: <cisco-voip at puck.nether.net>
Message-ID:
<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: 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
cisco-voip at puck.nether.net
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/bedcb9c9/attachment-0001.html