[cisco-voip] Do I hit "change database" when I open up the SQL analyzer?
Jonathan Charles
jonvoip at gmail.com
Tue Feb 13 15:24:12 EST 2007
First off, don't go into SQL...
You need to open SQL Query Analyzer... after logging in (Windows Auth), then
paste the script into the box and hit the play button...
Be advised, you are connecting directly to the SQL database... if you do an
insert or delete, you are modifying the CCM and CDR live DB... be careful.
Jonathan
On 2/13/07, Miller, Steve <MillerS at dicksteinshapiro.com> wrote:
>
> Exactly. Then, how exactly do I type that script? I'm sorry to be so
> needy, but I'm having a hard time figuring our how to use the instructions.
>
>
> 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 1:02 PM
> *To:* Miller, Steve
> *Subject:* Re: Do I hit "change database" when I open up the SQL analyzer?
>
> I have never seen that before...
>
> You do need to use the:
>
> use cdr
>
> to tell it which DB to query... or you can select it from the dropdown.
>
>
>
> Jonathan
>
> On 2/13/07, Miller, Steve <MillerS at dicksteinshapiro.com> wrote:
> >
> > Do I hit "change database" when I open up the SQL analyzer?
> >
> >
> > 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 10:13 AM
> > *To:* Miller, Steve
> > *Cc:* Cisco Voip
> > *Subject:* Re: [cisco-voip] Most Dialed Outgoing Calls???
> >
> > 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
> > > ==============================================================================
> > >
> > >
> >
> > --------------------------------------------------------
> > 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
> >
> > ==============================================================================
> >
>
> --------------------------------------------------------
> 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/8bb193ec/attachment-0001.html
More information about the cisco-voip
mailing list