Voice over IP Cisco - cisco-voip.org Wiki

This is Interesting: Free IT Magazines  
Home > Archive > Voice over IP Cisco > May 2007 > cisco-voip.org Wiki





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]

Author cisco-voip.org Wiki
Carter, Bill

2007-05-29, 1:11 pm

Under cisco Unified Communications Manager I added a section for SQL
queries.

http://cisco-voip.org/viki/index.php/SQL_Queries


Bill Carter
Sr. Business Communications Analyst
Sentinel Technologies
(O) 217.391.5015


Jonathan Charles

2007-05-29, 1:11 pm

These are for 3.x and 4.x?

Does anyone have any useful SQL queries for CCM5?



Jonathan

On 5/29/07, Carter, Bill <bcarter@sentinel.com> wrote:
>
>
> Under cisco Unified Communications Manager I added a section for SQL
> queries.
>
> http://cisco-voip.org/viki/index.php/SQL_Queries
>
>
> Bill Carter
> Sr. Business Communications Analyst
> Sentinel Technologies
> (O) 217.391.5015
>
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>

Matt Slaga \(US\)

2007-05-29, 1:11 pm

No SQL access in 5.x. It's a locked out version of IBM Informix.

-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Jonathan
Charles
Sent: Tuesday, May 29, 2007 11:23 AM
To: Carter, Bill
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] cisco-voip.org Wiki

These are for 3.x and 4.x?

Does anyone have any useful SQL queries for CCM5?



Jonathan

On 5/29/07, Carter, Bill <bcarter@sentinel.com> wrote:
>
>
> Under cisco Unified Communications Manager I added a section for SQL
> queries.
>
> http://cisco-voip.org/viki/index.php/SQL_Queries
>
>
> Bill Carter
> Sr. Business Communications Analyst
> Sentinel Technologies
> (O) 217.391.5015
>
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>

________________________________________
_______
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.
Jonathan Charles

2007-05-29, 1:11 pm

There is plenty of sql access.

The problem is the formatting of the commands...

go to a CCM5 console and type the following:

run sql ?



Jonathan

On 5/29/07, Matt Slaga (US) <Matt.Slaga@us.didata.com> wrote:
> No SQL access in 5.x. It's a locked out version of IBM Informix.
>
> -----Original Message-----
> From: cisco-voip-bounces@puck.nether.net
> [mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Jonathan
> Charles
> Sent: Tuesday, May 29, 2007 11:23 AM
> To: Carter, Bill
> Cc: cisco-voip@puck.nether.net
> Subject: Re: [cisco-voip] cisco-voip.org Wiki
>
> These are for 3.x and 4.x?
>
> Does anyone have any useful SQL queries for CCM5?
>
>
>
> Jonathan
>
> On 5/29/07, Carter, Bill <bcarter@sentinel.com> wrote:
> ________________________________________
_______
> 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.
>

Matt Slaga \(US\)

2007-05-29, 1:11 pm

I stand corrected! Didn't know that existed...

-----Original Message-----
From: Jonathan Charles [mailto:jonvoip@gmail.com]
Sent: Tuesday, May 29, 2007 12:19 PM
To: Matt Slaga (US)
Cc: Carter, Bill; cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] cisco-voip.org Wiki

There is plenty of sql access.

The problem is the formatting of the commands...

go to a CCM5 console and type the following:

run sql ?



Jonathan

On 5/29/07, Matt Slaga (US) <Matt.Slaga@us.didata.com> wrote:
> No SQL access in 5.x. It's a locked out version of IBM Informix.
>
> -----Original Message-----
> From: cisco-voip-bounces@puck.nether.net
> [mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Jonathan
> Charles
> Sent: Tuesday, May 29, 2007 11:23 AM
> To: Carter, Bill
> Cc: cisco-voip@puck.nether.net
> Subject: Re: [cisco-voip] cisco-voip.org Wiki
>
> These are for 3.x and 4.x?
>
> Does anyone have any useful SQL queries for CCM5?
>
>
>
> Jonathan
>
> On 5/29/07, Carter, Bill <bcarter@sentinel.com> wrote:
> ________________________________________
_______
> 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.
>


-----------------------------------------
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.
Jonathan Charles

2007-05-29, 1:11 pm

Yeah, originally, they weren't going to include it, but TAC mandated
that they be able to query SQL directly...

The question is, I have all of these old SQL things for checking
stuff, and now I do not.



Jonathan

On 5/29/07, Matt Slaga (US) <Matt.Slaga@us.didata.com> wrote:
> I stand corrected! Didn't know that existed...
>
> -----Original Message-----
> From: Jonathan Charles [mailto:jonvoip@gmail.com]
> Sent: Tuesday, May 29, 2007 12:19 PM
> To: Matt Slaga (US)
> Cc: Carter, Bill; cisco-voip@puck.nether.net
> Subject: Re: [cisco-voip] cisco-voip.org Wiki
>
> There is plenty of sql access.
>
> The problem is the formatting of the commands...
>
> go to a CCM5 console and type the following:
>
> run sql ?
>
>
>
> Jonathan
>
> On 5/29/07, Matt Slaga (US) <Matt.Slaga@us.didata.com> wrote:
>
> -----------------------------------------
> 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.
>

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com