|
Home > Archive > Voice over IP Cisco > September 2006 > No of calls made
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]
|
|
| Nick Kassel 2006-09-26, 7:11 am |
| 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
shouldthis e-mail have been incorrectly addressed or transmitted.
Youaccept 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 thatthere
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 sentby e-mail.
You acknowledge that e-mails are not secure and you accept the risk of
malfunction, viruses, unauthorised interference,mis-delivery or delay.
****************************************
****************************************
****************
CharlesStanley & 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.
| |
| Joe Pollere \(US\) 2006-09-26, 1:11 pm |
| You could use a sql query to search the CDR database:
http://www.cisco.com/en/US/partner/...556/products_te
ch_note09186a00801d71c5.shtml
________________________________
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 7:09 AM
To: cisco-voip@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 thelast 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 contactthe sender
immediately
should this e-mail have been incorrectly addressed or transmitted.
You accept that any instructions aredeemed 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
maybe 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 bye-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 &
OptionsExchange.
This footnote also confirms that this email messagehas 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.
| |
| Nick Kassel 2006-09-26, 1:11 pm |
| 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@us.didata.com]
Sent: Tuesday, September 26, 2006 1:27 PM
To: Nick Kassel; cisco-voip@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/...556/products_te
ch_note09186a00801d71c5.shtml
________________________________
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 7:09 AM
To: cisco-voip@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, cananyone 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 orany 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. Ifyou 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 arenot the
intended recipient, any use, disclosure, copying, printing, distribution of,
replying to or any action taken or omitted to be takenin reliance on this
e-mail, is prohibited and may be unlawful. Pleasecontact 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 themand that delivery receipt does not constitute
acknowledgement or receipt by the intended recipient(s). You accept that there
may be a delayin 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.
| |
| Nick Kassel 2006-09-26, 1:11 pm |
| 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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 3:19 PM
To: Joe Pollere (US); cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] No of calls made
Thanks for that Joe, I am alittle confused with the conversion of date
and time though as I haveno sql experience, have you done this?
________________________________
From: Joe Pollere (US) [mailto:Joe.Pollere@us.didata.com]
Sent: Tuesday, September 26, 2006 1:27 PM
To: Nick Kassel; cisco-voip@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/...556/products_te
ch_note09186a00801d71c5.shtml
________________________________
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 7:09 AM
To: cisco-voip@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 howto 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 shouldnot 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 intendedrecipient(s). You accept that
there
may be a delay in processingthe instructions received from e-mails
after
Charles Stanley hasreceived 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. Ifyou 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 arenot the
intended recipient, any use, disclosure, copying, printing, distribution of,
replying to or any action taken or omitted to be takenin reliance on this
e-mail, is prohibited and may be unlawful. Pleasecontact 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 themand that delivery receipt does not constitute
acknowledgement or receipt by the intended recipient(s). You accept that there
may be a delayin 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.
| |
| Nick Kassel 2006-09-26, 1:11 pm |
| 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@cisco.com]
Sent: Tuesday, September 26, 2006 4:18 PM
To: Nick Kassel; cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 10:49 AM
To: cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 3:19 PM
To: Joe Pollere (US); cisco-voip@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@us.didata.com]
Sent: Tuesday, September 26, 2006 1:27 PM
To: Nick Kassel; cisco-voip@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/...556/products_te
ch_n
ote09186a00801d71c5.shtml
________________________________
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 7:09 AM
To: cisco-voip@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.
| |
| Ryan Ratliff 2006-09-26, 1:11 pm |
| 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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 10:49 AM
To: cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 3:19 PM
To: Joe Pollere (US); cisco-voip@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@us.didata.com]
Sent: Tuesday, September 26, 2006 1:27 PM
To: Nick Kassel; cisco-voip@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_tech_n
ote09186a00801d71c5.shtml
________________________________
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 7:09 AM
To: cisco-voip@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.
| |
| Nick Kassel 2006-09-26, 1:11 pm |
| I have entered the formula
select * from CallDetailRecord where datetimeconnect > '1127606400'
and when I click on the check mark it says The command(s) completed
successfully but I don not get any results when I execute the query just
(0 row(s) affected)
Any idea's?
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 4:21 PM
To: Ryan Ratliff; cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] No of calls made
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@cisco.com]
Sent: Tuesday, September 26, 2006 4:18 PM
To: Nick Kassel; cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 10:49 AM
To: cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 3:19 PM
To: Joe Pollere (US); cisco-voip@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@us.didata.com]
Sent: Tuesday, September 26, 2006 1:27 PM
To: Nick Kassel; cisco-voip@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/...556/products_te
ch_n
ote09186a00801d71c5.shtml
________________________________
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 7:09 AM
To: cisco-voip@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.
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
****************************************
****************************************
***************
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.
| |
| Joe Pollere \(US\) 2006-09-26, 1:11 pm |
| That query is correct. I just ran it on a live publisher. Is CDR enabled
under service parameters for all servers?
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 11:34 AM
To: Nick Kassel; Ryan Ratliff; cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] No of calls made
I have entered the formula
select * from CallDetailRecord where datetimeconnect > '1127606400'
and when I click on the check mark it says The command(s) completed
successfully but I don not get any results when I execute the query just
(0 row(s) affected)
Any idea's?
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 4:21 PM
To: Ryan Ratliff; cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] No of calls made
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@cisco.com]
Sent: Tuesday, September 26, 2006 4:18 PM
To: Nick Kassel; cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 10:49 AM
To: cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 3:19 PM
To: Joe Pollere (US); cisco-voip@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@us.didata.com]
Sent: Tuesday, September 26, 2006 1:27 PM
To: Nick Kassel; cisco-voip@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/...556/products_te
ch_n
ote09186a00801d71c5.shtml
________________________________
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 7:09 AM
To: cisco-voip@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.
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
****************************************
********************************
***********************
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.
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
-----------------------------------------
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.
| |
| Mike Lay \(milay\) 2006-09-26, 1:11 pm |
| Are records being inserted into the DB? Are there files backing up in
the \CDR, CMR, & Bad directories? Like stated by someone else, do you
have CDR's & CMR's enabled on all nodes? I assume that the records are
being classified properly....
Mike
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 10:34 AM
To: Nick Kassel; Ryan Ratliff (rratliff); cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] No of calls made
I have entered the formula
select * from CallDetailRecord where datetimeconnect > '1127606400'
and when I click on the check mark it says The command(s) completed
successfully but I don not get any results when I execute the query just
(0 row(s) affected)
Any idea's?
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 4:21 PM
To: Ryan Ratliff; cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] No of calls made
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@cisco.com]
Sent: Tuesday, September 26, 2006 4:18 PM
To: Nick Kassel; cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 10:49 AM
To: cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 3:19 PM
To: Joe Pollere (US); cisco-voip@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@us.didata.com]
Sent: Tuesday, September 26, 2006 1:27 PM
To: Nick Kassel; cisco-voip@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/...556/products_te
ch_n
ote09186a00801d71c5.shtml
________________________________
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 7:09 AM
To: cisco-voip@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.
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
****************************************
********************************
***********************
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.
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Nick Kassel 2006-09-26, 1:11 pm |
| Thanks guys, it appears that the CDR Enabled Flag is set to False and I
have no records in any of the directories. Is this the only way I would
have been able to get this information?
-----Original Message-----
From: Mike Lay (milay) [mailto:milay@cisco.com]
Sent: Tuesday, September 26, 2006 4:54 PM
To: Nick Kassel; Ryan Ratliff (rratliff); cisco-voip@puck.nether.net
Subject: RE: [cisco-voip] No of calls made
Are records being inserted into the DB? Are there files backing up in
the \CDR, CMR, & Bad directories? Like stated by someone else, do you
have CDR's & CMR's enabled on all nodes? I assume that the records are
being classified properly....
Mike
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 10:34 AM
To: Nick Kassel; Ryan Ratliff (rratliff); cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] No of calls made
I have entered the formula
select * from CallDetailRecord where datetimeconnect > '1127606400'
and when I click on the check mark it says The command(s) completed
successfully but I don not get any results when I execute the query just
(0 row(s) affected)
Any idea's?
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 4:21 PM
To: Ryan Ratliff; cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] No of calls made
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@cisco.com]
Sent: Tuesday, September 26, 2006 4:18 PM
To: Nick Kassel; cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 10:49 AM
To: cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 3:19 PM
To: Joe Pollere (US); cisco-voip@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@us.didata.com]
Sent: Tuesday, September 26, 2006 1:27 PM
To: Nick Kassel; cisco-voip@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/...556/products_te
ch_n
ote09186a00801d71c5.shtml
________________________________
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 7:09 AM
To: cisco-voip@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.
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
****************************************
********************************
***********************
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.
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
****************************************
****************************************
***************
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.
| |
| Joe Pollere \(US\) 2006-09-26, 1:11 pm |
| You might be able to look at the calls completed counter under Call
Manager performance counters. I'm not sure if or when they get reset
though. I assume its after a reboot.
Joe
-----Original Message-----
From: Nick Kassel [mailto:Nick.Kassel@Charles-Stanley.co.uk]
Sent: Tuesday, September 26, 2006 12:03 PM
To: Mike Lay (milay); Ryan Ratliff (rratliff);
cisco-voip@puck.nether.net
Cc: Joe Pollere (US)
Subject: RE: [cisco-voip] No of calls made
Thanks guys, it appears that the CDR Enabled Flag is set to False and I
have no records in any of the directories. Is this the only way I would
have been able to get this information?
-----Original Message-----
From: Mike Lay (milay) [mailto:milay@cisco.com]
Sent: Tuesday, September 26, 2006 4:54 PM
To: Nick Kassel; Ryan Ratliff (rratliff); cisco-voip@puck.nether.net
Subject: RE: [cisco-voip] No of calls made
Are records being inserted into the DB? Are there files backing up in
the \CDR, CMR, & Bad directories? Like stated by someone else, do you
have CDR's & CMR's enabled on all nodes? I assume that the records are
being classified properly....
Mike
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 10:34 AM
To: Nick Kassel; Ryan Ratliff (rratliff); cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] No of calls made
I have entered the formula
select * from CallDetailRecord where datetimeconnect > '1127606400'
and when I click on the check mark it says The command(s) completed
successfully but I don not get any results when I execute the query just
(0 row(s) affected)
Any idea's?
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 4:21 PM
To: Ryan Ratliff; cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] No of calls made
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@cisco.com]
Sent: Tuesday, September 26, 2006 4:18 PM
To: Nick Kassel; cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 10:49 AM
To: cisco-voip@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@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 3:19 PM
To: Joe Pollere (US); cisco-voip@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@us.didata.com]
Sent: Tuesday, September 26, 2006 1:27 PM
To: Nick Kassel; cisco-voip@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/...556/products_te
ch_n
ote09186a00801d71c5.shtml
________________________________
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Nick Kassel
Sent: Tuesday, September 26, 2006 7:09 AM
To: cisco-voip@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: | | |