[cisco-voip] No of calls made

[Ryan Ratliff]

CDR Insert only runs on the publisher and is responsible for inserting the
CDR records generated by the CM process on each call processing node into
the database.  Since the CDR database only runs on the publisher it wastes
resources if you enable it on a subscriber (and it will throw errors to the
app log stating so if you do run it on a sub). 


-Ryan 
-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 10:49 AM
To: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] No of calls made

I presume I have to have the Cisco CDR Insert service activated for this to
work? I do not have it activated on both of my subscribers, if this is the
case is there no way I can find this information out?

 

________________________________

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 3:19 PM
To: Joe Pollere (US); cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] No of calls made

 

Thanks for that Joe, I am a little confused with the conversion of date and
time though as I have no sql experience, have you done this? 

 

________________________________

From: Joe Pollere (US) [mailto:Joe.Pollere at us.didata.com]
Sent: Tuesday, September 26, 2006 1:27 PM
To: Nick Kassel; cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] No of calls made

 

You could use a sql query to search the CDR database:

 

http://www.cisco.com/en/US/partner/products/sw/voicesw/ps556/products_tech_n
ote09186a00801d71c5.shtml

 

 

 

 

________________________________

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 7:09 AM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] No of calls made

 

I have been asked to try and find out how many calls the Call Managers have
made over the last 12 months, can anyone help with how to extract this sort
of information?

 

 

 


****************************************************************************
*******************

The information contained in this e-mail is strictly confidential, some or
all of which may be legally privileged. It is for the intended recipient
only.
Access to this e-mail by any other person is prohibited. If you are not the
intended recipient, any use, disclosure, copying, printing, distribution of,
replying to or any action taken or omitted to be taken in reliance on this
e-mail, is prohibited and may be unlawful. Please contact the sender
immediately should this e-mail have been incorrectly addressed or
transmitted.

You accept that any instructions are deemed to have been given at the time
the
recipient(s) accesses them and that delivery receipt does not constitute
acknowledgement or receipt by the intended recipient(s). You accept that
there may be a delay in processing the instructions received from e-mails
after Charles Stanley has received them. You are advised that urgent, time
sensitive and confidential communications should not be sent by e-mail. 

You acknowledge that e-mails are not secure and you accept the risk of
malfunction, viruses, unauthorised interference, mis-delivery or delay.
****************************************************************************
********************


Charles Stanley & Co. Ltd
Registered Office: 25 Luke Street London EC2A 4AR

Tel: 0207 739 8200 Fax: 0207 739 7798
Registered in England No. 1903304

Charles Stanley Sutherlands and Charles Stanley Securities are divisions of
Charles Stanley & Co. Ltd

Authorised and Regulated by the Financial Services Authority, Member of the
London Stock Exchange, International Securities Markets Association, and The
London International Financial Futures & Options Exchange.

This footnote also confirms that this email message has been swept by McAfee
VirusScan and SurfControl Email Filter software.

 

 


****************************************************************************
*******************

The information contained in this e-mail is strictly confidential, some or
all of which may be legally privileged. It is for the intended recipient
only.
Access to this e-mail by any other person is prohibited. If you are not the
intended recipient, any use, disclosure, copying, printing, distribution of,
replying to or any action taken or omitted to be taken in reliance on this
e-mail, is prohibited and may be unlawful. Please contact the sender
immediately should this e-mail have been incorrectly addressed or
transmitted.

You accept that any instructions are deemed to have been given at the time
the
recipient(s) accesses them and that delivery receipt does not constitute
acknowledgement or receipt by the intended recipient(s). You accept that
there may be a delay in processing the instructions received from e-mails
after Charles Stanley has received them. You are advised that urgent, time
sensitive and confidential communications should not be sent by e-mail. 

You acknowledge that e-mails are not secure and you accept the risk of
malfunction, viruses, unauthorised interference, mis-delivery or delay.
****************************************************************************
********************


Charles Stanley & Co. Ltd
Registered Office: 25 Luke Street London EC2A 4AR

Tel: 0207 739 8200 Fax: 0207 739 7798
Registered in England No. 1903304

Charles Stanley Sutherlands and Charles Stanley Securities are divisions of
Charles Stanley & Co. Ltd

Authorised and Regulated by the Financial Services Authority, Member of the
London Stock Exchange, International Securities Markets Association, and The
London International Financial Futures & Options Exchange.

This footnote also confirms that this email message has been swept by McAfee
VirusScan and SurfControl Email Filter software.

 




****************************************************************************
*******************

The information contained in this e-mail is strictly confidential, some or
all of which may be legally privileged. It is for the intended recipient
only.
Access to this e-mail by any other person is prohibited. If you are not the
intended recipient, any use, disclosure, copying, printing, distribution of,
replying to or any action taken or omitted to be taken in reliance on this
e-mail, is prohibited and may be unlawful. Please contact the sender
immediately should this e-mail have been incorrectly addressed or
transmitted.

You accept that any instructions are deemed to have been given at the time
the
recipient(s) accesses them and that delivery receipt does not constitute
acknowledgement or receipt by the intended recipient(s). You accept that
there may be a delay in processing the instructions received from e-mails
after Charles Stanley has received them. You are advised that urgent, time
sensitive and confidential communications should not be sent by e-mail. 

You acknowledge that e-mails are not secure and you accept the risk of
malfunction, viruses, unauthorised interference, mis-delivery or delay.
****************************************************************************
********************


Charles Stanley & Co. Ltd
Registered Office: 25 Luke Street London EC2A 4AR

Tel: 0207 739 8200 Fax: 0207 739 7798
Registered in England No. 1903304

Charles Stanley Sutherlands and Charles Stanley Securities are divisions of
Charles Stanley & Co. Ltd

Authorised and Regulated by the Financial Services Authority, Member of the
London Stock Exchange, International Securities Markets Association, and The
London International Financial Futures & Options Exchange.

This footnote also confirms that this email message has been swept by McAfee
VirusScan and SurfControl Email Filter software.
	

________________________________

Disclaimer: This e-mail communication and any attachments may contain
confidential and privileged information and is for use by the designated
addressee(s) named above only. If you are not the intended addressee, you
are hereby notified that you have received this communication in error and
that any use or reproduction of this email or its contents is strictly
prohibited and may be unlawful. If you have received this communication in
error, please notify us immediately by replying to this message and deleting
it from your computer. Thank you.