[cisco-voip] No of calls made

Tue Sep 26 11:20:41 EDT 2006

Ok, I do have the CDR Insert activated on the Publisher, I must be doing
something worn in the query analyser.

-----Original Message-----
From: Ryan Ratliff [mailto:rratliff at cisco.com] 
Sent: Tuesday, September 26, 2006 4:18 PM
To: Nick Kassel; cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] No of calls made

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_te
ch_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. 

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

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.