|
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]
|
|
| Bill Riley III 2006-03-30, 11:58 pm |
| 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
| |
| Lelio Fulgenzi 2006-03-30, 11:58 pm |
| I opened a case about this and was told to use a third party application if you need more results. 
ugh.
--------------------------------------------------------------------------------
Lelio Fulgenzi, B.A.
Network Analyst (CCS) * university of Guelph * Guelph, Ontario N1G 2W1
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Sanity First : Number of days with fewer than
50 messages in my inbox at the end of the day: 14
----- Original Message -----
From: Bill Riley III
To: 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
------------------------------------------------------------------------------
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Voll, Scott 2006-03-30, 11:58 pm |
| Variphy has a good little application.
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 1:54 PM
To: Bill Riley III; cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] CDR report
I opened a case about this and was told to use a third party application
if you need more results.
ugh.
------------------------------------------------------------------------
--------
Lelio Fulgenzi, B.A.
Network Analyst (CCS) * university of Guelph * Guelph, Ontario N1G 2W1
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Sanity First : Number of days with fewer than
50 messages in my inbox at the end of the day: 14
----- Original Message -----
From: Bill Riley III <mailto:BRiley@jackhenry.com>
To: 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
________________________________
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Pritchard, Jon 2006-03-30, 11:58 pm |
| No dice. We wrote our own. For a third party take a look at Syn-Apps cal=
l 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=3D"us-ascii"
I have a customer that wants to get all of the calls a certain group of ext=
ensions 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 ext=
ensions I want to search by, 13XX, and the date ranges, it only gives me th=
e 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.=A0Network Engineer
Network Solutions Group
ADP Dealer Services, 2525 SW First Avenue, Portland, OR=A0 97201
phone: (503) 205-4428,=A0fax: (503) 402-3277
email: Jon_Pritchard@adp.com
=A0
This message and any attachments are intended only for the use of the addre=
ssee and may contain information that is privileged and confidential. If th=
e reader of the message is not the intended recipient or an authorized repr=
esentative of the intended recipient, you are hereby notified that any diss=
emination of this communication is strictly prohibited. If you have receive=
d this communication in error, please notify us immediately by e-mail and d=
elete the message and any attachments from your system.
| |
| Bill Riley III 2006-03-30, 11:58 pm |
| I used a SQL query and then converted the time in Excel. I took out the ca=
lls that were 0 and less but isn't there a way to stop them from being logg=
ed in the first place. =
SELECT dateTimeOrigination, callingPartyNumber, finalCalledPartyNumber,=
originalCalledPartyNumber, duration
FROM CallDetailRecord
WHERE (callingPartyNumber LIKE '13%') AND (duration > '0') AND (dateTim=
eOrigination < '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 cal=
l 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=3D"us-ascii"
I have a customer that wants to get all of the calls a certain group of ext=
ensions 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 ext=
ensions I want to search by, 13XX, and the date ranges, it only gives me th=
e 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.=A0Network Engineer
Network Solutions Group
ADP Dealer Services, 2525 SW First Avenue, Portland, OR=A0 97201
phone: (503) 205-4428,=A0fax: (503) 402-3277
email: Jon_Pritchard@adp.com
=A0
This message and any attachments are intended only for the use of the addre=
ssee and may contain information that is privileged and confidential. If th=
e reader of the message is not the intended recipient or an authorized repr=
esentative of the intended recipient, you are hereby notified that any diss=
emination of this communication is strictly prohibited. If you have receive=
d this communication in error, please notify us immediately by e-mail and d=
elete 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, co=
pying, disclosure or distribution is strictly prohibited. If you have recei=
ved this message in error, please immediately advise the sender by reply em=
ail and delete all copies.
| |
| Bill Riley III 2006-03-30, 11:58 pm |
| Although I now think to myself exactly how a call could be less than zero b=
ut at least it worked. =
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.ne=
ther.net] On Behalf Of Bill Riley III
Sent: Wednesday, March 29, 2006 4:49 PM
To: Pritchard, Jon
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] CDR report
I used a SQL query and then converted the time in Excel. I took out the ca=
lls that were 0 and less but isn't there a way to stop them from being logg=
ed in the first place. =
SELECT dateTimeOrigination, callingPartyNumber, finalCalledPartyNumber,=
originalCalledPartyNumber, duration
FROM CallDetailRecord
WHERE (callingPartyNumber LIKE '13%') AND (duration > '0') AND (dateTim=
eOrigination < '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 cal=
l 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=3D"us-ascii"
I have a customer that wants to get all of the calls a certain group of ext=
ensions 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 ext=
ensions I want to search by, 13XX, and the date ranges, it only gives me th=
e 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.=A0Network Engineer
Network Solutions Group
ADP Dealer Services, 2525 SW First Avenue, Portland, OR=A0 97201
phone: (503) 205-4428,=A0fax: (503) 402-3277
email: Jon_Pritchard@adp.com
=A0
This message and any attachments are intended only for the use of the addre=
ssee and may contain information that is privileged and confidential. If th=
e reader of the message is not the intended recipient or an authorized repr=
esentative of the intended recipient, you are hereby notified that any diss=
emination of this communication is strictly prohibited. If you have receive=
d this communication in error, please notify us immediately by e-mail and d=
elete 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, co=
pying, disclosure or distribution is strictly prohibited. If you have recei=
ved this message in error, please immediately advise the sender by reply em=
ail and delete all copies.
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Lelio Fulgenzi 2006-03-30, 11:58 pm |
| 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
| |
| Voll, Scott 2006-03-30, 11:58 pm |
| 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
| |
| Lelio Fulgenzi 2006-03-30, 11:58 pm |
| 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/listinfo/cisco-voip
|
|
|
|
|