Use Windows authentication....
Then:
use cdr
SELECT dateTimeOrigination, callingPartyNumber, finalCalledPartyNumber,
originalCalledPartyNumber, duration
FROM CallDetailRecord
ORDER by finalCalledPartyNumber
and hit the green triangle...
Jonathan
On 2/13/07, Miller, Steve <MillerS at dicksteinshapiro.com> wrote:
>
> In the SQL server window, should I connect using window authentication or
> SQL server authentication?
>
>
> Steve Miller
> Telecom Engineer
> Dickstein Shapiro LLP
> 1825 Eye Street NW | Washington, DC 20006
> Tel (202) 420-3370 Fax (202)-330-5607
> millers at dicksteinshapiro.com
>
>
> ------------------------------
> *From:* Jonathan Charles [mailto:jonvoip at gmail.com]
> *Sent:* Tuesday, February 13, 2007 8:46 AM
> *To:* Miller, Steve
> *Cc:* cisco-voip at puck.nether.net
> *Subject:* Re: [cisco-voip] Most Dialed Outgoing Calls???
>
> Well, you could do a SQL query to the CDR database and then sort by called
> number, export to a csv and check...
>
>
>
> Jonathan
>
> On 2/13/07, Miller, Steve <MillerS at dicksteinshapiro.com> wrote:
> >
> > There must be a way to see the most popular OUTGOING calls on my system,
> > but I can't find it in the CDR. Please let me know what I am missing.
> > Thank you!
> >
> >
> > Steve Miller
> > Telecom Engineer
> > Dickstein Shapiro LLP
> > 1825 Eye Street NW | Washington, DC 20006
> > Tel (202) 420-3370 Fax (202)-330-5607
> > millers at dicksteinshapiro.com
> >
> >
> > -----Original Message-----
> > From: cisco-voip-bounces at puck.nether.net
> > [mailto: cisco-voip-bounces at puck.nether.net] On Behalf Of Erick
> > Bergquist
> > Sent: Tuesday, February 13, 2007 12:08 AM
> > To: Jason Burwell; cisco-voip at puck.nether.net
> > Subject: Re: [cisco-voip] Who called 911
> >
> > You can use CDR Tools And Analysis web page and do a CDR Search for 911
> > or 9911, that searches called and calling party numbers but only
> > displays 100 records.
> >
> > Or this SQL Query, replace 911 with 9911 if you use that or combine
> > them.
> >
> > USE
> > CDR
> > SELECT callingPartyNumber,originalCalledPartyNumber,
> > finalCalledPartyNumber, duration
> >
> > FROM CallDetailRecord
> >
> > WHERE (((originalCalledPartyNumber)="911"))
> >
> > ----- Original Message ----
> >
> >
> > From: Jason Burwell <BurwellJ at firstcharter.com >
> >
> > To: cisco-voip at puck.nether.net
> >
> > Sent: Monday, February 12, 2007 3:20:11 PM
> >
> > Subject: [cisco-voip] Who called 911
> >
> >
> >
> > <!-- /* Style Definitions */
> > p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in;
> > margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";}
> > a:link, span.MsoHyperlink {color:blue; text-decoration:underline;}
> >
> > a:visited, span.MsoHyperlinkFollowed {color:purple;
> > text-decoration:underline;} span.EmailStyle17 { font-family:Arial;
> > color:windowtext;} _filtered { margin:1.0in 1.25in 1.0in 1.25in;}
> > div.Section1 {} --> Hello,
> >
> >
> >
> > Can someone remind me how to find what user dialed 911 in the
> > system? If I recall this information is on the Publisher somewhere in
> > SQL.
> >
> >
> >
> > I am running CCM 4.1(3)es91.
> >
> >
> >
> > Thanks!
> >
> > Jason
> >
> >
> >
> > Jason T. Burwell
> >
> > Infrastructure/Telecommunications
> >
> > First Charter Bank
> >
> > 10200 David Taylor Drive
> >
> > Charlotte, NC 28262
> >
> > ph-704-688-4664
> >
> > fax-704-688-4901
> >
> > www.firstcharter.com
> >
> >
> >
> >
> >
> > _______________________________________________
> >
> > cisco-voip mailing list
> >
> > cisco-voip at puck.nether.net
> >
> > https://puck.nether.net/mailman/listinfo/cisco-voip
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ________________________________________________________________________
> > ____________
> > Sucker-punch spam with award-winning protection.
> > Try the free Yahoo! Mail Beta.
> > http://advision.webevents.yahoo.com/mailbeta/features_spam.html
> >
> > _______________________________________________
> > cisco-voip mailing list
> > cisco-voip at puck.nether.net
> > https://puck.nether.net/mailman/listinfo/cisco-voip
> >
> >
> > --------------------------------------------------------
> > This e-mail message and any attached files are confidential and are
> > intended solely for the use of the addressee(s) named above. This
> > communication may contain material protected by attorney-client, work
> > product, or other privileges. If you are not the intended recipient or
> > person responsible for delivering this confidential communication to the
> > intended recipient, you have received this communication in error, and any
> > review, use, dissemination, forwarding, printing, copying, or other
> > distribution of this e-mail message and any attached files is strictly
> > prohibited. Dickstein Shapiro reserves the right to monitor any
> > communication that is created, received, or sent on its network. If you
> > have received this confidential communication in error, please notify the
> > sender immediately by reply e-mail message and permanently delete the
> > original message.
> >
> > To reply to our email administrator directly, send an email to
> > postmaster at dicksteinshapiro.com
> >
> > Dickstein Shapiro LLP
> > http://www.DicksteinShapiro.com
> > ==============================================================================
> >
> >
> >
> > _______________________________________________
> > cisco-voip mailing list
> > cisco-voip at puck.nether.net
> > https://puck.nether.net/mailman/listinfo/cisco-voip
> >
>
> --------------------------------------------------------
> This e-mail message and any attached files are confidential and are
> intended solely for the use of the addressee(s) named above. This
> communication may contain material protected by attorney-client, work
> product, or other privileges. If you are not the intended recipient or
> person responsible for delivering this confidential communication to the
> intended recipient, you have received this communication in error, and any
> review, use, dissemination, forwarding, printing, copying, or other
> distribution of this e-mail message and any attached files is strictly
> prohibited. Dickstein Shapiro reserves the right to monitor any
> communication that is created, received, or sent on its network. If you have
> received this confidential communication in error, please notify the sender
> immediately by reply e-mail message and permanently delete the original
> message.
>
> To reply to our email administrator directly, send an email to
> postmaster at dicksteinshapiro.com
>
> Dickstein Shapiro LLP
> http://www.DicksteinShapiro.com
>
> ==============================================================================
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20070213/2727d651/attachment-0001.html